def index(): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) wid = "1" TablaServicioAutomotor = dict() TablaServicioAutomotor = { 'TABLE': 'products', 'Col1': 'id_product', 'Col2': 'id_proveedor', 'Col3': 'id_categoria', 'Col4': 'name', 'Col5': 'precio', 'Col6': 'descripcion', 'Whe7': 'id_product=%s' } Data = (wid, ) url_product = "/home/product" + "_" + wid + ".html" DatosServicioV = connect.SW_TABLE(username, TablaServicioAutomotor, Data) print(DatosServicioV) id_pdt = "/static/imgs/img_product_" + wid + ".jpeg" return render_template("/home/index.html", url=urlrev, Oferta_Servicio=DatosServicioV, id_pdt=id_pdt)
def Category_id(): Urlbase = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) req = request.get_json() id_categoria = req["id_categoria"] wid = id_categoria TablaServicioAutomotor = dict() TablaServicioAutomotor = { 'TABLE': 'products', 'Col1': 'id_product ', 'Col2': 'id_proveedor', 'Col3': 'id_categoria', 'Col4': 'name', 'Col5': 'precio', 'Col6': 'descripcion', 'Col7': 'media', 'Whe8': 'id_categoria=%s' } Data = (wid, ) DatosServicioV = connect.SW_TABLE(username, TablaServicioAutomotor, Data) print(DatosServicioV) DatosAllMedia = json.dumps(DatosServicioV) return (DatosAllMedia)
def Servicios(id): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect=Model(username) wid = id TablaServicioAutomotor = dict() TablaServicioAutomotor = {'TABLE':'servicio', 'Col1':'id', 'Col2':'tipo', 'Col3':'costo', 'Col4':'detalles', 'Col5':'automotor', 'Whe6':'automotor=%s' } Data = (wid,) DatosServicioV = connect.SW_TABLE(username,TablaServicioAutomotor, Data) return render_template("/lavasplash/Servicios.html", url = urlrev, Oferta_Servicio = DatosServicioV)
def VerDetallesServicio(id): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect=Model(username) TSSOfServicio = dict() wid = id TSSOfServicio = {'TABLE':'servicio', 'Col1':'id', 'Col2':'tipo', 'Col3':'costo', 'Col4':'detalles', 'Whe5':'id=%s' } Data = (wid,) DatosOfServicio = connect.SW_TABLE(username,TSSOfServicio, Data) return render_template("/lavasplash/ActualizarServicio.html", url = urlrev, Oferta_Servicio = DatosOfServicio)
def palabra(): Urlbase = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) req = request.get_json() wid = req["nro_crucigrama"] #wid = "1" TSSPalabras = {'TABLE': 'crucigrama', 'Col1': 'palabras', 'Whe2': 'id=%s'} Data = (wid, ) EnCrucigrama = connect.SW_TABLE(username, TSSPalabras, Data) cx = "*" Total_palabras = EnCrucigrama[0]["palabras"] palabra = req["palabra"] cx += palabra acierto = True for item in req["coordenadas"]: coord = req["coordenadas"][item] cx += coord mtrix_palabras = Total_palabras.split("*") palabras_in_crucigrama = "" x_palabra = cx.strip("*") if x_palabra in mtrix_palabras: acierto = True else: acierto = False if (acierto): result = { "palabra": req["palabra"], "coordenadas": req["coordenadas"], "acierto": True } else: result = { "palabra": req["palabra"], "coordenadas": req["coordenadas"], "acierto": False } res = make_response(jsonify({"message": "OK"}), 200) return result
def perfil(): Sql = "ddasddf" url = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) Nick = "Redoxfox" TSWusers = dict() TSWusers = { 'TABLE': 'users', 'Col1': 'nick', 'Col2': 'password', 'Col3': 'salt', 'Whe4': 'nick=%s' } Data = (Nick, ) DatosUsers = connect.SW_TABLE(username, TSWusers, Data) return render_template("/home/perfil.html", url=url, lista=DatosUsers)
def images(): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) wid = "0" Tabla_All_Images = dict() Tabla_All_Images = { 'TABLE': 'products ORDER BY name', 'Col1': 'id_product', 'Col2': 'name', 'Col3': 'media', 'Col4': 'precio', 'Whe5': 'id_product>%s' } Data = (wid, ) # SW_TABLE(username,TablaServicioAutomotor, Data) DatosAllImages = connect.SW_TABLE(username, Tabla_All_Images, Data) DatosAllImages_json = json.dumps(DatosAllImages) return (DatosAllImages_json)
def reg_prestado(id): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect=Model(username) wid = id TSSServicioPtado = dict() TSSServicioPtado = {'TABLE':'servicio', 'Col1':'id', 'Col2':'tipo', 'Col3':'costo', 'Whe4':'id=%s' } Data = (wid,) DatosServicioPtado = connect.SW_TABLE(username,TSSServicioPtado, Data) TSSClient = dict() TSSClient = {'TABLE':'clientes', 'Col1':'id', 'Col2':'nombre' } DatosClient = connect.SSP_TABLE(username,TSSClient) return render_template("/lavasplash/form_registro_servicio.html", url = urlrev, servicios = DatosServicioPtado, clientes=DatosClient)
def validar(): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) if request.method == "POST": nick = request.form["username"] password = request.form["password"] wid = nick TSWusers = dict() TSWusers = {'TABLE': 'users', 'Col1': 'nick', 'Col2': 'password', 'Col3': 'salt', 'Col4': 'tipo_user', 'Whe5': 'nick=%s' } Data = (wid,) DatosUsers = connect.SW_TABLE(username, TSWusers, Data) if DatosUsers: password_userbd = DatosUsers[0]['password'] salt_userbd = DatosUsers[0]['salt'] tipo_user = DatosUsers[0]['tipo_user'] hash= validaciones.Validar() h2=hash.check_password(password_userbd, password, salt_userbd) if h2 == True and tipo_user=="admin": #return render_template("/admin/principal.html") return redirect(url_for('admin')) else: return render_template("/registro/login.html") else: return render_template("/registro/login.html") ''' password_userbd = DatosUsers[0]['password']
def media(id): urlrev = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) wid = id TablaMedia = dict() TablaMedia = { 'TABLE': 'media', 'Col1': 'id', 'Col2': 'id_product', 'Col3': 'img', 'Col4': 'video', 'Col5': 'tipo', 'Whe6': 'id_product=%s' } Data = (wid, ) DatosMedia = connect.SW_TABLE(username, TablaMedia, Data) DatosAllMedia = json.dumps(DatosMedia) #print(DatosMedia) return (DatosAllMedia)
def sopa_letters(): Urlbase = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) #urlrev = URLBASE if request.method == "POST": id_topic = request.form['topic'] else: id_topic = "1" print(id_topic) num_palabras = 0 TSSTopico = {'TABLE': 'grupo', 'Col1': 'id', 'Col2': 'topico'} DatosTopico = connect.SSP_TABLE(username, TSSTopico) wid = id_topic TSSVocabulary = { 'TABLE': 'vocabulary', 'Col1': 'id', 'Col2': 'english', 'Col3': 'spanish', 'Col4': 'grupo', 'Col5': 'ejemplos', 'Whe6': 'grupo=%s' } Data = (wid, ) PalabrasCrucigrama = connect.SW_TABLE(username, TSSVocabulary, Data) list_palabras = [] list_id = [] Palabras_in_Crucigrama = [] for items in PalabrasCrucigrama: list_id.append(items["id"]) acierto = 0 num_palabras = 0 while num_palabras < 15: value_palabra = randint(0, len(list_id) - 1) palabra_select = PalabrasCrucigrama[value_palabra]["english"] palabra_select = re.sub(r"\s+", "", palabra_select, flags=re.UNICODE) num_letras = len(palabra_select) nueva_palabra = {} if acierto == 0 and num_letras > 10 and num_letras < 13: if palabra_select not in list_palabras: list_palabras.append(palabra_select) nueva_palabra["spanish"] = PalabrasCrucigrama[value_palabra][ "spanish"] nueva_palabra["english"] = palabra_select Palabras_in_Crucigrama.append(nueva_palabra) num_palabras += 1 acierto = 1 else: if palabra_select not in list_palabras: list_palabras.append(palabra_select) nueva_palabra["spanish"] = PalabrasCrucigrama[value_palabra][ "spanish"] nueva_palabra["english"] = palabra_select Palabras_in_Crucigrama.append(nueva_palabra) num_palabras += 1 resultados_crucigrama = sopa_letras.llenar_palabra() result_crucigrama = resultados_crucigrama.generar_crucigrama(list_palabras) data = result_crucigrama[0] palabras = result_crucigrama[1] nombre_id = "id" nombre_tabla = "crucigrama" id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id) proximo_id = id_max[0]["max_id"] + 1 id = str(proximo_id) grupo = "1" Insert_ofCrucigrama = dict() Insert_ofCrucigrama = { 'TABLE': 'crucigrama', 'Col1': 'id', 'Col2': 'grupo', 'Col3': 'palabras', 'Val4': '%s', 'Val5': '%s', 'Val6': '%s', } Data = [id, grupo, palabras] res_insert = connect.IT_TABLE(username, Insert_ofCrucigrama, Data) return render_template("/blog/sopa.html", url=Urlbase, data=data, palabras_crucigrama=Palabras_in_Crucigrama, id_crucigrama=proximo_id, DatosTopico=DatosTopico)
def add_NewVerb(): Urlbase = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) req = request.get_json() result = {} id = None if request.method == "POST": english_form = request.form["english"] spanish_form = request.form["spanish"] past_form = request.form["past"] pronunciation = request.form["pronunc"] tipo = request.form["tipo"] present = request.form["present"] future = request.form["future"] english = english_form.upper() spanish = spanish_form.upper() past = past_form.upper() wid = english TSWVocabulary = dict() TSWVocabulary = {'TABLE': 'verbs', 'Col1': 'english', 'Whe2': 'english=%s' } Data = (wid,) DatosVocabulary = connect.SW_TABLE(username, TSWVocabulary, Data) if DatosVocabulary: result["new_topico"] = "Ya se encuentra registrado " + english + " en BD" else: Insert_ofvocabulary = dict() Insert_ofvocabulary = {'TABLE':'verbs', 'Col1':'id', 'Col2':'english', 'Col3':'spanish', 'Col4':'present', 'Col5':'pass', 'Col6':'future', 'Col7':'pronunciation', 'Col8':'tipo', 'Val9':'%s', 'Val10':'%s', 'Val11':'%s', 'Val12':'%s', 'Val13':'%s', 'Val14':'%s', 'Val15':'%s', 'Val16':'%s' } Data = [id, english, spanish, present, past, future, pronunciation, tipo] result["new_topico"] = "Registro exitoso" res_insert = connect.IT_TABLE(username, Insert_ofvocabulary, Data) TSSVerbs = dict() TSSVerbs = {'TABLE':'verbs', 'Col1':'id', 'Col2':'english', 'Col3':'spanish', 'Col4':'pronunciation', 'Col5':'pass' } DatosVerbs = connect.SSP_TABLE(username,TSSVerbs) return render_template("/admin/addNewVerb.html", url = Urlbase, verbs = DatosVerbs)
def add_NewWord(): Urlbase = URLBASE username = CONFIG['TYPE_USER']['ROOT'] connect = Model(username) req = request.get_json() result = {} id = None if request.method == "POST": english_form = request.form["english"].upper() spanish_form = request.form["spanish"].upper() grupo = request.form["grupo"] ejemplos = request.form["ejemplos"] pronunc = request.form["pronunc"] english = english_form.upper() spanish = spanish_form.upper() wid = english TSWVocabulary = dict() TSWVocabulary = {'TABLE': 'vocabulary', 'Col1': 'english', 'Whe2': 'english=%s' } Data = (wid,) DatosVocabulary = connect.SW_TABLE(username, TSWVocabulary, Data) Tabla_All_Grupos = dict() Tabla_All_Grupos = {'TABLE':'grupo', 'Col1':'id', 'Col2':'topico' } DatosAllGrupos = connect.SSP_TABLE(username, Tabla_All_Grupos) if DatosVocabulary: result["message"] = "Ya se encuentra registrado " + english + " en BD" else: Insert_ofvocabulary = dict() Insert_ofvocabulary = {'TABLE':'vocabulary', 'Col1':'id', 'Col2':'english', 'Col3':'spanish', 'Col4':'grupo', 'Col5':'ejemplos', 'Col6':'pronunc', 'Val7':'%s', 'Val8':'%s', 'Val9':'%s', 'Val10':'%s', 'Val11':'%s', 'Val12':'%s' } Data = [id, english, spanish, grupo, ejemplos, pronunc] result["message"] = "Registro exitoso" res_insert = connect.IT_TABLE(username, Insert_ofvocabulary, Data) Tabla_All_Words = dict() Tabla_All_Words = {'TABLE':'vocabulary', 'Col1':'id', 'Col2':'english', 'Col3':'spanish', 'Col4':'pronunc' } DatosAllWords = connect.SSP_TABLE(username, Tabla_All_Words) return render_template("/admin/addNewWord.html", url = Urlbase, grupos = DatosAllGrupos, words = DatosAllWords , result=result)