def get(self, puzzle_id):
""
ip = request.headers.get("X-Real-IP")
user = int(
current_app.secure_cookie.get(u"user") or user_id_from_ip(ip))
cur = db.cursor()
result = cur.execute(
fetch_query_string("select_viewable_puzzle_id.sql"),
{
"puzzle_id": puzzle_id
},
).fetchall()
if not result:
# 404 if puzzle does not exist
abort(404)
(result, col_names) = rowify(result, cur.description)
puzzle = result[0].get("puzzle")
status = result[0].get("status")
now = int(time.time())
count = (redis_connection.zcount(
"timeline:{puzzle}".format(puzzle=puzzle), now - 5 * 60, "+inf")
or 0)
player_active_count = {"now": now, "count": count}
cur.close()
return json.jsonify(player_active_count)
def get(self):
""
now = int(time.time())
since = now - ACTIVE_RANGE
total_active_player_count = redis_connection.zcount(
"timeline", since, "+inf")
return json.jsonify({"totalActivePlayers": total_active_player_count})
def get(self, puzzle_id):
""
cur = db.cursor()
result = cur.execute(
fetch_query_string("select_viewable_puzzle_id.sql"),
{
"puzzle_id": puzzle_id
},
).fetchall()
if not result:
# 404 if puzzle does not exist
abort(404)
(result, col_names) = rowify(result, cur.description)
puzzle = result[0].get("puzzle")
status = result[0].get("status")
now = int(time.time())
count = (redis_connection.zcount(
"timeline:{puzzle}".format(puzzle=puzzle), now - 5 * 60, "+inf")
or 0)
player_active_count = {"now": now, "count": count}
cur.close()
return make_response(json.jsonify(player_active_count), 200)