Function seedLegacyScopedSqlite

apps/desktop/scripts/smoke-sidecar.ts:87–142

(dataDir: string, scopeId: string)

};

const seedLegacyScopedSqlite = async (dataDir: string, scopeId: string): Promise<void> => {
  const db = new Database(join(dataDir, "data.db"));
  // oxlint-disable-next-line executor/no-try-catch-or-throw -- boundary: standalone smoke harness closes the SQLite handle before spawning the sidecar
  try {
    // Replay the real legacy v1 chain so the fixture matches the migration
    // history the sidecar's embedded copy expects. A hand-rolled partial
    // schema that claims the full history is applied makes the v1→v2 data
    // migration read tables that don't exist.
    const migrations = await readLegacyMigrations();
    for (const migration of migrations) {
      // `--> statement-breakpoint` markers are SQL line comments, so the
      // whole file executes as one multi-statement batch.
      db.exec(migration.sql);
    }

    db.exec(`
      CREATE TABLE "__drizzle_migrations" (
        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
        hash text NOT NULL,
        created_at numeric
      );
    `);
    const insertMigration = db.prepare(
      `INSERT INTO "__drizzle_migrations" (hash, created_at) VALUES (?, ?)`,
    );
    for (const migration of migrations) {
      insertMigration.run(migration.hash, Date.now());
    }

    db.prepare(
      `INSERT INTO source (
        scope_id, id, plugin_id, kind, name, url, can_remove, can_refresh, can_edit, created_at, updated_at
      ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
    ).run(
      scopeId,
      "legacy-smoke",
      "smoke",
      "remote",
      "Legacy Smoke Source",
      null,
      1,
      0,
      1,
      1_700_000_000_000,
      1_700_000_001_000,
    );
    db.prepare("INSERT INTO blob (namespace, key, value) VALUES (?, ?, ?)").run(
      `${scopeId}/smoke`,
      "legacy",
      "{}",
    );
    db.exec("PRAGMA wal_checkpoint(TRUNCATE); PRAGMA journal_mode = DELETE;");
  } finally {
    db.close();
  }
};

// The v1→v2 migration moves the legacy SQLite file set aside as