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
