How to use drizzle-kit?

[mattiaz9]

I'm trying to figure out how to apply migrations using drizzle-kit but I'm stuck.

This is the procedure that I used:

First I start introspecting an exiting db:
npx drizzle-kit introspect:pg --connectionString=postgres://root:root@localhost:5432/test --out=database/migrations
with the output:

[✓] 30  tables fetched
[✓] 339 columns fetched
[✓] 1   enums fetched
[✓] 28  indexes fetched
[✓] 64  foreign keys fetched

[✓] Your SQL migration file ➜ database/migrations/0000_stale_goblin_queen.sql 🚀
[✓] You schema file is ready ➜ database/migrations/schema.ts 🚀

Then I run the migration command:
npx drizzle-kit generate:pg
with the output:

26 tables
...

[✓] Your SQL migration file ➜ database/migrations/0001_giant_iron_patriot.sql 🚀

Then I apply the migrations with the command:
npx drizzle-kit up:pg

but the output is:

Reading drizzle.config.json
Everything's fine 🐶🔥

my drizzle.config.json:

{
  "out": "./database/migrations",
  "schema": "./database/schema.ts",
  "breakpoints": false
}

how am I supposed to apply the migrations that drizzle-kit created?

[david-plugge]

up:<dialect> is used for updating the metadata https://orm.drizzle.team/kit-docs/commands#maintain-stale-metadata
You want to use push:<dialect> instead, but that is currently only available for mysql.

I´m facing the same issue right now and wrote a script to apply the migrations (i´m using postgres-js):

import 'dotenv/config';
import postgres from 'postgres';
import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';

const client = postgres(process.env.DATABASE_URL, { max: 1 });

await migrate(drizzle(client, { logger: true }), {
    migrationsFolder: 'drizzle',
});

I added a script to package.json "db:migrate": "node scripts/migrate". The migrations are applied but the script never finishes. No idea why.

[david-plugge]

I´ll answer myself, i forgot to close the db connection...

Just append this to the script:

await client.end()