import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';
import * as schema from './schema';
// for migrations
const migrationClient = postgres("postgres://root@localhost:5432/cafekampung", { max: 1 });
migrate(drizzle(migrationClient), {
migrationsFolder: "drizzle",
migrationsTable: "drizzle_migrations",
migrationsSchema: "public",
});
// for query purposes
const queryClient = postgres("postgres://root@localhost:5432/cafekampung");
export const db = drizzle(queryClient, { schema });
import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';
import * as schema from './schema';
// for migrations
const migrationClient = postgres("postgres://root@localhost:5432/cafekampung", { max: 1 });
migrate(drizzle(migrationClient), {
migrationsFolder: "drizzle",
migrationsTable: "drizzle_migrations",
migrationsSchema: "public",
});
// for query purposes
const queryClient = postgres("postgres://root@localhost:5432/cafekampung");
export const db = drizzle(queryClient, { schema });