import type { Config } from "drizzle-kit";
import { createEnv } from "@t3-oss/env-core";
import * as z from "zod";
const env = createEnv({
server: {
DB_HOST: z.string(),
DB_PORT: z.string(),
DB_NAME: z.string(),
DB_USERNAME: z.string(),
DB_PASSWORD: z.string(),
},
runtimeEnv: process.env,
emptyStringAsUndefined: true,
});
// Push requires SSL so use URL instead of username/password
export const connectionStr = new URL(
`postgres://${env.DB_HOST}:${env.DB_PORT}/${env.DB_NAME}`,
);
connectionStr.username = env.DB_USERNAME;
connectionStr.password = env.DB_PASSWORD;
export default {
schema: ["./src/schema/*"],
driver: "pg",
dialect: "postgresql",
dbCredentials: { url: connectionStr.href },
out: "./drizzle",
} satisfies Config;
import type { Config } from "drizzle-kit";
import { createEnv } from "@t3-oss/env-core";
import * as z from "zod";
const env = createEnv({
server: {
DB_HOST: z.string(),
DB_PORT: z.string(),
DB_NAME: z.string(),
DB_USERNAME: z.string(),
DB_PASSWORD: z.string(),
},
runtimeEnv: process.env,
emptyStringAsUndefined: true,
});
// Push requires SSL so use URL instead of username/password
export const connectionStr = new URL(
`postgres://${env.DB_HOST}:${env.DB_PORT}/${env.DB_NAME}`,
);
connectionStr.username = env.DB_USERNAME;
connectionStr.password = env.DB_PASSWORD;
export default {
schema: ["./src/schema/*"],
driver: "pg",
dialect: "postgresql",
dbCredentials: { url: connectionStr.href },
out: "./drizzle",
} satisfies Config;