def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': dname = request.args.get('dname') sql_delete(''' DELETE FROM data_table where drink_name = ?''', (dname) ) results = sql_query(''' SELECT * FROM data_table''') msg = 'DELETE FROM data_table WHERE drink_name = ' + dname return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': zip = request.args.get('zipcode') sql_delete(''' DELETE FROM data_table where zip = ? ''', (zip)) results = sql_query(''' SELECT * FROM data_table''') msg = 'DELETE FROM data_table WHERE zipcode = ' + zip return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': lname = request.args.get('lname') fname = request.args.get('fname') sql_delete(''' DELETE FROM data_table where first_name = ? and last_name = ?''', (fname,lname) ) results = sql_query(''' SELECT * FROM data_table''') msg = 'DELETE FROM data_table WHERE first_name = ' + fname + ' and last_name = ' + lname return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': lreply = request.args.get('lreply') fquery = request.args.get('fquery') sql_delete(''' DELETE FROM dataset where query = ? and reply = ?''', (fquery, lreply)) results = sql_query(''' SELECT * FROM dataset''') msg = 'DELETE FROM dataset WHERE query = ' + fquery + ' and reply = ' + lreply return render_template('t_board.html', results=results, msg=msg)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': s_artist = request.args.get('s_artist') s_title = request.args.get('s_title') sql_delete(''' DELETE FROM record WHERE artist = ? and title = ?''', (s_artist,s_title)) results = sql_query(''' SELECT * FROM record''') msg = 'DELETE FROM record WHERE artist = ' + s_artist + ' and title = ' + s_title return render_template('sqldatabase.html', results=results, msg=msg)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query, sql_query2 if request.method == 'GET': # print('here') name=request.args.get('episode_name') print(name) # fname=request.args.get('fname') # item = sql_query2(''' SELECT * FROM got WHERE `episode name`= ? ''', (name, )) # print(item, 'ITEM') sql_delete( '''DELETE FROM got where `episode name` = (?)''', (name,)) results=sql_query(''' SELECT * FROM got''') msg='deleted the '+name+' item from db' return render_template('sqldatabase.html', results = results, msg = msg)
def department_sql_datadelete(): from functions.sqlquery import sql_delete, sql_query2 if request.method == 'GET': ldate = request.args.get('ldate') ltitle = request.args.get('ltitle') #sdg = request.args.get('sdgs') #sql_delete(''' DELETE FROM data_table where date = ? and title = ?''', (ldate, ltitle) ) #r = confirm("Press a button!"); #if r == True: #sql_delete(''' DELETE FROM data_table where date = ? and title = ?''', (ldate, ltitle) ) #else: #print("Delete cancelled!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!s") sql_delete( ''' DELETE FROM data_table_2 where date = ? and title = ?''', (ldate, ltitle)) flash('Selected record deleted successfully!', 'danger alert-dismissible fade show') return render_template('delete_confirmation_for_department.html')
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': ldate = request.args.get('ldate') ltitle = request.args.get('ltitle') #sql_delete(''' DELETE FROM data_table where date = ? and title = ?''', (ldate, ltitle) ) #r = confirm("Press a button!"); #if r == True: #sql_delete(''' DELETE FROM data_table where date = ? and title = ?''', (ldate, ltitle) ) #else: #print("Delete cancelled!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!s") sql_delete( ''' DELETE FROM data_table_2 where date = ? and title = ?''', (ldate, ltitle)) flash('Selected record deleted successfully!', 'danger alert-dismissible fade show') results = sql_query(''' SELECT * FROM data_table_2''') #msg = 'DELETE FROM data_table WHERE date = ' + ldate + ' and title = ' + ltitle #return render_template('sqldatabase.html', results=results, msg=msg) return render_template('new_view.html', results=results)
def sql_datadelete(): from functions.sqlquery import sql_delete, sql_query if request.method == 'GET': word = request.args.get('word') # fname = request.args.get('fname') sql_delete(''' DELETE FROM words where word = ?''', (word, )) results1 = sql_query(''' SELECT * FROM words''') msg = 'DELETE FROM words WHERE word = ' + word 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 deleteData(): user_id = request.form['user_id'] from functions.sqlquery import sql_delete results = sql_delete(''' DELETE from searches where user_id = ?''', (user_id, )) return jsonify(results)
def data_prepare(): print(" iam fine") global intent global query global response global check_presence global existing_intents conn=sqlite3.connect('./datasets/user_log.db') qry = "Select intent, query, reply From dataset Order By intent, query, reply" # Assumes conn is a database connection. cursor = conn.cursor() cursor.execute(qry) rows = [x for x in cursor] cols = [x[0] for x in cursor.description] #data = [] header=[] values=[] intention=[] question=[] answer=[] for row in rows: data = {} for prop, val in zip(cols, row): header.append(prop) values.append(val) for head,value in zip(header,values): #print(head) if head=='intent': intention.append(value) print(intent) elif head=='query': question.append(value) #print("i am qery",query) elif head=='reply': answer.append(value) #print(response) for user_intent,user_query,bot_reply in zip(intention,question,answer): with open('nrn.json', mode='r', encoding='UTF-8') as feedsjson: feeds = json.load(feedsjson) list_data = ((feeds['intents'])) print(list_data) for intents in list_data: if intents['intent'] not in existing_intents: existing_intents.append(intents['intent']) else: continue if user_intent in existing_intents: print("iam in") for intents in list_data: if user_intent== intents['intent']: qstn=[w for w in [user_query] if w not in intents['query']] rep=[x for x in [bot_reply] if x not in intents['response']] try: intents['query'].append(qstn[0]) except: print("query already present in the dataset") try: intents['response'].append(rep[0]) # print(intents['response']) except: print("response already present") matched_content = {'intents': feeds['intents']} print(matched_content) with open('nrn.json', 'w')as file: json.dump(matched_content, file) sql_delete(''' DELETE FROM dataset where query = ? and reply = ?''', (user_query,bot_reply)) else: continue else: entry={'intent':user_intent,'query':[user_query],'response':[bot_reply]} list_data.append(entry) content={'intents':list_data} with open('nrn.json', 'w')as file: json.dump(content, file) sql_delete(''' DELETE FROM dataset where query = ? and reply = ?''', (user_query, bot_reply)) print(existing_intents) return 0