wehub-resource-sync
26 lines
1.1 KiB
TypeScript
26 lines
1.1 KiB
TypeScript
import { defineConfig } from "drizzle-kit";
|
|
|
|
// Migrations need a direct (non-pooler) connection; a transaction-mode pooler
|
|
// can't run the migrator. Prefer the agent's direct url, then its pooled url,
|
|
// then the main DIRECT_URL/DATABASE_URL (OSS single-database fallback; tables
|
|
// still land in the trigger_dashboard_agent schema).
|
|
const url =
|
|
process.env.DASHBOARD_AGENT_DIRECT_URL ??
|
|
process.env.DASHBOARD_AGENT_DATABASE_URL ??
|
|
process.env.DIRECT_URL ??
|
|
process.env.DATABASE_URL ??
|
|
"postgres://placeholder"; // generate is offline; a real url is only needed for migrate/studio
|
|
|
|
export default defineConfig({
|
|
schema: "./src/schema.ts",
|
|
out: "./drizzle",
|
|
dialect: "postgresql",
|
|
// Only manage our schema — never introspect or diff Prisma's `public` schema.
|
|
schemaFilter: ["trigger_dashboard_agent"],
|
|
// Own journal table so dev (`drizzle-kit migrate`) and deploy (migrate.mjs)
|
|
// share one history and we don't cross-poison the default
|
|
// drizzle.__drizzle_migrations when the DB is shared. See migrate.mjs.
|
|
migrations: { table: "__dashboard_agent_migrations", schema: "drizzle" },
|
|
dbCredentials: { url },
|
|
});
|