paper-dynasty-database/app/routers_v2
Cal Corum 40c512c665 Add PostgreSQL compatibility fixes for query ordering
- Add explicit ORDER BY id to all queries for consistent results across SQLite and PostgreSQL
- PostgreSQL does not guarantee row order without ORDER BY, unlike SQLite
- Skip table creation when DATABASE_TYPE=postgresql (production tables already exist)
- Fix datetime handling in notifications (PostgreSQL native datetime vs SQLite timestamp)
- Fix grouped query count() calls that don't work in PostgreSQL
- Update .gitignore to include storage/templates/ directory

This completes the PostgreSQL migration compatibility layer while maintaining
backwards compatibility with SQLite for local development.

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
2026-02-03 10:39:14 -06:00
..
__init__.py Initial Commit with /current 2023-09-13 14:44:26 -05:00
admin.py Support for Exhibition games & Swagger updates 2024-07-11 15:07:23 -05:00
awards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
batstats.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
battingcardratings.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
battingcards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
cardpositions.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
cards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
cardsets.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
current.py Support for Exhibition games & Swagger updates 2024-07-11 15:07:23 -05:00
decisions.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
events.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
gamerewards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
gauntletrewards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
gauntletruns.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
mlbplayers.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
notifications.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
packs.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
packtypes.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
paperdex.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
pitchingcardratings.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
pitchingcards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
pitstats.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
players.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
rarity.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
results.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
rewards.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
scouting.py Scouting tables added to db 2023-09-22 01:29:35 -05:00
stratgame.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
stratplays.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00
teams.py Add PostgreSQL compatibility fixes for query ordering 2026-02-03 10:39:14 -06:00