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()