godworld-sync

Purpose

Monitors the exports/ folder for new cycle data and syncs to local SQLite for fast querying. This is the foundation for all other GodWorld skills.

What It Does

1. Reads exports/manifest.json to detect new cycles
2. Compares checksums to avoid duplicate processing
3. Loads cycle-XX-context.json for the latest cycle
4. Updates local SQLite tables:
   • cycles (city state, risk flags)
   • citizens (active citizens, mention tracking)
   • initiatives (civic outcomes)
5. Updates sync_state to track progress

Triggers

Required Config

{
  "godworld": {
    "exportsPath": "./exports",
    "dbPath": "./godworld/godworld.db"
  }
}

Outputs

• Updates SQLite database
• Logs sync summary to console
• Returns: { cyclesSynced: number, recordsUpdated: number }

Error Handling

• If manifest missing: logs warning, exits cleanly
• If checksum matches: skips sync (idempotent)
• If DB error: logs error, does not mark as synced

Dependencies

• better-sqlite3 (npm package)
• SQLite database initialized with schemas/godworld.sql