- Home
- Course Detail
regularpython@gmail.com
You are now watching:
Python Dictionary / of Python Dictionary Real-Time Examples
import requests import json from beautifultable import BeautifulTable import MySQLdb table = BeautifulTable() table.column_headers = ["userId", "Id","title"] table.column_alignments['title'] = BeautifulTable.ALIGN_LEFT try: connection = MySQLdb.connect(user='root',password='sairam143sairam',port=3306,host='localhost') except Exception as e: print(e) else: datacursor = connection.cursor() resp = requests.get("https://jsonplaceholder.typicode.com/posts") users = json.loads(resp.text) for user in users: print(user) datacursor.execute("INSERT INTO dummydat.new_table (userId, idnumer, title) VALUES ('"+str(user['userId'])+"', '"+str(user['id'])+"', '"+user['title']+"');") connection.commit() connection.close()