def obtener_deuda(prestador_name, deudor_name):
query = "SELECT monto FROM deuda WHERE prestadorName='%s' AND deudorName='%s';" % (prestador_name, deudor_name)
result = db.get(query)
if not result == []:
return result[0][0]
else:
return None
def obtener_deudas():
query = "SELECT * from deuda;"
return db.get(query)
def obtener_usuarios():
query = "SELECT * from user;"
return db.get(query)
def consultar_deudores(prestador_name):
query = "SELECT * FROM deuda WHERE prestadorName='%s';" % prestador_name
return db.get(query)
def consultar_deuda(deudor_name):
query = "SELECT * FROM deuda WHERE deudorName='%s';" % deudor_name
return db.get(query)
def existe_usuario(user_name):
query = "SELECT * FROM user WHERE name='%s';" % user_name
return len(db.get(query)) > 0