import mysql.connector
import json

conn = mysql.connector.connect(
  host      = "localhost",
  user      = "root",
  passwd    = "polopo123",
  database  = "universidad"
)

cursor = conn.cursor()
universidad = []
cursor.execute("SELECT * FROM prueba;")
resultF = cursor.fetchall()
facultades = []
for rowF in resultF:
    universidad.append({'Piso' : rowF[0], 'Baño' : rowF[1], 'Inicio alerta' : rowF[2], 'Fin alerta' : rowF[3], 'Tiempo de reposicion' : rowF[4]})
json.dumps({universidad})

with open('universidad.json', 'w+') as outfile:
    json.dump(universidad, outfile)
conn.close()