33 Commits

Author SHA1 Message Date
Jack Jackson
9b4e6c3b4d Introduce ability to seed data directly from GSheet
All checks were successful
Publish / build-and-push (push) Successful in 6m14s
Reasonably hacky, in that I introduce a facade to reuse the data format
previously provided by the `csv` module, rather than using the
`list[list[str]]` directly.

Next I want to introduce something like Celery to continually refresh.

Note that this will require changes to the deployment repo in order to
provide the required secrets.
2025-04-17 22:22:21 -07:00
Jack Jackson
6f6b58159f Default to "most-recent 10 games" in /game/list view
Some checks failed
Publish / build-and-push (push) Failing after 4m6s
Also fully migrate to Gitea Actions (from Drone) for CI/CD.
2025-04-05 16:35:39 -07:00
Jack Jackson
c53e2aafc5 Coerce types to match when dealing with ties
Also add a rudimentary publication workflow, as I'm migrating away from
Drone - see [here](https://blog.scubbo.org/posts/gitea-actions/).
2025-04-05 14:45:44 -07:00
Jack Jackson
c6a279a703 Support ties 2024-11-18 19:47:40 -08:00
Jack Jackson
8b5d96e76f Rudimentary game-suggestion 2024-09-04 21:49:25 -07:00
Jack Jackson
5d2183bbf0 Fix to top movers
Don't try processsing decks that don't have a score before the cut-off
date.
2024-08-23 09:58:58 -07:00
Jack Jackson
f120336f1d Add cursory "biggest movers" stats
Also adds rudimentary testing framework for seeding a database from a
given `.db` SQLite file. Probably extract this for general use!
2024-08-23 09:26:22 -07:00
Jack Jackson
bf7997bd1d Add score-graph on player page 2024-08-07 22:26:39 -07:00
Jack Jackson
fff79bf883 Specify sort-order for deck-detail page 2024-08-07 21:08:18 -07:00
Jack Jackson
b01831b5ac Add scores-by-date for deck 2024-08-07 21:02:02 -07:00
Jack Jackson
5d71f422f3 Allow check/unchecking all decks for a player in graph page 2024-07-31 20:50:21 -07:00
Jack Jackson
3b1c3d7eb3 Add filtering on graph 2024-07-29 20:16:01 -07:00
Jack Jackson
dee0c26260 Support filtering for graph (no frontend support yet) 2024-07-29 11:04:13 -07:00
Jack Jackson
e263683ce6 Committing to save - incomplete implementation of graphing 2024-07-28 23:23:11 -07:00
Jack Jackson
105dc438bd Support sorting in the list of games 2024-07-28 19:18:36 -07:00
Jack Jackson
0e69452403 Support sort-by and sort-order in game listing
Not yet supported on the front-end - we'll get to that in the next
commit!
2024-07-27 21:14:09 -07:00
Jack Jackson
2fb5a291e5 Implement incremental updating
When `seed/all_in_one` is now called, it will update with only that data
that exists later than the most-recently-played* game, allowing the
upload to be used repeatedly without having to clear the database.

\* Actually, "highest-ID game", as we haven't implemented
`list_games_by_date`, yet
2024-07-27 20:05:28 -07:00
Jack Jackson
1c9aa30721 Add "Latest Score" in Decks view
Also experiment with auto-helm-update and caching, and make some updates
to seed data
2024-07-10 21:20:48 -07:00
Jack Jackson
624ef62345 Lookup decks in seeding by player+deck-name (to take account of duplicates 2024-06-29 13:46:33 -07:00
Jack Jackson
7545966aed Add "Games Played" column in deck list 2024-06-28 18:12:52 -07:00
Jack Jackson
22768b70eb Reintroduce no-limits in get_decks 2024-06-27 10:22:33 -07:00
Jack Jackson
bf7039aa41 Remove negative limit
Legal for SQLite but not for Postgres 🤷
2024-06-27 09:48:37 -07:00
Jack Jackson
01e4c5e36b Factor out rendering of game participants 2024-06-26 19:23:04 -07:00
Jack Jackson
e4ea529fbe Cosmetic and final-basic functionality
At this point it _should_ be just about usable for folks to poke-around
in, though ugly as sin.
2024-06-09 09:45:56 -07:00
Jack Jackson
817f52b359 Game views 2024-03-01 23:08:46 -08:00
Jack Jackson
cc6c4818ad Initial seeding logic 2024-03-01 21:35:06 -08:00
Jack Jackson
c36c4bd3b8 Enable ruff, black, and pytest in pre-commit 2024-02-14 22:43:25 -08:00
Jack Jackson
7e54b9dc65 Player List (and default responseClass) 2024-02-11 15:07:29 -08:00
Jack Jackson
e7831948b2 Start of Game-creation HTML 2024-02-05 21:24:42 -08:00
Jack Jackson
83d2fcb9d1 Ruff-format 2024-01-31 20:46:04 -08:00
Jack Jackson
608df42388 Factor out common prefixes 2024-01-31 20:44:51 -08:00
Jack Jackson
fbbaadd098 Flesh out player and deck HTML 2024-01-31 19:48:58 -08:00
Jack Jackson
5472dbc8b9 Convert to FastAPI 2024-01-26 22:53:56 -08:00