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)