import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  password="mypassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM customers")

posts = [dict(title=row[0], text=row[1]) for row in mycursor.fetchall()]

for x in posts:
  print(x)