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