3 Commits

Author	SHA1	Message	Date
Bill	45cd1e12b6	feat: drop old schema tables (trading_sessions, positions, reasoning_logs) ... - Created migration script to drop old tables - Removed old table creation from database.py - Added tests to verify old tables are removed and new tables exist - Migration script can be run standalone with: PYTHONPATH=. python api/migrations/002_drop_old_schema.py	2025-11-04 10:26:00 -05:00
Bill	655f2a66eb	fix: enable foreign key constraints and ensure jobs table prerequisite ... - Add PRAGMA foreign_keys = ON at the beginning of create_trading_days_schema() - Create jobs table if it doesn't exist as a prerequisite for the foreign key constraint - Ensures referential integrity is properly enforced for the trading_days table	2025-11-03 23:06:19 -05:00
Bill	81cf948b70	feat: add trading_days schema migration	2025-11-03 23:00:24 -05:00