Open History to see the last commit
1// Seeds the providers table. Local D1 by default; pass --remote to target
2// production: `pnpm run seed` / `pnpm run seed -- --remote`.
3//
4// Goes through `wrangler d1 execute` (instead of a drizzle client) so the
5// script works against wrangler's local sqlite state without a node sqlite
6// driver dependency.
7import { spawnSync } from 'node:child_process'
8import { mkdtempSync, readdirSync, writeFileSync } from 'node:fs'
9import { tmpdir } from 'node:os'
10import { dirname, join } from 'node:path'
11import { fileURLToPath } from 'node:url'
12
13import { packageBin } from './package-bin.ts'
14import { providerSeeds, seedFromAdapter } from '../src/db/seed-providers.ts'
15import type { ProviderConfig } from '../src/server/providers/types.ts'
16
17const adaptersDir = join(
18 dirname(fileURLToPath(import.meta.url)),
19 '../src/server/providers/adapters',
20)
21
22async function loadAdapterSeeds(): Promise<
23 Array<(typeof providerSeeds)[number]>
24> {
25 const files = readdirSync(adaptersDir).filter(
26 (name) => name.endsWith('.ts') && !name.endsWith('.test.ts'),
27 )
28 const seeds: Array<(typeof providerSeeds)[number]> = []
29 for (const file of files) {
30 const mod = (await import(join(adaptersDir, file))) as {
31 provider?: ProviderConfig
32 }
33 if (!mod.provider) {
34 throw new Error(
35 `adapter ${file} must export const provider: ProviderConfig`,
36 )
37 }
38 seeds.push(seedFromAdapter(mod.provider))
39 }
40 return seeds
41}
42
43function sqlLiteral(value: string | null | undefined): string {
44 if (value == null) return 'NULL'
45 return `'${value.replaceAll("'", "''")}'`
46}
47
48const seeds = [...providerSeeds, ...(await loadAdapterSeeds())]
49
50// Idempotent upsert: refreshes the seeded config columns, preserves runtime
51// state (last_polled_at, last_synced_at, status).
52const statements = seeds.map(
53 (
54 p,
55 ) => `INSERT INTO providers (id, display_name, spec_source_url, models_endpoint, auth_env_var)
56VALUES (${sqlLiteral(p.id)}, ${sqlLiteral(p.displayName)}, ${sqlLiteral(p.specSourceUrl)}, ${sqlLiteral(p.modelsEndpoint)}, ${sqlLiteral(p.authEnvVar)})
57ON CONFLICT(id) DO UPDATE SET
58 display_name = excluded.display_name,
59 spec_source_url = excluded.spec_source_url,
60 models_endpoint = excluded.models_endpoint,
61 auth_env_var = excluded.auth_env_var;`,
62)
63
64const sqlFile = join(
65 mkdtempSync(join(tmpdir(), 'modelschemas-seed-')),
66 'seed.sql',
67)
68writeFileSync(sqlFile, statements.join('\n\n') + '\n')
69
70const target = process.argv.includes('--remote') ? '--remote' : '--local'
71const result = spawnSync(
72 process.execPath,
73 [packageBin('wrangler'), 'd1', 'execute', 'DB', target, '--file', sqlFile],
74 { stdio: 'inherit' },
75)
76
77if (result.status !== 0) {
78 console.error(`seed failed (wrangler exit ${String(result.status)})`)
79 process.exit(result.status ?? 1)
80}
81console.log(`seeded ${String(seeds.length)} providers (${target})`)