drizzle_orm_postgres_migration_runner_quickstart.ts

1import { drizzle } from 'drizzle-orm/postgres-js';
2import { migrate } from 'drizzle-orm/postgres-js/migrator';
3import postgres from 'postgres';
4
5// Connection string for the database
6const connectionString = "postgres://postgres:password@localhost:5432/drizzle";
7const sql = postgres(connectionString, { max: 1 });
8const db = drizzle(sql);
9
10async function main() {
11  // This will run migrations on the database, skipping the ones already applied
12  // The path should point to the migrations folder generated by drizzle-kit
13  await migrate(db, { migrationsFolder: './drizzle' });
14  
15  // Close the connection after migrations are finished
16  await sql.end();
17}
18
19main().catch((err) => {
20  console.error(err);
21  process.exit(1);
22});