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()