67 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
0434ec1e98 Correction to publish workflow
All checks were successful
Publish / build-and-push (push) Successful in 1m17s
Using (corrected!) credentials to push
2025-04-06 23:38:19 -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
119b086f92 Specify pushing to gitea, not github
All checks were successful
Publish / build-and-push (push) Successful in 3m58s
2025-04-05 15:52:38 -07:00
Jack Jackson
6e3d4a3148 Checkout before building
Some checks failed
Publish / build-and-push (push) Failing after 3m56s
2025-04-05 14:55:16 -07:00
Jack Jackson
5b9eeb63f8 Specify registry to login to
Some checks failed
Publish / build-and-push (push) Failing after 35s
2025-04-05 14:52:17 -07:00
Jack Jackson
c3ceeea808 Update secret-path to account for kvv2-ness
Some checks failed
Publish / build-and-push (push) Failing after 14s
2025-04-05 14:49:19 -07:00
Jack Jackson
51e23a67dd Retrigger after enabling actions
Some checks failed
Publish / build-and-push (push) Failing after 45s
2025-04-05 14:47:25 -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
16c4d20b63 Actually-install sqlite3 for dev target 2025-04-05 13:45:05 -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
460467bd0b Remove GitHub Workflows 2024-08-07 22:42:23 -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
c874de3a4c Simplification of direct psql connection 2024-08-07 21:03:52 -07:00
Jack Jackson
b01831b5ac Add scores-by-date for deck 2024-08-07 21:02:02 -07:00
Jack Jackson
2ba4cf9a30 Add Drone steps to update argo and purge cache 2024-07-31 20:53:22 -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
fff4fa6c57 Styling suggestions from Jeff 2024-07-30 09:59:41 -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
fbdc98f967 Styling tweak 2024-07-29 10:38:19 -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
d605293c8f Correction to seed-data 2024-06-29 13:45:28 -07:00
Jack Jackson
4d4d9aa55f Remove cache-to 2024-06-28 18:18:50 -07:00
Jack Jackson
7545966aed Add "Games Played" column in deck list 2024-06-28 18:12:52 -07:00
Jack Jackson
87a336787c Add explicit cache-to instruction 2024-06-28 17:54: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
61078f0201 Correction to Docker buildx cache-from in Drone CI 2024-06-26 18:50:36 -07:00
Jack Jackson
e75f23e3d9 Add psycopg2 dependency for prod 2024-06-24 21:22:51 -07:00
Jack Jackson
3183b56075 Address case-mismatch warning 2024-06-23 18:11:17 -07:00
Jack Jackson
3239c4c037 Introduce caching 2024-06-23 16:04:49 -07:00
Jack Jackson
9f73d26809 Specify build-target 2024-06-23 15:55:38 -07:00
Jack Jackson
deff3a6344 Build with Drone 2024-06-09 10:25:03 -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
ac4bdd09b8 First implementation of ELO logic 2024-03-03 19:18:06 -08:00
Jack Jackson
6f0e7cd593 Docker-ify development process 2024-03-03 16:24:19 -08: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