// drizzle.config.js
import 'dotenv/config'
import { defineConfig } from 'drizzle-kit'
/** @type { import("drizzle-kit").Config } */
export default defineConfig({
schema: 'src/db/schema.*',
out: 'src/db/migrations',
dialect: 'postgresql',
dbCredentials: {
url: process.env.DATABASE_URL,
},
verbose: true,
strict: false,
schemaFilter: ['public'],
})
// src/db/index.ts
import { drizzle } from 'drizzle-orm/node-postgres'
import { Client } from 'pg'
import * as schema from './schema'
export const client = new Client(process.env.DATABASE_URL)
export const db = drizzle(client, { schema })
// src/db/migrate.ts
import 'dotenv/config'
import { resolve } from 'path'
import { client, db } from './'
import { migrate } from 'drizzle-orm/node-postgres/migrator'
export default async () => {
await client.connect()
await migrate(db, { migrationsFolder: resolve(__dirname, './migrations') })
await client.end()
// drizzle.config.js
import 'dotenv/config'
import { defineConfig } from 'drizzle-kit'
/** @type { import("drizzle-kit").Config } */
export default defineConfig({
schema: 'src/db/schema.*',
out: 'src/db/migrations',
dialect: 'postgresql',
dbCredentials: {
url: process.env.DATABASE_URL,
},
verbose: true,
strict: false,
schemaFilter: ['public'],
})
// src/db/index.ts
import { drizzle } from 'drizzle-orm/node-postgres'
import { Client } from 'pg'
import * as schema from './schema'
export const client = new Client(process.env.DATABASE_URL)
export const db = drizzle(client, { schema })
// src/db/migrate.ts
import 'dotenv/config'
import { resolve } from 'path'
import { client, db } from './'
import { migrate } from 'drizzle-orm/node-postgres/migrator'
export default async () => {
await client.connect()
await migrate(db, { migrationsFolder: resolve(__dirname, './migrations') })
await client.end()
