def delete():
try:
for name in names:
if (pk == name):
pkcol = name
value = entry[name].get()
dbutils.delete(mDBname, mTable, pkcol, value)
tkMessageBox.showinfo("Delete record", "Record deleted")
scrolled_view(root,mDBname,mTable,'g',0, editable)
except Exception, err:
tkMessageBox.showerror("Error", err)
def save():
msg = ''
flag = True
sql_data = load()
for k, v in RESULT.items():
if k in sql_data:
if v != sql_data[k]:
sql = ''' update users set age = {},tel='{}',email='{}' where username='******';
'''.format(RESULT[k]['age'], RESULT[k]['tel'],
RESULT[k]['email'], RESULT[k]['username'])
print(sql)
updateMsg, ok = dbutils.update(sql)
print('updateMsg:%s' % updateMsg)
else:
print('新增数据：%s' % k)
sql = ''' insert into users(username,age,tel,email) \
values('{}',{},'{}','{}');
'''.format(RESULT[k]['username'], RESULT[k]['age'],
RESULT[k]['tel'], RESULT[k]['email'])
print(sql)
insertMsg, ok = dbutils.insert(sql)
print('insertMsg:%s' % insertMsg)
for i in sql_data:
if i not in RESULT:
# sql=''' '''
sql = ''' delete from users where username = '******'; '''.format(i)
print(sql)
deleteMsg, ok = dbutils.delete(sql)
print(deleteMsg)
return msg, flag
def user_save(users):
"""
数据保存到本地文件功能
:param users: 存储于文件中的用户信息字典
:return:
"""
msg = ''
flag = True
# v2数据存储于数据库
sql_data = load()
# 判断内存中的数据是否在sql中，
# 如果在判断是否一致，数据不一致，执行sql更新
# 如果不在将该数据插入sql中，执行sql新增
for k, v in RESULT.items():
# print('='*50)
if k in sql_data:
if v != sql_data[k]:
sql = ''' update users set age = {},tel='{}',email='{}' where username='******';
'''.format(RESULT[k]['age'], RESULT[k]['tel'],
RESULT[k]['email'], RESULT[k]['username'])
print(sql)
updateMsg, ok = dbutils.update(sql)
print('updateMsg:%s' % updateMsg)
else:
# sql新增
print('新增数据：%s' % k)
sql = ''' insert into users(username,age,tel,email) \
values('{}',{},'{}','{}');
'''.format(RESULT[k]['username'], RESULT[k]['age'],
RESULT[k]['tel'], RESULT[k]['email'])
print(sql)
insertMsg, ok = dbutils.insert(sql)
print('insertMsg:%s' % insertMsg)
# 判断数据库中的数据与内存中的数据,不存在则删除该数据
for i in sql_data:
if i not in RESULT:
# sql=''' '''
sql = ''' delete from users where username = '******'; '''.format(i)
print(sql)
deleteMsg, ok = dbutils.delete(sql)
print(deleteMsg)
return msg, flag
def del_user(userinfo):
while len(userinfo) == 1:
sql = '''delete from users where username = '******';'''.format(
userinfo[0])
deleteMsg, ok = delete(sql)
if not ok:
print(deleteMsg)
else:
cur_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
return (
"\033[5;31m[INFO] {} \033[0m {} has been deleted.\n".format(
cur_time, userinfo[0]))
# else:
# return "\033[5;31m{} does not exist.\033[0m\n".format(info_list[1])
else:
return (
"\033[1;31mInput Error！\033[0m\n\033[5;33;42mUsage: delete|del [ {} ]\033[0m\n"
).format(FIELDS[1])
def delete(self):
#数据库操作
#def delete(tb_name, curs, col, val):
blackip = str(e7.get())
conn = sqlite3.connect(db_path)
curs = conn.cursor()
curs, flag = dbutils.delete("Blacklist", curs, "BlackIP", blackip)
conn.commit()
curs.close()
if flag == False:
textvalue = '记录不存在'
else:
textvalue = '删除成功!'
#弹窗
messagebox.showinfo(title='提示', message=textvalue)
def delete(self):
#数据库操作
#def delete(tb_name, curs, col, val):
lab = str(e3.get())
ip = str(e4.get())
conn = sqlite3.connect(db_path)
curs = conn.cursor()
flag0 = 1
if lab != '':
col = 'Lab'
val = lab
elif ip != '':
if not Utils.isIP(ip):
textvalue = 'ip不合法！'
flag0 = 0
else:
col = 'IP'
val = ip
else:
textvalue = "输入为空！"
flag0 = 0
if flag0 == 1:
curs, flag = dbutils.delete("LabIP", curs, col, val)
conn.commit()
curs.close()
if flag == False:
textvalue = '记录不存在'
else:
textvalue = '删除成功!'
#弹窗
messagebox.showinfo(title='提示', message=textvalue)
def delete():
id = int(request.args.get('id'))
dbutils.delete('users', id)
return render_template('userlist.html')