paper-dynasty-database/app
Cal Corum ec04a111c5
All checks were successful
Build Docker Image / build (pull_request) Successful in 8m32s
fix: remove legacy SQLite compatibility code (#122)
Closes #122

Both prod and dev environments use PostgreSQL. Removes all SQLite
compatibility code that was never exercised in practice.

Changes:
- db_engine.py: replace SQLite/PostgreSQL branching with direct
  PooledPostgresqlDatabase init; remove DATABASE_TYPE, SKIP_TABLE_CREATION,
  all db.create_tables() calls, and commented-out SQLite scout_db code
- db_helpers.py: remove DATABASE_TYPE var and SQLite on_conflict_replace
  branch from upsert_many(); PostgreSQL ON CONFLICT is now the only path
- players.py: update stale comment
- tests/conftest.py: remove DATABASE_TYPE env var (no longer needed);
  keep POSTGRES_PASSWORD dummy for instantiation
- CLAUDE.md: update SQLite references to PostgreSQL

Note: unit tests in test_evolution_seed.py and test_season_stats_model.py
use SqliteDatabase(':memory:') for test isolation — this is legitimate test
infrastructure, not production SQLite compatibility code.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-22 23:37:02 -05:00
..
models refactor: split PlayerSeasonStats into BattingSeasonStats and PitchingSeasonStats 2026-03-17 09:43:22 -05:00
routers_v2 fix: remove legacy SQLite compatibility code (#122) 2026-03-22 23:37:02 -05:00
seed feat: evolution track seed data and tests (WP-03) (#68) 2026-03-12 17:35:12 -05:00
services refactor: deduplicate pitcher formula and test constants 2026-03-17 09:49:33 -05:00
__init__.py Initial Commit with /current 2023-09-13 14:44:26 -05:00
card_creation.py Update card_creation.py 2024-02-24 21:36:44 -06:00
db_engine.py fix: remove legacy SQLite compatibility code (#122) 2026-03-22 23:37:02 -05:00
db_helpers.py fix: remove legacy SQLite compatibility code (#122) 2026-03-22 23:37:02 -05:00
dependencies.py fix: use constant-time comparison for bearer token validation (#8) 2026-03-05 03:43:59 +00:00
main.py Merge main into next-release 2026-03-17 13:53:46 -05:00
player_scouting.py Update player_scouting.py 2023-09-24 19:00:21 -05:00