def get_code(email, upload_at): user_id = select_user_id(email) if user_id == '': data = {'email': '0', 'code': '0'} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: code = select_code(user_id) if code == '': code = utils.create_code() query = "INSERT INTO code_user (user_id, code, upload_at) VALUES (%s,%s,%s);" data = (user_id, code, upload_at) conn.run_query(query, data) data = {'email': email, 'code': utils.remove_punctuation(str(code))} final = json.dumps(data, ensure_ascii=False).encode('utf8') mservice.send_email("*****@*****.**", "Rodolfo123123", email, "Tu código es: "+str(code)) return final else: data = {'email': email, 'code': utils.remove_punctuation(str(code))} final = json.dumps(data, ensure_ascii=False).encode('utf8') mservice.send_email("*****@*****.**", "Rodolfo123123", email, "Tu código es: " + str(code)) return final
def updateConfig(email,parameter,descu): user_id = gdao.selectUserId(email) query = "UPDATE config SET parameter = %s, descu = %s WHERE user_id = %s" data = (param,desc,user_id) conn.run_query(query,data)
def insertUser_app(email, password, first_name, last_name, dni, phone, region_id, provincia_id, distrito_id, created_at): em = selectUserID_app(email) d = selectDNI_app(dni) if (em == '' and d == ''): query = "INSERT INTO user_app (email,password,first_name,last_name,dni,phone,region,provincia,distrito,created_at) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);" data = (email, password, first_name, last_name, dni, phone, region_id, provincia_id, distrito_id, created_at) conn.run_query(query, data) user_id = selectUserID_app(email) data = { 'user_id': user_id, 'email': email, 'dni': dni, 'first_name': first_name, 'last_name': last_name } final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: data = { 'user_id': '0', 'email': '0', 'first_name': '0', 'last_name': '0' } final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def updatePhrases(email,text_source,like_flag): em = gdao.selectUserID(email) query = "UPDATE phrase SET like_flag = %s WHERE text_source = %s AND user_id = %s" data = (like_flag,text_source,em) conn.run_query(query,data)
def selectAudio(name,path): result = model.run(path+"/"+name) query = "SELECT phrase_id, upload_at FROM audio WHERE name = '"+name+"' LIMIT 1;" data = "" cursor = conn.run_query(query,data) phrase_id = "" upload_at = "" for (phrase, date_audio) in cursor: phrase_id = str(phrase) upload_at = date_audio #insertPhrases(users_id,'quz','esp','txt',result,result,0,upload_at) query = "SELECT user_id, text_source, text_target FROM phrase WHERE phrase_id = '"+phrase_id+"' LIMIT 1;" cursor = conn.run_query(query,data) text_source = "" text_target = "" user_id = "" for (u, q, s) in cursor: user_id = u text_source = q text_target = s #data = {'user_id': user_id ,'upload_at': upload_at, 'name':name,'text_source':text_source,'text_target':text_target} data = {'user_id': "1" ,'upload_at': "22-02-18", 'name':"hispana.wav",'text_source':result,'text_target':result} final = final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def login_email(email): user_id = select_user_id(email) if user_id == '': data = {'user_id': '0', 'email': '0', 'name': '0'} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: query = "SELECT name, native_lang FROM user WHERE user_id = '%s' LIMIT 1; " % (user_id) cursor = conn.run_query(query, "") name = "" language = "" for (names, nls) in cursor: name = names language = nls query = "SELECT language_id, count FROM huqariq_audio WHERE user_id = '%s' LIMIT 1; " % (user_id) cursor = conn.run_query(query, "") count = [] langs = [] for (lang, c) in cursor: langs.append(lang) count.append(c) data = {'user_id': user_id, 'email': email, 'name': name, 'lang': language, 'langs': langs, "count": count} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def record_audio(filename,date): filenames = filename.split('_') user_app_id = selectUserIdDNI_app(filenames[0]) print user_app_id print filenames[0] query = "SELECT user_app_id,count FROM audios_app WHERE user_app_id = '%s' LIMIT 1;" %(user_app_id) data = "" cursor = conn.run_query(query,data) user_app_test_id = "" count = 1 for user,c in cursor: user_app_test_id = user count = c + 1 print "2" if user_app_test_id == '': query = "INSERT INTO audios_app (user_app_id,date,status) VALUES (%s,%s,%s)" data = (user_app_id,date,1) conn.run_query(query,data) print "3" else: query = "UPDATE audios_app SET count = %s, date = %s WHERE user_app_id = %s" data = (count,date,user_app_id) conn.run_query(query,data) print "4" datas = {'user_app_id': user_app_id, 'filename':filename, 'upload_at': date} final = final = json.dumps(datas,ensure_ascii=False).encode('utf8') return final
def insert_corpus_audio(filename, date): filenames = filename.split(';') language_id = filenames[2] user_id = select_user_id(filenames[0]) print("user_id: ", user_id) query = "SELECT count FROM huqariq_audio WHERE user_id = '%s' and language_id = '%s';" %(user_id, language_id) print(query) cursor = conn.run_query(query, "") count = "" for c in cursor: count = c print("count: ", count) if count == '': query = "INSERT INTO huqariq_audio (user_id,language_id,count,date) VALUES (%s,%s,%s,%s);" data = (user_id, language_id, 0, date) conn.run_query(query, data) count = 1 else: count = int(count[0]) count = count + 1 query = "UPDATE huqariq_audio SET count = %s, date = %s WHERE user_id = %s AND language_id = %s;" data = (count, date, user_id, language_id) conn.run_query(query,data) data = {'user_id': user_id, 'filename':filename, 'upload_at': date} result = json.dumps(data,ensure_ascii=False).encode('utf8') return result
def insertUser(email, password, last_name, first_name, phone, country_id, created_at): em = selectUserID(email) if (em == ''): query = "INSERT INTO user (first_name, last_name, phone, country_id, email, password, created_at) VALUES (%s,%s,%s,%s,%s,%s,%s) ;" data = (first_name, last_name, phone, country_id, email, password, created_at) conn.run_query(query, data) user_id = selectUserID(email) data = { 'user_id': user_id, 'email': email, 'first_name': first_name, 'last_name': last_name } final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: data = { 'user_id': '0', 'email': '0', 'first_name': '0', 'last_name': '0' } final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def update_password(email, code, password): user_id = select_user_id(email) code_consult = select_code(user_id) code_consult = utils.remove_punctuation(str(code_consult)) if code_consult == code: query = "UPDATE user SET password = %s WHERE user_id = %s;" data = (password, user_id) conn.run_query(query, data)
def updatePassword(email, code, password): em = selectUserID(email) code_old = selectCode(em) code_old = utils.remove_punctuation(str(code_old)) if (code_old == code): query = "UPDATE user SET password = %s WHERE user_id = %s" data = (password, em) conn.run_query(query, data)
def login_app(email, password): query = "SELECT password,user_app_id, dni, first_name, last_name FROM user_app WHERE email = '%s' LIMIT 1; " % ( email) data = "" cursor = conn.run_query(query, data) c = 0 user_app_id = "" first_name = "" last_name = "" dni = "" for (password_bd, user, d, fname, lname) in cursor: password_bd = str(password_bd) password_bd = re.sub('[%s]' % re.escape(string.punctuation), "", password_bd).lower() if password == password_bd: c = 1 user_app_id = user first_name = fname last_name = lname dni = d if c == 1: query = "SELECT count FROM audios_app WHERE user_app_id = '%s' LIMIT 1; " % ( user_app_id) data = "" cursor = conn.run_query(query, data) count = "" for c in cursor: count = c data = { 'user_app_id': user_app_id, 'email': email, 'dni': dni, 'first_name': first_name, 'last_name': last_name, 'count': count } final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: data = { 'user_app_id': '0', 'email': '0', 'first_name': '0', 'last_name': '0' } final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def insertAudio(email,name,url,upload_at): user_id = gdao.selectUserID(email) query = "INSERT INTO audio (user_id,name,url,upload_at) VALUES (%s,%s,%s,%s)" data = (user_id,name,url,upload_at) conn.run_query(query,data) data = {'email': email ,'upload_at': upload_at, 'name':name} final = final = json.dumps(data,ensure_ascii=False).encode('utf8') print upload_at+name return final
def selectUserEmail_app(email): em = selectUserID_app(email) if (em == ''): data = { 'user_id': '0', 'email': '0', 'first_name': '0', 'last_name': '0' } final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: query = "SELECT user_app_id, dni, first_name, last_name FROM user_app WHERE user_app_id = %s LIMIT 1;" data = (em) cursor = conn.run_query(query, data) c = 0 user_id = "" first_name = "" last_name = "" dni = "" for (user, d, fname, lname) in cursor: user_app_id = user first_name = fname last_name = lname dni = d query = "SELECT count FROM audios_app WHERE user_app_id = '%s' LIMIT 1; " % ( em) data = "" cursor = conn.run_query(query, data) count = "" for c in cursor: count = c data = { 'user_app_id': user_app_id, 'dni': dni, 'email': email, 'first_name': first_name, 'last_name': last_name, 'count': count } final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def insert_user(email, password, name, native_lang, countries_id, states_id, cities_id, created_at): user_id = select_user_id(email) if user_id == '': query = "INSERT INTO user (email,password,name,native_lang,country_id,state_id,city_id,created_at) VALUES (%s,%s,%s,%s,%s,%s,%s,%s);" data = (email, password, name, native_lang, countries_id, states_id, cities_id, created_at) conn.run_query(query, data) user_id = select_user_id(email) data = {'user_id': user_id, 'email': email, 'name': name} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: data = {'user_id': '0', 'email': '0', 'name': '0'} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def selectWriters(): query = "SELECT writer_id, first_name, last_name, fan_page, blog, country_id, city_id, description FROM writer;" data = "" cursor = conn.run_query(query,data) writer_id = [] first_name = [] last_name = [] fan_page = [] blog = [] country_id = [] city_id = [] description = [] writers = [] for (ai, fn, ln, fp, blo, ci, citi, de) in cursor: writer_id.append(ai) first_name.append(fn) last_name.append(ln) fan_page.append(fp) blog.append(blo) country_id.append(ci) city_id.append(citi) description.append(de) i = 0 for a in writer_id: writers.append({'writer_id':str(writer_id[i]),'first_name':first_name[i],'last_name': last_name[i],'fan_page':fan_page[i],'blog':blog[i],'country_id':country_id[i],'city_id':city_id[i],'description':description[i]}) i = i + 1 data = {'writers': writers} final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def selectArtists(): query = "SELECT artist_id, first_name, last_name, fan_page, youtube, country_id, city_id, music_type, description FROM artist;" data = "" cursor = conn.run_query(query,data) artist_id = [] first_name = [] last_name = [] fan_page = [] youtube = [] country_id = [] city_id = [] music_type = [] description = [] artists = [] for (ai, fn, ln, fp, you, ci, citi, mt, de) in cursor: artist_id.append(ai) first_name.append(fn) last_name.append(ln) fan_page.append(fp) youtube.append(you) country_id.append(ci) city_id.append(citi) music_type.append(mt) description.append(de) i = 0 for a in artist_id: artists.append({'artist_id':str(artist_id[i]),'first_name':first_name[i],'last_name': last_name[i],'fan_page':fan_page[i],'youtube':youtube[i],'country_id':country_id[i],'city_id':city_id[i],'music_type':music_type[i],'description':description[i]}) i = i + 1 data = {'artists': artists} final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def selectPhrases(email): em = gdao.selectUserID(email) query = "SELECT phrase_id, text_source, text_target, like_flag, upload_at FROM phrase WHERE user_id = %s ;" %(em) data = "" cursor = conn.run_query(query,data) ii = [] tq = [] tsp = [] lf = [] dup = [] jphrases = [] for (pid, text_source, text_target, like_flag, upload_at) in cursor: ii.append(pid) tp.append(text_source) tsp.append(text_target) lf.append(like_flag) dup.append(upload_at) i = 0 for a in ii: jphrases.append({'phrase_id':str(ii[i]),'text_source':tq[i],'text_target': tsp[i],'like_flag':str(lf[i]),'upload_at':dup[i]}) i = i + 1 data = {'email': email,'phrases':jphrases} final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def select_user_id(email): query = "SELECT user_id FROM user WHERE email = '%s' LIMIT 1;" % (email) cursor = conn.run_query(query, "") user_id = "" for id in cursor: user_id = id return user_id[0]
def selectRadios(): query = "SELECT radio_id, name, web, country_id, city_id, description FROM radio;" data = "" cursor = conn.run_query(query,data) radio_id = [] name = [] web = [] country_id = [] city_id = [] description = [] radios = [] for (ai, fn, ln, ci, citi, de) in cursor: radio_id.append(ai) name.append(fn) web.append(ln) country_id.append(ci) city_id.append(citi) description.append(de) i = 0 for a in radio_id: radios.append({'radio_id':str(radio_id[i]),'name':name[i],'web': web[i],'country_id':country_id[i],'city_id':city_id[i],'description':description[i]}) i = i + 1 data = {'radios': radios} final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def selectLang(): query = "SELECT language_id, iso, name FROM language;" data = "" cursor = conn.run_query(query, data) language_id = [] iso = [] name = [] for (ids, i, names) in cursor: language_id.append(ids) iso.append(i) name.append(names) i = 0 language = [] for a in language_id: p = {'language_id': language_id[i], 'iso': iso[i], 'name': name[i]} language.append(p) i = i + 1 data = {'language': language} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def selectCountry(): query = "SELECT country_id, name FROM country;" data = "" cursor = conn.run_query(query, data) country_id = [] name = [] for (ids, c) in cursor: country_id.append(ids) name.append(c) i = 0 country = [] for a in country_id: p = {'country_id': country_id[i], 'name': name[i]} country.append(p) i = i + 1 data = {'countries': country} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final
def selectConfig(email): user_id = gdao.selectUserId(email) query = "SELECT parameter, descu FROM config WHERE user_id = %s ;" %(user_id) data = "" cursor = conn.run_query(query,data) p = [] d = [] config = [] for (param, desc) in cursor: p.append(param) l.append(desc) i = 0 for a in p: config.append({'parameter':p[i],'descu':str(l[i])}) i = i + 1 data = {'email': email,'config':config} final = json.dumps(data,ensure_ascii=False).encode('utf8') return final
def select_code(user_id): query = "SELECT code from code_user WHERE user_id = '%s';" data = (user_id) cursor = conn.run_query(query, data) code = "" for co in cursor: code = co return code
def insert_prompt_audio(filename, date): filenames = filename.split('_') language_id = filenames[2] user_id = select_user_id(filenames[0]) print("user_id: ", user_id) query = "SELECT count FROM tarpuriq_audio WHERE user_id = '%s' AND language_id = '%s' LIMIT 1;" %(user_id, language_id) cursor = conn.run_query(query, "") count = "" for c in cursor: count = c if count == '': query = "INSERT INTO tarpuriq_audio (user_id,language_id,count,date) VALUES (%s,%s,%s,%s);" data = (user_id, language_id, 0, date) conn.run_query(query, data) count = 1 else: count = count + 1 query = "UPDATE tarpuriq_audio SET count = %s, date = %s WHERE user_id = %s AND language_id = %s;" data = (count, date, user_id, language_id) conn.run_query(query, data) query = "UPDATE text_prompt SET status = %s WHERE text_prompt_id = %s" data = (1, int(filenames[3])) conn.run_query(query,data) data = {'user_id': user_id, 'filename': filename, 'upload_at': date} result = json.dumps(data, ensure_ascii=False).encode('utf8') return result
def selectDNI_app(dni): query = "SELECT dni FROM user_app WHERE dni = '%s' LIMIT 1;" % (dni) data = "" cursor = conn.run_query(query, data) dni = "" for d in cursor: dni = d return dni
def selectUserIdDNI_app(dni): query = "SELECT user_app_id FROM user_app WHERE dni = '%s' LIMIT 1;" %(dni) data = "" cursor = conn.run_query(query,data) user_app_id = "" for user in cursor: user_app_id = user return user_app_id
def selectUserID(email): query = "SELECT user_id FROM user WHERE email = '%s' LIMIT 1;" % (email) data = "" cursor = conn.run_query(query, data) user_id = "" for user in cursor: user_id = user return user_id
def insertCode(email, upload_at): user_id = selectUserID(email) if user_id == '': data = {'email': '0', 'code': '0'} final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: em = selectUserID(email) code = selectCode(em) if code == '': code = utils.createCode() query = "INSERT INTO code_user (user_id, code, upload_at) VALUES (%s,%s,%s) ;" data = (em, code, upload_at) conn.run_query(query, data) data = {'email': email, 'code': code} final = final = json.dumps(data, ensure_ascii=False).encode('utf8') mservice.sendEmail( "*****@*****.**", "Qchw-2017", email, str(code) + " is your Quechua ASR verification code") return final else: code_old = selectCode(em) data = { 'email': email, 'code': utils.remove_punctuation(str(code_old)) } final = final = json.dumps(data, ensure_ascii=False).encode('utf8') mservice.sendEmail( "*****@*****.**", "Qchw-2017", email, utils.remove_punctuation(str(code_old)) + " is your Quechua ASR verification code") return final
def login(email, password): user_id = select_user_id(email) if user_id == '': data = {'user_id': '0', 'email': '0', 'name': '0'} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: query = "SELECT password, name, native_lang FROM user WHERE user_id = '%s' LIMIT 1; " % (user_id) cursor = conn.run_query(query, "") flag = 0 name = "" language = "" for (password_bd, names, nls) in cursor: password_bd = str(password_bd) password_bd = re.sub('[%s]' % re.escape(string.punctuation), "", password_bd).lower() if password == password_bd: flag = 1 name = names language = nls if flag == 1: query = "SELECT language_id, count FROM huqariq_audio WHERE user_id = '%s' LIMIT 1; " % (user_id) cursor = conn.run_query(query, "") count = [] langs = [] for (lang, c) in cursor: langs.append(lang) count.append(c) data = {'user_id': user_id, 'email': email, 'name': name, 'language': language, 'langs': langs, "count": count} final = json.dumps(data, ensure_ascii=False).encode('utf8') return final else: data = {'user_id': '0', 'email': '0', 'name': '0'} final = final = json.dumps(data, ensure_ascii=False).encode('utf8') return final