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