def addrecord():
response_object = {'status': 'success'}
if request.method == 'POST':
#获取前端传来的数据
data = request.get_json()
username = data['username'].replace("\"", "")
title = data['title']
standard = data['standard']
date = data['date']
attr = data['attr'][0]
object_number = data['object_number']
finished = ''
if statement.Isdate(username, title, date) == True:
sql2 = "DELETE FROM inputDetail WHERE username = '******' and title = '{}' and date = '{}'".format(
username, title, date)
msg2 = statement.remove_mysql(sql2)
print(msg2)
else:
response_object['message'] = "Successful request"
if standard < object_number:
finished = 'false'
else:
finished = 'true'
print(finished)
sql = "insert into inputDetail values (null,\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\')" % (
username, title, attr, standard, date, finished)
msg, res = statement.insert_mysql(sql)
print(msg)
response_object['resCode'] = 101
response_object['message'] = "Successful request"
else:
response_object['message'] = "Unallowed request method."
return jsonify(response_object)
def delete_habit():
response_object = {'status': 'success'}
if request.method == 'POST':
data = request.get_json()
username = data['username']
title = data['title']
sql = "DELETE FROM habit WHERE username = {} and title = '{}'".format(
username, title)
sql2 = "DELETE FROM inputDetail WHERE username = {} and title = '{}'".format(
username, title)
print(sql)
msg = statement.remove_mysql(sql)
msg1 = statement.remove_mysql(sql2)
response_object['message'] = "Successful request"
response_object['resCode'] = 101
else:
response_object['message'] = "Unallowed request method."
return jsonify(response_object)
def remove_record2():
n = request.args['id']
sql = "DELETE FROM habit WHERE ID = {}".format(n)
msg = statement.remove_mysql(sql)
print(msg)
return redirect(url_for('find_all'))
