Intermediate Python Assignment 3 Due Date: December 1st by 11:30PM The objective of every assignment is to make sure you practice what we learned throughout the modules to cement your learning. Every...

1 answer below »
i have my account locally with php admin, i need the program created and what i need to do in PHP admin to set it up on my end written out in steps and explained if possible


Intermediate Python Assignment 3 Due Date: December 1st by 11:30PM The objective of every assignment is to make sure you practice what we learned throughout the modules to cement your learning. Every assignment is based on a real-life scenario to prepare you for a job in the industry. Assignment 3 covers topics that we will cover in module 5. A Computer Scientist would like a program that stores the total count of Python repositories, Java repositories and Swift repositories with a timestamp into a database. You can create the database utilizing PHPMyAdmin locally. To get started you must first create a database and a table in PHPMyAdmin the table with data inserted should look like this: TimeStamp (string or timestamp) PythonRepos (integer) SwiftRepos (integer) JavaRepos (integer) 2019-08-08 45869 458669 455662328 You must make three API calls and store them into the database with the same timestamp. Every time you run the program; a new row will be added to your database table! Because the database is local, you must screenshot your database table within PHPMyAdmin in order to show me that the program works. Deliverables: • Commented code (.py file) • Screenshot of the database table (.png or .jpeg) • Screenshot of the git log showing that you utilized git throughout the development process. • All the above-mentioned files must be zipped into one zip file named studentNumber_StudentName_Assignment3 and submitted via D2L by the deadline mentioned above.
Answered Same DayJul 16, 2021

Answer To: Intermediate Python Assignment 3 Due Date: December 1st by 11:30PM The objective of every assignment...

Sanghamitra answered on Jul 17 2021
141 Votes
61941/61941.py
"""
Created on Fri Jul 17 11:07:34 2020
@author: Mike Mawson
"""
#Importing requests
import requests
#import
mysql.connector
import pymysql
#API Call to get java reositories count from github
java_repo = 'https://api.github.com/search/repositories?q=language:java&sort=stars'
jcount_response = requests.get(java_repo).json()
java_repo_count = jcount_response ['total_count']
#Getting the total count of repos.
print(f"Total Java Repositories: {java_repo_count}")
#API Call to get python reositories count from github
python_repo = 'https://api.github.com/search/repositories?q=language:python&sort=stars'
pcount_response = requests.get(python_repo).json()
python_repo_count = pcount_response['total_count']
#Getting the total count of repos.
print(f"Total Python Repositories: {python_repo_count}")
#API Call to get swift reositories count from github
swift_repo = 'https://api.github.com/search/repositories?q=language:swift&sort=stars'
scount_response = requests.get(swift_repo).json()
swift_repo_count = scount_response['total_count']
#Getting the total count of repos.
print(f"Total Swift Repositories: {swift_repo_count}")
# #The Mysql connection object requires four parameters:
# #1- Host name in my case its localhost
# #2-...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here