Function seedWorkspaceDataForQuery

runtime/api-server/src/app.test.ts:79–109

(dbPath: string)

}

function seedWorkspaceDataForQuery(dbPath: string): void {
  const db = new Database(dbPath);
  db.pragma("journal_mode = WAL");
  db.exec(`
    CREATE TABLE twitter_posts (
      id TEXT PRIMARY KEY,
      campaign_key TEXT,
      status TEXT NOT NULL
    );
    CREATE TABLE campaign_plans (
      campaign_key TEXT PRIMARY KEY,
      owner TEXT NOT NULL
    );
  `);
  db.prepare(
    "INSERT INTO twitter_posts (id, campaign_key, status) VALUES (?, ?, ?)",
  ).run("p1", "launch-a", "draft");
  db.prepare(
    "INSERT INTO twitter_posts (id, campaign_key, status) VALUES (?, ?, ?)",
  ).run("p2", "launch-a", "draft");
  db.prepare(
    "INSERT INTO twitter_posts (id, campaign_key, status) VALUES (?, ?, ?)",
  ).run("p3", "launch-b", "published");
  db.prepare(
    "INSERT INTO campaign_plans (campaign_key, owner) VALUES (?, ?)",
  ).run("launch-a", "alice");
  db.prepare(
    "INSERT INTO campaign_plans (campaign_key, owner) VALUES (?, ?)",
  ).run("launch-b", "bob");
  db.close();
}

function writeRuntimeConfig(root: string, document: Record<string, unknown>): void {
  const configPath = path.join(root, "state", "runtime-config.json");