def AddCategoryBlg():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
name_category = req["name_category"]
#id = None
Insert_ofCategory = dict()
Insert_ofCategory = {
'TABLE': 'blg_category',
'Col1': 'id',
'Col2': 'name',
'Val3': '%s',
'Val4': '%s'
}
nombre_id = "id"
nombre_tabla = "blg_category"
id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id)
print(id_max[0]["max_id"])
if id_max[0]["max_id"] == None:
id_sig = "1"
else:
proximo_id = id_max[0]["max_id"] + 1
id_sig = str(proximo_id)
Data = [id_sig, name_category]
''' result["new_proveedor"] = name '''
res_insert = connect.IT_TABLE(username, Insert_ofCategory, Data)
result = {"hola": 2}
return result
def AddPostBlg():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
id_category = req["id_category"]
id_users = req["id_users"]
title_post = req["title_post"]
date_post = req["date_post"]
#id = None
Insert_ofPost = dict()
Insert_ofPost = {
'TABLE': 'post',
'Col1': 'id',
'Col2': 'title',
'Col3': 'image',
'Col4': 'created_at',
'Col5': 'status',
'Col6': 'user_id',
'Col7': 'category_id',
'Val8': '%s',
'Val9': '%s',
'Val10': '%s',
'Val11': '%s',
'Val12': '%s',
'Val13': '%s',
'Val14': '%s'
}
nombre_id = "id"
nombre_tabla = "post"
id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id)
print(id_max[0]["max_id"])
if id_max[0]["max_id"] == None:
id_sig = "1"
else:
proximo_id = id_max[0]["max_id"] + 1
id_sig = str(proximo_id)
img_name = "post" + id_sig + "user" + id_users + "catg" + id_category + ".jpg"
status = "1"
Data = [
id_sig, title_post, img_name, date_post, status, id_users, id_category
]
res_insert = connect.IT_TABLE(username, Insert_ofPost, Data)
result = {"hola": 2}
return result
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)