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'))