• Stefy Lanza (nextime / spora )'s avatar
    Fix SQL reset script to respect foreign key constraints · 6a5e8b04
    Stefy Lanza (nextime / spora ) authored
    - Fix deletion order: child tables before parent tables
    - Add bet_details deletion before bets deletion
    - All 4 options updated with correct deletion order
    - Prevents foreign key constraint errors
    
    Deletion order:
    1. report_sync_logs (no dependencies)
    2. match_reports (child of report_syncs)
    3. extraction_stats (child of report_syncs)
    4. bet_details (child of bets)
    5. bets (parent of bet_details, child of report_syncs)
    6. report_syncs (parent of bets, extraction_stats, match_reports)
    6a5e8b04
Name
Last commit
Last update
.kilocode Loading commit data...
app Loading commit data...
database Loading commit data...
hooks Loading commit data...
.env.example Loading commit data...
.gitignore Loading commit data...
BUILD.md Loading commit data...
CHANGELOG.md Loading commit data...
CLIENT_SYNC_IMPLEMENTATION_GUIDE.md Loading commit data...
CLIENT_SYNC_MINIMAL_PROMPT.md Loading commit data...
GLIBC_COMPATIBILITY.md Loading commit data...
README.md Loading commit data...
REPORTS_FEATURE_README.md Loading commit data...
REPORTS_FINAL_IMPLEMENTATION.md Loading commit data...
REPORTS_IMPLEMENTATION_GUIDE.md Loading commit data...
REPORTS_SYNC_API_SPECIFICATION.txt Loading commit data...
REPORTS_SYNC_PROTOCOL_DOCUMENTATION.md Loading commit data...
REPORTS_UPDATE_IMPLEMENTATION.md Loading commit data...
RESET_REPORTS_SYNC.sql Loading commit data...
backfill_fixture_times.py Loading commit data...
build.py Loading commit data...
config.py Loading commit data...
fixture-manager.spec Loading commit data...
fixture_daemon.py Loading commit data...
install.sh Loading commit data...
main.py Loading commit data...
requirements-build.txt Loading commit data...
requirements.txt Loading commit data...
run_migration.py Loading commit data...
test_clients_implementation.py Loading commit data...
test_reports_sync.py Loading commit data...
test_upload.py Loading commit data...