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