mysql query to json

gistfile1.txt

import mysql.connector as mysql
import simplejson as json
import sys

def cursor_to_dict(cursor):
    data = cursor.fetchone()

    if data is None:
        return None

    desc = cursor.description

    result = {}

    for (name, value) in zip(desc, data):
        result[name[0]] = value

    return result

db = mysql.connect(
    host = "127.0.0.1",
    user = "root",
    passwd = "root",
    database = "database",
    port = "3306"
)

cursor = db.cursor()

## defining the Query
query = """
SELECT 
  *
FROM 
  table
WHERE 
  1=1
"""

cursor.execute(query)
sys.stdout.write('[')
row = cursor_to_dict(cursor)
first_line = True

while row is not None:

    if first_line == True:
        first_line = False
    else:
        sys.stdout.write(',')

    json_str = json.dumps(row, default=str)
    sys.stdout.write(json_str)
    row = cursor_to_dict(cursor)

sys.stdout.write(']')