def updateVaga(self, vars, id):
database = DatabaseManager()
for c in vars:
query = "UPDATE vaga SET {} = '{}' WHERE idVaga = {}".format(
c, vars[c], id)
database.Insert_Drop(query)
def __init__(self, interlocutor_id, interlocutor_name):
# attitudes
self.behaviours = {
'bjr': self.say_same,
'bye': self.say_same,
'q_age': self.answer,
'q_ville': self.answer,
'q_couleur':self.answer,
'q_emploi': self.answer,
'r_age': self.acknowledge,
'r_ville': self.acknowledge,
'r_couleur': self.acknowledge,
'r_emploi': self.acknowledge,
'q_new': self.explain
}
self.initiativeAllowed = ['bjr', 'r_age', 'r_ville', 'r_couleur', 'r_emploi', 'q_new']
# sentiments (modificatuers d'affects)
self.feelings = {
'script': self.hate,
'misunderstand': self.hate,
'lie': self.anger,
'repeat': self.anger,
'similarity': self.enjoy,
'r_new': self.enjoy,
'bjr': self.enjoy,
'q_age': self.like,
'q_ville': self.like,
'q_emploi': self.like,
'q_new': self.like,
'q_couleur':self.like,
'r_age':self.enjoy,
'r_emploi':self.enjoy,
'r_couleur':self.enjoy,
'r_ville':self.enjoy
}
self.modificators = {
'hate':-0.2,
'anger': -0.1,
'joy':0.1,
'like':0.2
}
# Variables utiles
self.db = DatabaseManager()
self.myself = Bot(str(463694828727828511))
self.waiting_new = ""
# On récupère tout sur l'interlocuteur
bot = self.db.getBot(interlocutor_id)
if bot is False:
# Bot inconnu
self.db.insertBot(interlocutor_name, interlocutor_id)
#bot = self.db.getBot(interlocutor_id)
self.interlocutor = Bot(interlocutor_id)
def get_unique_id():
db = DatabaseManager()
while True:
page_id = ''.join(
random.choice(string.ascii_letters + string.digits)
for _ in range(5))
if not db.get_one(id=page_id):
break
return page_id
def insertVaga(self, lat, long, vars):
database = DatabaseManager()
query = "INSERT INTO vaga (nomeVaga, idUsuario, idConhecimento, idIdiomaVaga, cepVaga, latitudeVaga, longitudeVaga, nivelEscolaridade, pcdVaga, vt) VALUES ('{}', {}, {}, {}, {}, {}, {}, '{}', {}, {})".format(
vars["nomeVaga"], vars["idUsuario"], vars["idConhecimento"],
vars["idIdiomaVaga"], vars["cepVaga"], lat, long, vars["nivelEsc"],
vars["pcdVaga"], vars["vt"])
database.Insert_Drop(query)
return True
def show(id):
db = DatabaseManager()
link = db.get_one(id=id)
if link:
db.add_access(id=id)
return redirect(link['link'], 301)
displayed_message.set_message("error_404", id)
redirect('/', 302)
def all_usuario(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT USU_ID, USU_NOMBRE, USU_CORREO, TIP_USU_NOMBRE, USU_BANEADO, PER_NOMBRE, PER_USU_F_I, PER_USU_F_T FROM USUARIO, PERMISO_USUARIO, PERMISO, TIPO_USUARIO WHERE USUARIO.USU_ID = PERMISO_USUARIO.PER_USU_ID AND PERMISO_USUARIO.PER_USU_PER = PERMISO.PER_ID AND USUARIO.USU_TIP_USU = TIPO_USUARIO.TIP_USU_ID;"
cursor.execute(sql)
USUARIO = cursor.fetchall()
db.close()
return USUARIO
def find_usuario(self, USU_ID): # encuentra una usuario en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM USUARIO WHERE USU_ID = " + USU_ID + " LIMIT 1;"
result = cursor.execute(sql)
USUARIO = cursor.fetchone()
db.close()
return USUARIO
def allcarrera(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT CAR_ID, CAR_NOMBRE FROM CARRERA"
cursor.execute(sql)
CARRERA = cursor.fetchall()
db.close()
return CARRERA
def find_almuerzo(self, ALM_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM ALMUERZO WHERE ALM_ID = " + ALM_ID + ";"
result = cursor.execute(sql)
ALMUERZO = cursor.fetchone()
db.close()
return ALMUERZO
def find_kiosco(self, KIO_ID):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID,K.KIO_NOMBRE,K.KIO_CAR_ID,C.CAR_NOMBRE,K.KIO_UNI_ID,U.UNI_NOMBRE,K.KIO_UBICACION FROM KIOSCO as K, UNIVERSIDAD AS U, CARRERA as C WHERE K.KIO_UNI_ID = U.UNI_ID AND K.KIO_CAR_ID = C.CAR_ID AND K.KIO_ID = '" + KIO_ID + "' "
result = cursor.execute(sql)
KIOSCO = cursor.fetchone()
db.close()
return KIOSCO
def search_admin_user(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT USUARIO.USU_NOMBRE FROM USUARIO WHERE USUARIO.USU_TIP_USU = 3;"
cursor.execute(sql)
ADMIN = cursor.fetchall()
db.close()
return ADMIN
def find_kiosco(self, KIO_ALM_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM KIOSCO_ALMUERZO WHERE KIO_ALM_ID = " + KIO_ALM_ID + ";"
result = cursor.execute(sql)
KIOSCO_ALMUERZO = cursor.fetchone()
db.close()
return KIOSCO_ALMUERZO
def almuerzo_precio(self, KIO_FECHA):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT KA.KIO_ALM_ID,A.ALM_ID, A.ALM_NOMBRE,C.CAT_ID,C.CAT_NOMBRE,KA.PRECIO FROM KIOSCO_ALMUERZO as KA, ALMUERZO as A, CATEGORIA as C WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_CAT = C.CAT_ID AND KA.Fecha = '" + KIO_FECHA + "' ORDER BY `KA`.`PRECIO` ASC ;"
cursor.execute(sql)
A_PRECIO = cursor.fetchall()
db.close()
return A_PRECIO
def today_almuerzo(self, KIO_FECHA):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT KA.KIO_ALM_ID,K.KIO_ID, K.KIO_NOMBRE,A.ALM_NOMBRE, KA.PRECIO,KA.HORA,KA.FECHA FROM ALMUERZO as A, KIOSCO_ALMUERZO as KA, KIOSCO as K WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_KIO = K.KIO_ID AND KA.Fecha = '" + KIO_FECHA + "' ORDER BY `A`.`ALM_NOMBRE` ASC;"
cursor.execute(sql)
TODAY = cursor.fetchall()
db.close()
return TODAY
def all_almuerzo(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID, K.KIO_NOMBRE,A.ALM_NOMBRE, KA.PRECIO,KA.HORA,KA.FECHA FROM ALMUERZO as A, KIOSCO_ALMUERZO as KA, KIOSCO as K WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_KIO = K.KIO_ID;"
cursor.execute(sql)
ALMUERZO = cursor.fetchall()
db.close()
return ALMUERZO
def not_assigned(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID, K.KIO_NOMBRE FROM KIOSCO as K WHERE K.KIO_ID NOT IN (SELECT K.KIO_ID FROM KIOSCO_USUARIO AS KU, KIOSCO AS K, USUARIO AS U WHERE KU.KIO_USU_KIO = K.KIO_ID AND KU.KIO_USU_ID = U.USU_ID AND KU.KIO_USU_F_T = '0000-00-00');"
cursor.execute(sql)
NOTASG = cursor.fetchall()
db.close()
return NOTASG
def search_kioUsuario(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT U.USU_NOMBRE, U.USU_CORREO, K.KIO_NOMBRE,KU.KIO_USU_F_I,KU.KIO_USU_F_T FROM KIOSCO_USUARIO AS KU, KIOSCO AS K, USUARIO AS U WHERE KU.KIO_USU_KIO = K.KIO_ID AND KU.KIO_USU_ID = U.USU_ID AND KU.KIO_USU_F_T = '0000-00-00' ORDER BY `KU`.`KIO_USU_F_I` DESC;"
cursor.execute(sql)
KUSUARIO = cursor.fetchall()
db.close()
return KUSUARIO
def find_carrera(self, CAR_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM CARRERA WHERE CAR_ID = " + CAR_ID + ";"
result = cursor.execute(sql)
CARRERA = cursor.fetchone()
db.close()
return CARRERA
def all_categoria(self): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT CAT_ID,CAT_NOMBRE FROM CATEGORIA;" cursor.execute(sql) CATEGORIA = cursor.fetchall() db.close() return CATEGORIA
def all_kiosco(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID,K.KIO_NOMBRE,C.CAR_NOMBRE, U.UNI_NOMBRE, K.KIO_UBICACION, K.KIO_APERTURA, K.KIO_CERRAR FROM KIOSCO as K, CARRERA as C, UNIVERSIDAD as U WHERE K.KIO_CAR_ID = C.CAR_ID AND K.KIO_UNI_ID = U.UNI_ID;"
cursor.execute(sql)
KIOSCO = cursor.fetchall()
db.close()
return KIOSCO
def search_categorias(self,CAT_ID): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT CAT_NOMBRE FROM CATEGORIA WHERE CAT_ID = '"+CAT_ID+"';" cursor.execute(sql) S_CATEGORIA = cursor.fetchall() db.close() return S_CATEGORIA
def all_almuerzo(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT ALM_ID, ALM_NOMBRE FROM ALMUERZO"
cursor.execute(sql)
ALMUERZO = cursor.fetchall()
db.close()
return ALMUERZO
def categorias_existentes(self): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT C.CAT_ID, C.CAT_NOMBRE FROM KIOSCO_ALMUERZO as KA, CATEGORIA as C WHERE KA.KIO_ALM_CAT = C.CAT_ID GROUP BY C.CAT_ID ;" cursor.execute(sql) CATEGORIA_E = cursor.fetchall() db.close() return CATEGORIA_E
def all(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT id, title, description FROM posts"
cursor.execute(sql)
posts = cursor.fetchall()
db.close()
return posts
def search_almu_categoria(self,KA_CATEGORIA,KA_DATE): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT KA.KIO_ALM_ID,K.KIO_ID,K.KIO_NOMBRE,A.ALM_ID,A.ALM_NOMBRE,C.CAT_ID,C.CAT_NOMBRE, KA.PRECIO, KA.HORA FROM KIOSCO_ALMUERZO as KA, CATEGORIA as C, KIOSCO as K, ALMUERZO as A WHERE KA.KIO_ALM_CAT = C.CAT_ID AND KA.KIO_ALM_KIO = K.KIO_ID AND KA.KIO_ALM_ALM = A.ALM_ID AND C.CAT_ID = '"+KA_CATEGORIA+"' AND KA.Fecha = '"+KA_DATE+"';" cursor.execute(sql) KA_CAT = cursor.fetchall() db.close() return KA_CAT
def all_tipousuario(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT TIP_USU_ID, TIP_USU_NOMBRE FROM TIPO_USUARIO"
cursor.execute(sql)
TIPO_USUARIO = cursor.fetchall()
db.close()
return TIPO_USUARIO
def all_permiso(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT PER_ID, PER_NOMBRE FROM PERMISO"
cursor.execute(sql)
PERMISO = cursor.fetchall()
db.close()
return PERMISO
def all(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT MED_PAG_ID, MED_PAG_NOMBRE FROM MEDIO_PAGO"
cursor.execute(sql)
MEDIO_PAGO = cursor.fetchall()
db.close()
return MEDIO_PAGO
def find_permiso(self, PER_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM PERMISO WHERE PER_ID = " + PER_ID + ";"
result = cursor.execute(sql)
PERMISO = cursor.fetchone()
db.close()
return PERMISO
def search_admKiosco(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT USU_ID, USU_NOMBRE, USU_CORREO FROM USUARIO WHERE USU_TIP_USU = '2' AND USU_BANEADO = '0' GROUP BY USU_NOMBRE;"
cursor.execute(sql)
ADMKIOSCO = cursor.fetchall()
db.close()
return ADMKIOSCO
from django.shortcuts import render, render_to_response, redirect
from django.core.urlresolvers import reverse
from django.http import HttpResponse, HttpResponseRedirect
from db import DatabaseManager
db_manager = DatabaseManager()
db_manager.prepare()
# Create your views here.
def flights(request):
if request.method == "GET":
query = db_manager.SelectAllFlights()
return render(request, 'lab2/flights.html', {"query": query})
elif request.method == "POST":
query = db_manager.SelectAllFlights()
print request.POST
if request.POST.get("Find") is not None:
return HttpResponseRedirect("find")
elif request.POST.get("Ins") is not None:
return HttpResponseRedirect("add")
elif request.POST.get("Delete") is not None:
print(int(request.POST.get("Delete").split("_")[1]))
db_manager.DeleteFlight(request.POST.get("Delete").split("_")[1])
return HttpResponseRedirect("flights")
elif request.POST.get("Edit") is not None:
def main():
db = DatabaseManager(args.sqlite_file, args.keep)
db.create_db()
if not os.path.isfile(args.xml_file):
print("The XML file does not exist")
exit(1)
tree = ET.parse(args.xml_file)
root = tree.getroot()
categories = root.find('Categories')
products = root.find('Products')
for category in categories:
name = category.findtext('Name')
category_id = category.findtext('CategoryUniqueID')
parent_id = category.findtext('CategoryParentID')
db.add_category(name, category_id, parent_id)
db.commit()
for product in products:
name = product.findtext('Name')
product_id = product.findtext('ProductUniqueID')
url = product.findtext('ProductUrl')
image = product.findtext('ImageUrl')
description = product.findtext('Description')
price = product.findtext('Price')
stock = product.findtext('Stock')
availability = product.findtext('Availability')
color = product.findtext('Color')
parent_id = product.findtext('ParentID')
category = product.find('CategoriesID')
category_id = category.findtext('CategoryID') if category else ''
eans = product.find('EANs')
ean = fix_str(eans.findtext('EAN')) if eans else ''
isbns = product.find('ISBNs')
isbn = fix_str(isbns.findtext('ISBN')) if isbns else ''
upcs = product.find('UPCs')
upc = upcs.findtext('UPC') if upcs else ''
db.add_product(name, product_id, url, image, description, category_id, ean, isbn, price, stock, availability, color, parent_id, upc)
db.commit()
