def getDataTv(prov=None):
if prov is None:
query = """SELECT * FROM table_tv"""
else:
query = """SELECT * FROM table_tv WHERE (provedor='""" + str(
prov) + """')"""
response = json.dumps(consulta_db.consulta_BD(query))
response = make_response(response)
return response
def getCelByPlan(tipo=None):
if tipo is None:
query = """SELECT * FROM table_celular"""
else:
query = """SELECT * FROM table_celular WHERE (plano='""" + str(
tipo) + """')"""
response = json.dumps(consulta_db.consulta_BD(query))
response = make_response(response)
return response
def getDataFixo(op=None):
if op is None:
query = """SELECT * FROM table_fixo"""
else:
query = """SELECT * FROM table_fixo WHERE (operadora='""" + str(
op) + """')"""
response = json.dumps(consulta_db.consulta_BD(query))
response = make_response(response)
return response
def getUsuario(email=None):
query = """SELECT * FROM table_usuario WHERE (email='""" + str(
email) + """')"""
response = json.dumps(consulta_db.consulta_BD(query))
response = make_response(response)
return response
def get_users(self):
query = """SELECT id, email, senha FROM table_usuario"""
rows = consulta_db.consulta_BD(query)
return rows