def api():
print("kommer vi till server api")
if request.environ.get('wsgi.websocket'):
ws = request.environ['wsgi.websocket']
token = ws.receive()
token = token.replace('"','')
email = database_helper.get_data(None,token)[0]
print(email)
print(token)
print(active_sessions)
if email in active_sessions:
try:
print(active_sessions[email][0])
active_sessions[email][0].send(json.dumps("log out"))
print("email in active session??")
except:
print("if resfresh, session dies")
del active_sessions[email]
active_sessions[email] = [ws,token]
try:
while True:
msg = active_sessions[email][0].receive()
if(msg == "close"):
print("close connection")
msg = active_sessions[email][0].close()
database_helper.remove_user(active_sessions[email][1])
del active_sessions[email]
break
except:
print("session died while waiting for connection close msg")
return ""
def get_max_date():
"""
Function to get the max date from tweets2019
"""
sql = """
SELECT MAX (created_at)
FROM tweets2019;"""
max_date = database_helper.get_data(sql)
return max_date.iloc[0]['max']
def get_user_data_by_email():
#recieve email and token
token = get_token()
email = request.args.get('email')
if not database_helper.validate_user(None, token):
return jsonify({"success": False, "msg": "Unauthorized"})
#check if the user is active
result = database_helper.get_data(email, token)
if result == None:
return jsonify({"success": False, "msg": "no data found"})
#get the result from user table
return jsonify({"success": True, "msg": "found user data", "data": result})
def user_sign_out():
token = get_token()
email = database_helper.get_data(None,token)[0]
try:
active_sessions[email][0].send("close")
del active_sessions[email]
except:
print("log out")
if not database_helper.validate_user(None,token):
return jsonify({"success":False,"msg" : "Unauthorized"})
database_helper.remove_user(token)
return jsonify({"success":True,"msg" : "user logged out"})
def get_user_data_by_token():
#recieve token
token = get_token()
#display all user for the user with the correct token
#find the active user with correlating token
if not database_helper.validate_user(None, token):
return jsonify({"success": False, "msg": "Unauthorized"})
#select data with the correct user
result = database_helper.get_data(None, token)
if result == None:
return jsonify({"success": False, "msg": "Unable to find user"})
return jsonify({"success": True, "msg": "found user data", "data": result})