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;