Port news from API to DB

news_to_db.py

import urllib.request, json 
with urllib.request.urlopen("https://us-central1-newsproject-41eb3.cloudfunctions.net/getLatestCoronaNews") as url:
    data = json.loads(url.read().decode())
    
news = data['data'][0]['data']

query = "INSERT INTO news (url, title, description, content, published, imageUrl) VALUES (%s, %s, %s, %s, %s, %s)"

for n in news:

    t = (n['url'], n['title'],n['description'],n['content'], n['publishedAt'], n['urlToImage'])
    print(t)

    mycursor.execute(query, t)
    mydb.commit()