1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
from flask import Blueprint, request
from functools import reduce
from mergedeep import merge
from db import cursor
from user.info import format_user
from ruleset import resolve_ruleset
from game.info import format_game
from hierarchy import one_person
import json
# get total game outcome amount for user
def sum_games(user_id): #! SANITIZE USER_ID FIRST
wld_querys = [
' '.join(
[
"select count(game_id)",
"from games",
"where",
f"player_{x[0]}_id = \"{user_id}\" and",
f"outcome = \"{x[1]}\"",
]
) for x in [(1, "w"), (1, "l"), (2, "w"), (2, "l")]
]
wld_querys.insert(
0, ' '.join(
[
"select count(game_id)",
"from games",
"where",
f"(player_1_id = \"{user_id}\" or player_2_id = \"{user_id}\") and",
"outcome = \"d\"",
]
)
)
big_query = "select " + ", ".join([f"({query})" for query in wld_querys])
results = cursor.execute(big_query).fetchone()
# win and lose are calculated from user_id's perspective (player_1_id, player_2_id in db)
return {
"draw": results[0],
"win": results[1] + results[4],
"lose": results[2] + results[3],
"games": reduce(lambda a, b: a + b, results)
}
# get `count` games that `user_id` participated in, sorted by newest game
def fetch_games(user_id, count):
game_ids = cursor.execute(
"select game_id from games where player_1_id = ? or player_2_id = ? order by created desc",
[user_id, user_id]
).fetchmany(count)
export = []
for game_id in game_ids:
export.append(format_game(game_id[0], user_id))
return export
games = Blueprint('games', __name__)
@games.route('/games', methods=['GET', 'POST'])
@one_person
def index(user_id, viewer):
return {
"totals": sum_games(user_id),
"games": fetch_games(user_id, 20)
}, 200
dynamic_route = ["/user", games]
|