Function runSampleQuery

src/browser/features/Analytics/SqlExplorer.test.ts:51–83

(sample: SampleQuery)

}

function runSampleQuery(sample: SampleQuery): void {
  assert(
    typeof sample.label === "string" && sample.label.trim().length > 0,
    "Sample query label must be a non-empty string"
  );
  assert(
    typeof sample.sql === "string" && sample.sql.trim().length > 0,
    "Sample query sql must be a non-empty string"
  );

  const payload: SampleQueryRunnerPayload = {
    createEventsTableSql: CREATE_EVENTS_TABLE_SQL,
    seedEventsRowSql: SEED_EVENTS_ROW_SQL,
    sample,
  };

  // Bun cannot load @duckdb/node-api in this environment because the native
  // binding depends on libstdc++. Run the DuckDB execution under Node while
  // keeping the SQL setup and assertions in this test file.
  const runner = spawnSync("node", [SAMPLE_QUERY_RUNNER_PATH], {
    env: {
      ...process.env,
      [SAMPLE_QUERY_RUNNER_PAYLOAD_ENV]: JSON.stringify(payload),
    },
    encoding: "utf8",
  });

  const output = `${runner.stdout ?? ""}${runner.stderr ?? ""}`.trim();
  assert(
    runner.status === 0,
    output.length > 0 ? output : `Sample query "${sample.label}" failed without diagnostic output`
  );
}

describe("SAMPLE_QUERIES", () => {
  for (const sample of SAMPLE_QUERIES) {