Commit Graph

12 Commits

Author SHA1 Message Date
Cal Corum
985a6ed2b0 Add default ORDER BY id to BaseModel.select() for PostgreSQL compatibility
PostgreSQL does not guarantee row order without ORDER BY, unlike SQLite
which implicitly returned rows by rowid. This caused bugs where queries
returned results in unexpected order (e.g., get_team_by_owner returning
gauntlet team instead of main team).

Override select() in BaseModel to add default ordering by id. Explicit
.order_by() calls will override this default.

Also mark legacy db_engine.py as deprecated.
2026-01-31 16:06:44 -06:00
Cal Corum
8c039dedf8 Fix DateTimeField defaults for PostgreSQL compatibility
Paperdex and GauntletRun models used int timestamps as defaults which
worked in SQLite but fail in PostgreSQL. Changed to datetime.now.
2026-01-31 15:56:33 -06:00
Cal Corum
96be768ec9 Pre-Season 6 Updates 2023-10-19 23:16:47 -05:00
Cal Corum
07c1b51d0f Bug fixes for unique indeces 2023-10-03 12:06:48 -05:00
Cal Corum
8a0d094227 Scouting tables added to db 2023-09-22 01:29:35 -05:00
Cal Corum
a5e6788289 Hash updates for marketplace transactions 2023-09-12 21:06:38 -05:00
Cal Corum
2be7955e89 Consolidated scouting db preparation 2023-09-07 13:14:53 -05:00
Cal Corum
1c689d3194 Gauntlets functional 2023-03-20 01:45:14 -05:00
Cal Corum
12e1988322 Added GauntletRun and GauntletReward 2023-03-14 00:46:29 -05:00
Cal Corum
8d0b359e85 Pack Type addition
add pack_team and pack_cardset fields
2023-03-06 13:29:19 -06:00
Cal Corum
d613901c97 Update db_engine.py
update logging location
2023-02-25 18:39:33 -06:00
Cal Corum
f004c58f63
Initial commit 2023-02-19 21:41:23 -06:00