Пример #1
0
def contar_observados():
    cur, conn = conexion.conectar()
    query1="SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 1 AND `observado` = TRUE"
    result1 = login.run_query(query1)
    query2="SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 2 AND `observado` = TRUE"
    result2 = login.run_query(query2)
    query3="SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 3 AND `observado` = TRUE"
    result3 = login.run_query(query3)
    results = {'candidato1' : result1, 'candidato2' : result2, 'en_blanco' : result3}
    return results
    cerrar_conexion(cur,conn)
Пример #2
0
def contar():
    cur, conn = conexion.conectar("guest", "")
    query1 = "SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 1"
    result1 = login.run_query(query1)
    query2 = "SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 2"
    result2 = login.run_query(query2)
    query3 = "SELECT COUNT(*) FROM `votos` WHERE `opcion_voto` = 3"
    result3 = login.run_query(query3)
    results = {'candidato1' : result1, 'candidato2' : result2, 'en_blanco' : result3}
    return results
    cerrar_conexion(cur,conn)
Пример #3
0
def run_query(query=""):
    cur, conn = conexion.conectar("guest","")
    cur.execute(query)          # Ejecutar una consulta
    data = None
    if query.upper().startswith('SELECT'):
        dat = cur.fetchall();
        for registro in dat:
            data = registro[0]

    else:
        conn.commit()              # Hacer efectiva la escritura de datos
        data = None

    conexion.cerrar_conexion(cur,conn)

    return data