MySQL resultset into Json

from mysql import connector
import json

connection = connector.connect(host = 'localhost', database = 'testdb', user = 'root', password = 'root')

cursor = connection.cursor()
cursor.execute('select * from product')
products = cursor.fetchall()

prodcode=list()
prodname=list()

for product in products:
      
      prodcode.append(product[0]) 
      prodname.append(product[1])

connection.close()

result=zip(prodcode,prodname)
prod=dict(result)
s=json.dumps(prod,separators=(',', ':'))
open('product.json','w').write(s)

Output:

{“A100″:”PenDrive”,”A102″:”TV”,”A103″:”BlueRay Player”,”B100″:”Mouse”,”B101″:”Keyboard”,”B102″:”Monitor”,”C300″:”Speakers”}