def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
word = request.form['word']
payload = base64.encodestring(request.form['payload'])
created_time = int(round(time.time() * 1000))
sql_edit_insert(
''' INSERT INTO words (word,payload,created_time) VALUES (?,?,?) ''',
(word, payload, str(created_time)))
results1 = sql_query(''' SELECT * FROM words''')
msg = 'INSERT INTO words (word, payload, created_time) VALUES (' + word + ',' + payload + ',' + str(
created_time) + ')'
results = []
for result in results1:
resultx = dict()
payload = json.loads(
base64.decodestring(str(result['payload']).encode()))
mean = json.loads(base64.decodestring(str(payload['means']).encode()))
resultx['payload'] = mean
resultx['word'] = result['word']
resultx['created_time'] = result['created_time']
results.append(resultx)
return render_template('sqldatabase.html', results=results, msg=msg)
def register():
from functions.sqlquery import sql_query2, sql_edit_insert
msg = ''
if request.method == 'POST' and 'username' in request.form and 'password' in request.form and 'email' in request.form:
email = request.form['email']
username = request.form['username']
password = request.form['password']
cursor = sql_query2(''' SELECT * FROM data_table where username = ?''',
(username, ))
if len(cursor) > 0:
msg = 'Account already exists!'
elif not re.match(r'[A-Za-z0-9]+', username):
msg = 'Username must contain only characters and numbers!'
elif not re.search(r'^[a-z0-9]+[\._]?[a-z0-9]+[@]\w+[.]\w{2,3}$',
email):
msg = 'Email must be a valid one!'
elif not username or not password or not email:
msg = 'Please fill out the form !'
else:
sql_edit_insert(
'INSERT INTO data_table(email,username,password) VALUES (?, ?, ?)',
(email, username, password))
msg = 'You have successfully registered !'
elif request.method == 'POST':
msg = 'Please fill out the form !'
return render_template('register.html', msg=msg)
def selected_Row():
from functions.sqlquery import sql_edit_insert, getAllDevices, getSortedDeviceID
if request.method == 'POST':
Device_ID = request.form["Device_ID"]
Device_Type = request.form["Device_Type"]
Device_Name = request.form["Device_Name"]
Device_Model = request.form["Device_Model"]
OS_Type = request.form["OS_Type"]
OS_Version = request.form["OS_Version"]
Device_RAM = request.form["Device_RAM"]
Device_CPU_GPU = request.form["Device_CPU_GPU"]
Device_Bit = request.form["Device_Bit"]
Device_Screen_Resolution = request.form["Device_Screen_Resolution"]
Device_Screen_PPI = request.form["Device_Screen_PPI"]
Device_Grade = request.form["Device_Grade"]
Device_UUID = request.form["Device_UUID"]
sql_edit_insert(
'''UPDATE Device SET Device_Type = ?, Device_Name = ?, Device_Model = ?,\
OS_Type = ?, OS_Version = ?, Device_RAM = ?, Device_CPU_GPU = ?, Device_Bit = ?,\
Device_Screen_Resolution = ?, Device_Screen_PPI = ?, Device_Grade = ?, Device_UUID = ? \
WHERE Device_ID = ? ''',
(Device_Type, Device_Name, Device_Model, OS_Type, OS_Version,
Device_RAM, Device_CPU_GPU, Device_Bit, Device_Screen_Resolution,
Device_Screen_PPI, Device_Grade, Device_UUID, Device_ID))
dresults = getSortedDeviceID()
return render_template('admin.html', dresults=dresults)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
artist = request.form['artist']
title = request.form['title']
release_year = request.form['release_year']
sql_edit_insert(''' INSERT INTO record (artist,title,release_year)
VALUES (?,?,?) ''', (artist,title,release_year))
results = sql_query('''SELECT * FROM record''')
msg = 'INSERT INTO record (artist,title,release_year) VALUES
('+artist+','+title+','+release_year+')'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
reply = request.form['reply']
query = request.form['query']
intent = request.form['intent']
sql_edit_insert(
''' INSERT INTO dataset (query,reply,intent) VALUES (?,?,?) ''',
(query, reply, intent))
results = sql_query(''' SELECT * FROM dataset''')
msg = 'INSERT INTO dataset (query,reply,intent) VALUES (' + query + ',' + reply + ',' + intent + ')'
return render_template('t_board.html', results=results, msg=msg)
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
old_artist = request.form['old_artist']
old_title = request.form['old_title']
sql_edit_insert(''' UPDATE record SET artist = ?, title = ?,
release_year = ? WHERE artist = ? and title = ? ''',
(artist,title,old_artist,old_title))
results = sql_query(''' SELECT * FROM record''')
msg = 'UPDATE record SET artist = ' + artist + ', ' + title + ', ' +
release_year + ' WHERE artist = ' + old_artist + ' and title = ' + old_title
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
drink_name = request.form['drink_name']
spirit = request.form['spirit']
ingredient_1 = request.form['ingredient_1']
ingredient_2 = request.form['ingredient_2']
ingredient_3 = request.form['ingredient_3']
garnish = request.form['garnish']
sql_edit_insert(''' INSERT INTO data_table (drink_name,spirit,ingredient_1,ingredient_2,ingredient_3,garnish) VALUES (?,?,?,?,?,?) ''', (drink_name,spirit,ingredient_1,ingredient_2,ingredient_3,garnish) )
results = sql_query(''' SELECT * FROM data_table''')
msg = 'INSERT INTO data_table (drink_name,spirit,ingredient_1,ingredient_2,ingredient_3,garnish) VALUES ('+drink_name+','+spirit+','+ingredient_1+','+ingredient_2+','+ingredient_3+','+garnish+')'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
last_name = request.form['last_name']
first_name = request.form['first_name']
address = request.form['address']
city = request.form['city']
state = request.form['state']
zip = request.form['zip']
sql_edit_insert(''' INSERT INTO data_table (first_name,last_name,address,city,state,zip) VALUES (?,?,?,?,?,?) ''', (first_name,last_name,address,city,state,zip) )
results = sql_query(''' SELECT * FROM data_table''')
msg = 'INSERT INTO data_table (first_name,last_name,address,city,state,zip) VALUES ('+first_name+','+last_name+','+address+','+city+','+state+','+zip+')'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
old_reply = request.form['old_reply']
old_query = request.form['old_query']
reply = request.form['reply']
query = request.form['query']
intent = request.form['intent']
sql_edit_insert(
''' UPDATE dataset set query=?,reply=?,intent=? WHERE query=? and reply=? ''',
(query, reply, intent, old_query, old_reply))
results = sql_query(''' SELECT * FROM dataset''')
msg = 'UPDATE dataset set query = ' + query + ', reply = ' + reply + ', intent = ' + intent + ' WHERE query = ' + old_query + ' and reply = ' + old_reply
return render_template('t_board.html', results=results, msg=msg)
def submitted():
rec_mood = request.args.get("Film")
rec_length = request.args.get("Length")
rec_genre = request.args.get("Genre")
rec_type = request.args.get("Movie_Type")
rec = (rec_mood, rec_length, rec_type, rec_genre)
# Update the recommendations database
from functions.sqlquery import sql_make_rec, sql_edit_insert
sql_make_rec()
sql_edit_insert(
"INSERT INTO recommendations (Film,Length,Movie_Type,Genre) VALUES(?,?,?,?)",
(rec))
return render_template('submitted.html')
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
old_drink_name = request.form['old_drink_name']
spirit = request.form['spirit']
drink_name = request.form['drink_name']
ingredient_1 = request.form['ingredient_1']
ingredient_2 = request.form['ingredient_2']
ingredient_3 = request.form['ingredient_3']
garnish = request.form['garnish']
sql_edit_insert(''' UPDATE data_table set drink_name=?,spirit=?,ingredient_1=?,ingredient_2=?,ingredient_3=?,garnish=? WHERE drink_name=? and spirit=? ''', (drink_name,spirit,ingredient_1,ingredient_2,ingredient_3,garnish,old_drink_name) )
results = sql_query(''' SELECT * FROM data_table''')
msg = 'UPDATE data_table set drink_name = ' + drink_name + ', spirit = ' + spirit + ', ingredient_1 = ' + ingredient_1 + ', ingredient_2 = ' + ingredient_2 + ', ingredient_3 = ' + ingredient_3 + ', garnish = ' + garnish + ' WHERE drink_name = ' + old_drink_name
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
deg_min = request.form['deg_min']
serv_id = request.form['serv_id']
deg_max = request.form['deg_max']
sleep_min = request.form['sleep_min']
sleep_max = request.form['sleep_max']
extra = request.form['extra']
sql_edit_insert(
''' INSERT INTO data_table (serv_id,deg_min,deg_max,sleep_min,sleep_max,extra) VALUES (?,?,?,?,?,?) ''',
(serv_id, deg_min, deg_max, sleep_min, sleep_max, extra))
results = sql_query(''' SELECT * FROM data_table''')
msg = 'INSERT INTO data_table (serv_id,deg_min,deg_max,sleep_min,sleep_max,extra) VALUES (' + serv_id + ',' + deg_min + ',' + deg_max + ',' + sleep_min + ',' + sleep_max + ',' + extra + ')'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
old_last_name = request.form['old_last_name']
old_first_name = request.form['old_first_name']
last_name = request.form['last_name']
first_name = request.form['first_name']
address = request.form['address']
city = request.form['city']
state = request.form['state']
zip = request.form['zip']
sql_edit_insert(''' UPDATE data_table set first_name=?,last_name=?,address=?,city=?,state=?,zip=? WHERE first_name=? and last_name=? ''', (first_name,last_name,address,city,state,zip,old_first_name,old_last_name) )
results = sql_query(''' SELECT * FROM data_table''')
msg = 'UPDATE data_table set first_name = ' + first_name + ', last_name = ' + last_name + ', address = ' + address + ', city = ' + city + ', state = ' + state + ', zip = ' + zip + ' WHERE first_name = ' + old_first_name + ' and last_name = ' + old_last_name
return render_template('sqldatabase.html', results=results, msg=msg)
def push_Data():
user_id = request.form['user_id']
time_array = [
'if_opted_in', 'if_zoomed_in', 'if_checked_details',
'if_checked_reviews'
]
time_dict = {
'if_opted_in': 2,
'if_zoomed_in': 2,
'if_checked_details': 3,
'if_checked_reviews': 3
}
total_time = 0
for k in range(len(time_array)):
var = int(request.form[time_array[k]])
if var != 0:
total_time += time_dict.get(time_array[k])
search_id = request.form['search_id']
from functions.sqlquery import sql_edit_insert, sql_query
results = sql_edit_insert(
''' INSERT INTO searches (user_id,search1_id, time_spent) VALUES (?,?,?)''',
(user_id, search_id, total_time))
answer = sql_query(''' SELECT * from searches''')
df_new = pd.DataFrame(answer)
df_new.columns = ['user_id', 'search1_id', 'time_spent']
df_new.to_csv('user_history.csv', index=False)
return jsonify(results)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
last_name = request.form['last_name']
first_name = request.form['first_name']
school = request.form['school']
degree = request.form['degree']
field = request.form['field']
year = request.form['year']
current_employer = request.form['current_employer']
job_title = request.form['job_title']
user_name = request.form['user_name']
contact = request.form['contact']
sql_edit_insert(''' INSERT INTO data_table (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact) VALUES (?,?,?,?,?,?,?,?,?,?) ''', (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact) )
results = sql_query(''' SELECT * FROM data_table''')
msg = 'INSERT INTO data_table (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact) VALUES ('+first_name+','+last_name+','+school+','+degree+','+field+','+year+','+current_employer+','+job_title+','+user_name+','+contact+')'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
name = request.form['name']
person = request.form['person']
location = request.form['location']
sighted = request.form['sighted']
# TODO: SET THIS EQUAL TO SOMETHING MAYBE IT'LL WORK
sql_edit_insert(
''' INSERT OR REPLACE INTO Sightings (name,person,location,sighted) VALUES (?,?,?,?) ''',
(name, person, location, sighted))
flowers_table = sql_query('''SELECT * FROM Flowers''')
sightings_table = sql_query('''SELECT * FROM Sightings''')
return render_template('sqldatabase.html',
sightings_table=sightings_table,
flowers_table=flowers_table)
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
old_deg_min = request.form['old_deg_min']
old_serv_id = request.form['old_serv_id']
deg_min = request.form['deg_min']
serv_id = request.form['serv_id']
deg_max = request.form['deg_max']
sleep_min = request.form['sleep_min']
sleep_max = request.form['sleep_max']
extra = request.form['extra']
sql_edit_insert(
''' UPDATE data_table set serv_id=?,deg_min=?,deg_max=?,sleep_min=?,sleep_max=?,extra=? WHERE serv_id=? and deg_min=? ''',
(serv_id, deg_min, deg_max, sleep_min, sleep_max, extra,
old_serv_id, old_deg_min))
results = sql_query(''' SELECT * FROM data_table''')
msg = 'UPDATE data_table set serv_id = ' + serv_id + ', deg_min = ' + deg_min + ', deg_max = ' + deg_max + ', sleep_min = ' + sleep_min + ', sleep_max = ' + sleep_max + ', extra = ' + extra + ' WHERE serv_id = ' + old_serv_id + ' and deg_min = ' + old_deg_min
return render_template('sqldatabase.html', results=results, msg=msg)
def register():
msg = ''
# Check if "username", "password" and "email" POST requests exist (user submitted form)
if request.method == 'POST' and 'username' in request.form and 'password' in request.form and 'email' in request.form:
# Create variables for easy access
username = request.form['username']
password = request.form['password']
contact = request.form['email']
results_auth = authenticate(''' SELECT * FROM data_table where user_name = ?''', (username,))
if not results_auth:
sql_edit_insert(''' INSERT INTO data_table (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact,password,location) VALUES (?,?,?,?,?,?,?,?,?,?,?,?) ''', ('','','','','','','','',username,contact,password,'') )
msg = 'INSERT INTO data_table (user_name,contact,password) VALUES ('+username+','+contact+','+password+')'
return redirect(url_for('home', uname=username))
else:
return render_template('register.html', msg='User Name taken, Try Again!')
elif request.method == 'POST':
# Form is empty... (no POST data)
msg = 'Please fill out the form!'
return render_template('register.html', msg=msg)
def sql_create():
# print(request.values)
from functions.sqlquery import sql_edit_insert, sql_query
season = request.form['season']
episode_number = request.form['episode_number']
number_in_season = request.form['number_in_season']
episode_name = request.form['episode_name']
director = request.form['director']
writer = request.form['writer']
original_air_date = request.form['original_air_date']
us_viewers = request.form['us_viewers']
runtime = request.form['runtime']
imdb_description = request.form['imdb_description']
imdb_votes = '0'
imdb_rating = '10'
notable_death_count = request.form['notable_death_count']
print(notable_death_count)
sql_edit_insert(''' INSERT INTO got (`season`,`episode number`,`number in season`,`episode name`,`director`,`writer`, `original air date`, `us viewers (million)`, `runtime (mins)`, `imdb description`, `imdb votes`, `imdb rating`, `notable death count`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ''',
(season, episode_number, number_in_season, episode_name, director, writer, original_air_date, us_viewers, runtime, imdb_description, imdb_votes, imdb_rating, notable_death_count))
results = sql_query(''' SELECT * FROM got''')
msg='added the '+episode_name+' item from db'
return render_template('sqldatabase.html', results = results, msg = msg)
def addDevice():
from functions.sqlquery import sql_edit_insert, getAllDevices, getSortedDeviceID
if 'username' in session:
# get data from HTML form
if request.method == 'POST':
Device_type = request.form["Device_type"]
Device_name = request.form["Device_name"]
model = request.form["model"]
OS_type = request.form["OS_type"]
OS_version = request.form["OS_version"]
ram = request.form["ram"]
CPU_GPU = request.form["CPU_GPU"]
bit = request.form["bit"]
reso = request.form["reso"]
PPI = request.form["PPI"]
grade = request.form["grade"]
UUID = request.form["UUID"]
Location = "Library"
if Device_type and Device_name:
sql_edit_insert((
'''INSERT INTO Device (Device_Type, Device_Name, Device_Model, OS_Type,\
OS_Version, Device_RAM, Device_CPU_GPU, Device_Bit, Device_Screen_Resolution, Device_Screen_PPI,\
Device_Grade, Device_UUID, Device_Location)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)'''),
(Device_type, Device_name, model, OS_type,
OS_version, ram, CPU_GPU, bit, reso, PPI,
grade, UUID, Location))
# Get the info on all the devices
dresults = getSortedDeviceID()
return render_template('admin.html', dresults=dresults)
else:
redirect_to_index = redirect(url_for('device_list'))
response = make_response(redirect_to_index)
return response
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query, sql_query3
if request.method == 'POST':
old_genus = request.form['old_genus']
old_species = request.form['old_species']
old_comname = request.form['old_comname']
genus = request.form['genus']
species = request.form['species']
comname = request.form['comname']
# eresults = sql_query2(''' SELECT * FROM Flowers WHERE genus = ? AND species = ? ''',(genus,species))
sql_edit_insert(
''' UPDATE Flowers set genus=?,species=?,comname=? WHERE genus=? and species=? and comname=?''',
(genus, species, comname, old_genus, old_species, old_comname))
flowers_table = sql_query('''SELECT * FROM Flowers''')
sightings_results = sql_query3(
'''SELECT * FROM SIGHTINGS WHERE NAME=? ORDER BY SIGHTED DESC''',
(comname, ), 10)
sightings_table = sql_query('''SELECT * FROM Sightings''')
return render_template('sqldatabase.html',
sightings_results=sightings_results,
sightings_table=sightings_table,
flowers_table=flowers_table)
def sql_dataedit():
if request.method == 'POST':
old_last_name = request.form['old_last_name']
old_first_name = request.form['old_first_name']
last_name = request.form['last_name']
first_name = request.form['first_name']
school = request.form['school']
degree = request.form['degree']
field = request.form['field']
year = request.form['year']
current_employer = request.form['current_employer']
job_title = request.form['job_title']
user_name = request.form['user_name']
contact = request.form['contact']
sql_edit_insert(''' UPDATE data_table set first_name=?,last_name=?,school=?,degree=?,field=?,year=?,current_employer=?,job_title=?,user_name=?,contact=? WHERE user_name=? ''', (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact,user_name))
print('SUCCESS!')
msg = 'Updated!'
results = sql_query(''' SELECT * FROM data_table''')
return redirect(url_for('profile', uname=user_name, aresults=results))
else:
results = sql_query(''' SELECT * FROM data_table''')
msg='Not Updated'
return render_template('update.html', uname=user_name, msg=msg)
def profile(uname):
#get account info
if request.method == 'POST':
old_last_name = request.form['old_last_name']
old_first_name = request.form['old_first_name']
last_name = request.form['last_name']
first_name = request.form['first_name']
school = request.form['school']
degree = request.form['degree']
field = request.form['field']
year = request.form['year']
current_employer = request.form['current_employer']
job_title = request.form['job_title']
user_name = request.form['user_name']
contact = request.form['contact']
location = request.form['location']
sql_edit_insert(''' UPDATE data_table set first_name=?,last_name=?,school=?,degree=?,field=?,year=?,current_employer=?,job_title=?,user_name=?,contact=?,location=? WHERE user_name=? ''', (first_name,last_name,school,degree,field,year,current_employer,job_title,user_name,contact,location,user_name))
msg = 'Updated, return to Home page!'
aresults = sql_query2(''' SELECT * FROM data_table where user_name = ?''', (uname,))
return render_template('profile.html', uname=user_name, aresults=aresults, msg=msg)
else:
msg=''
aresults = sql_query2(''' SELECT * FROM data_table where user_name = ?''', (uname,))
return render_template('profile.html', uname=uname, aresults=aresults, msg=msg)
def sql_update():
from functions.sqlquery import sql_edit_insert, sql_query
old_episode_name = request.form['old_episode_name']
season = request.form['season']
episode_number = request.form['episode_number']
number_in_season = request.form['number_in_season']
episode_name = request.form['episode_name']
director = request.form['director']
writer = request.form['writer']
original_air_date = request.form['original_air_date']
us_viewers = request.form['us_viewers']
runtime = request.form['runtime']
imdb_description = request.form['imdb_description']
imdb_votes = '0'
imdb_rating = '10'
notable_death_count = request.form['notable_death_count']
# print(old_episode_name)
sql_edit_insert(''' UPDATE got set `season`=?, `episode number`=?, `number in season`=?, `episode name`=?, `director`=?, `writer`=?, `original air date`=?, `us viewers (million)`=?, `runtime (mins)`=?, `imdb description`=?, `imdb votes`=?, `imdb rating`=?, `notable death count`=? WHERE `episode name` = ?''',
(season, episode_number, number_in_season, episode_name, director, writer, original_air_date, us_viewers, runtime, imdb_description, imdb_votes, imdb_rating, notable_death_count, old_episode_name))
results = sql_query(''' SELECT * FROM got''')
# print(results[0]['Episode Name'])
msg = 'updated the '+old_episode_name+' item from db'
return render_template('sqldatabase.html', results=results, msg=msg)
def sql_database():
global customer_cache
global start_time
count = 0
while (True):
# print(count)
result_list = []
extra_cust = []
flag = False
# if((time.time() - start_time)/(1000*60*60) >3 ):
print((time.time() - start_time))
if ((time.time() - start_time) > 5555):
# print("*********************customer cache")
customer_cache = []
start_time = time.time()
# print("ok")
fname = ["akshata", "shreya"]
#for testing purposes
if (time.time() - start_time > 5):
fname.append("POPO")
# print(customer_cache)
for name in fname:
if (name not in customer_cache):
flag = True
# print("name*****************",name)
extra_cust.append(name)
# print("extra cust******",extra_cust)
if (flag == True):
# print("***************DB CALL********************")
results = sql_query2(
''' SELECT person_id, first_name,last_name,firebase_id,IsSignificant,mobile FROM Customers_master where first_name in (%s)'''
% ','.join('?' * len(extra_cust)), extra_cust)
count += 1
# print("Result*****",results)
if (len(results) == 0):
for name in extra_cust:
customer_cache.append(name)
for result in results:
result_dict = {
'ID': result['person_id'],
'firstname': result['first_name'],
'lastname': result['last_name'],
'firebaseid': result['firebase_id'],
'IsSignificant': result['IsSignificant'],
'mobile number': result['mobile']
}
if (len(customer_cache) == 0):
start_time = time.time()
customer_cache.append(result['first_name'])
result_list.append(result_dict)
name = result_dict['firstname'] + result_dict['lastname']
sql_edit_insert(
''' INSERT INTO Customers (id,Name,IsSignificant,firebase_id, mobile) VALUES (?,?,?,?,?)''',
(result_dict['ID'], name, result_dict['IsSignificant'],
result_dict['firebaseid'], result_dict['mobile number']))
extra_cust = []
def getBest():
#should implement after set period
from pyfcm import FCMNotification
user_id = int(request.form['user_id'])
from functions.sqlquery import sql_query2, sql_query
results = sql_query2(
''' SELECT search1_id, time_spent from searches where user_id = ?''',
(user_id, ))
results = results[-10:]
df = pd.read_csv('products.csv',
usecols=[
'product_id', 'number_of_purchases', 'name',
'actual_price', 'original_price',
'discount_percentage', 'number_of_offers',
'seller_name'
])[1:162]
df["number_of_purchases"].fillna("0", inplace=True)
df2 = pd.read_csv('products.csv',
usecols=['product_id', 'number_of_purchases'])[1:162]
df2["number_of_purchases"].fillna("1", inplace=True)
main_data = df.values.tolist()
data2 = df2.values.tolist()
for i in range(len(data2)):
data2[i][0] = int(data2[i][0])
data2[i][1] = int(data2[i][1])
df3 = pd.read_csv('recommendations.csv')
data3 = df3.values.tolist()
for i in range(len(data3)):
data3[i][0] = int(data3[i][0])
data3[i][1] = int(data3[i][1])
total = 0
for i in range(len(data2)):
total += data2[i][1]
max_value = 0
final_id = 1
result_list = []
for i in range(len(data2)):
pro_id = data2[i][0]
final_prob = 0
every_result = []
for j in range(len(results)):
second_id = results[j][0]
time_value = results[j][1]
#ab inka intersection nikaalna padta
intersect_value = sql_query2(
''' SELECT factor from
data_table where product_1_id = ?
and product_2_id = ?''', (pro_id, second_id))
if not intersect_value:
value = 0.1
else:
value = intersect_value[0][0]
#time aayega abhi bas
quantity_value = sql_query2(
''' SELECT number_of_purchases from
product_table where product_id = ? ''', (second_id, ))
quantity = quantity_value[0][0]
# bayes_prob = probability of A intersection B * probability of purchase b
ratio = quantity / total
computed_value = math.log10(quantity)
time_log = math.log10(time_value)
#log of denominator jaruri nahi hai because nonetheless it manages
#itself by minusing itself from
bayes_prob = (computed_value) * (value) * (time_log)
final_prob += bayes_prob
shevat = sql_query2(
''' SELECT name from
product_table where product_id = ? ''', (pro_id, ))
every_result = [shevat[0][0], final_prob]
result_list.append(every_result)
if final_prob > max_value:
max_value = final_prob
final_id = pro_id
#prod_id = sql_query2(''' SELECT name from product_table where product_id = ?''', (final_id,))
#prod_id = prod_id[0][0]
#return jsonify(prod_id)
#ab we have that product with us. Lets see kya aaya
from operator import itemgetter
result_list = sorted(result_list, key=itemgetter(1))
time_id = str(get_time())
time = time_id[0:2] + time_id[3:5]
from functions.sqlquery import sql_edit_insert
return_value = sql_edit_insert(
''' INSERT INTO user_side_notifications (user_id, product_id, time_id) VALUES (?,?,?) ''',
(user_id, final_id, time))
#ye idhar hi end hoga
return jsonify(result_list)
def sql_dataedit():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
#old_last_name = request.form['old_last_name']
old_title = request.form['old_title']
#old_first_name = request.form['old_first_name']
old_date = request.form['old_date']
#last_name = request.form['last_name']
title = request.form['title']
#first_name = request.form['first_name']
date = request.form['date']
entered_by = request.form['entered_by']
about = request.form['about']
print(about)
new_string = about
print(
"*********CHNAGE CHANGE***********************************+ NEW STRING "
+ new_string)
chars = [
'\n', '\n\n', '\t', ';', ':', '!', "*", ".", " ", "'", "?", "/",
"\\", "*", ",", "(", ")", "{", "}", "<", ">", "[", "]", "@", "#",
"$", "%", "^", "&", "*", "-", "_", "+", "=", "\"", "\'"
]
for i in chars:
new_string = new_string.replace(i, '')
print(
"*********CHNAGE CHANGE***********************************+ MODIFIED NEW STRING "
+ new_string)
print(
"########################################################## ABOUT "
+ about)
########### Department list #######
department_list = request.form.getlist("department[]")
print(request.form.getlist("department[]"))
department = ', '.join(department_list)
print(department)
amin = request.form.getlist("sdg[]")
print(request.form.getlist("sdg[]"))
sdgs = ','.join(amin)
print(sdgs)
upload = request.form['upload']
if upload == 'Yes':
#### MAKING CHANGES HERE #########
#### MAKING CHANGES HERE #########
f = request.files['other_file']
name = f.filename
f.save(os.path.join(app.config["FILE_UPLOADS"], name))
f.close()
data = "NO DATA AS OF NOW"
else:
name = "NO FILE ATTACHED"
data = "NO FILE ATTACHED"
sql_edit_insert(
''' UPDATE data_table_2 set date = ?, entered_by = ?, title = ?, about = ?, department = ?, sdgs = ?, upload = ?, name = ?, new_string = ? WHERE date=? and title=? ''',
(date, entered_by, title, about, department, sdgs, upload, name,
new_string, old_date, old_title))
results = sql_query(''' SELECT * FROM data_table_2''')
return render_template('update_confirmation.html', results=results)
def sql_datainsert():
from functions.sqlquery import sql_edit_insert, sql_query
if request.method == 'POST':
date = request.form['date']
if date == '':
abort(406)
entered_by = request.form['entered_by']
title = request.form['title']
about = request.form['about']
print(about)
new_string = about
print(
"*********CHANGE CHANGE***********************************+ NEW STRING "
+ new_string)
chars = [
'\n', '\n\n', '\t', ';', ':', '!', "*", ".", " ", "'", "?", "/",
"\\", "*", ",", "(", ")", "{", "}", "<", ">", "[", "]", "@", "#",
"$", "%", "^", "&", "*", "-", "_", "+", "=", "\"", "\'"
]
for i in chars:
new_string = new_string.replace(i, '')
print(
"*********CHANGE CHANGE***********************************+ "
+ new_string)
print(
"########################################################## ABOUT "
+ about)
#details_table = form.details.data
#print(details_table)
########### Department list #######
department_list = request.form.getlist("department[]")
print(request.form.getlist("department[]"))
department = ', '.join(department_list)
print(department)
###################################
amin = request.form.getlist("sdg[]")
print(request.form.getlist("sdg[]"))
sdgs = ','.join(amin)
print(sdgs)
upload = request.form['upload']
#search = 4equest.form['search']
#print(search)
if upload == 'Yes':
f = request.files['other_file']
name = f.filename
#data = f.read()
f.save(os.path.join(app.config["FILE_UPLOADS"], name))
f.close()
data = "NO DATA AS OF NOW"
else:
name = "NO FILE ATTACHED"
data = "NO FILE ATTACHED"
sql_edit_insert(
''' INSERT INTO data_table_2 ( date, entered_by, title, about, department, sdgs, upload, name, new_string) VALUES ( ?, ?, ?,?, ?,?,?, ?, ?) ''',
(date, entered_by, title, about, department, sdgs, upload, name,
new_string))
flash(f' Previous details saved successfully!', 'success')
return redirect(url_for('sql_database'))
#prediction_to_print = 'sdgs can be {}{}'.format(output, o)
results = sql_query(''' SELECT * FROM data_table_2 ''')
return render_template('home_page.html', results=results)
