def sign_out (): payload = request.json["payload"]; __jwt = payload["jwt"]; result = jwt.is_valid_jwt(__jwt); user_id = result[1]; with connection.cursor() as cursor: sql = """INSERT INTO use_jwt(jwt, users_id) VALUES ("", %s) ON DUPLICATE KEY UPDATE jwt = "" FROM users WHERE user_id = %s;""" cursor.execute(sql, (user_id)); connection.commit(); redirect(root.SERVER_URL);
def check_jwt () : jwt = request.json["payload"]; try: state, user_id = is_valid_jwt(jwt); except: json_data = {"message":"FALSE","data": "authentication error from jwt"}; encoded_json = json.dumps(json_data); r = HTTPResponse(status=401,body=encoded_json,content_type = "application/json"); return r; user_info = user_modules.get_user_info(user_id); if state: dict_data = { "status_code": 200, "status_message": "SUCCESS", "data": { "jwt": jwt, "user":{ "user_id": user_id, "user_name": user_info["user_name"], }, "items":[] } } json_data = json.dumps(dict_data); r = HTTPResponse(status=200,body=json_data); else : dict_data = { "status_code": 401, "status_message": "UNAUTHORIZED", } json_data = json.dumps(dict_data); r = HTTPResponse(status=401,body=json_data); return r;
def wrapper(): payload = request.json["payload"]; __jwt = payload["jwt"]; try: status, user_id = jwt.is_valid_jwt(__jwt); except: json_data = { "api":{"status": "UnAuthentication", "message": "failure authentication", "data": None} } parsed_json = json.dumps(json_data); r = HTTPResponse(status=301, body=parsed_json, content_type = "application/json"); return r; if status: # last_update確認して日にちをまたいでいたらtodoのachiveをFalseにする result_goal_data = get_active_goal(user_id); if result_goal_data is not None: goals_id = result_goal_data["id"]; # NOW()時間がずれている with connection.cursor() as cursor: sql = """UPDATE todos SET achieve = 0 WHERE goals_id = %s AND 1 <= DATEDIFF(NOW(),(SELECT last_update FROM users WHERE user_id = %s))""" cursor.execute(sql,(goals_id, user_id)); connection.commit(); with connection.cursor() as cursor: sql = """UPDATE users SET last_update = NOW() WHERE user_id = %s""" cursor.execute(sql,(user_id)); connection.commit(); result = func(user_id); return result;