Suji Comments - Answer Overflow

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

config();

const migrateDb = async () => {
  const connectionString = process.env.DATABASE_URL;

  if (!connectionString) {
    throw new Error('DATABASE_URL environment variable is not set');
  }

  const sql = postgres(connectionString, { max: 1 });
  const db = drizzle(sql);

  await migrate(db, { migrationsFolder: 'drizzle' });

  console.info('Migrations are successfully applied');
  exit(0);
};

void migrateDb();

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

config();

const migrateDb = async () => {
  const connectionString = process.env.DATABASE_URL;

  if (!connectionString) {
    throw new Error('DATABASE_URL environment variable is not set');
  }

  const sql = postgres(connectionString, { max: 1 });
  const db = drizzle(sql);

  await migrate(db, { migrationsFolder: 'drizzle' });

  console.info('Migrations are successfully applied');
  exit(0);
};

void migrateDb();

This file lives at the root of the project and the migration folder 'drizzle' is also on the same level i use this on railway and on eb by just appending it to the build step as you have done, works so far for me

16 replies

DTDrizzle Team

•Created by .deini on 7/4/2023 in #help

sql escaping on where

ran into a simillar issue where im conditionaly building the where clause where.push( sqlCONCAT(${users.firstName},' ', ${users.lastName}) ILIKE '%${name}%', ); this throws a bind message error you can build the string like this, where your adding the % within the interpolation sql`CONCAT(${users.firstName},' ', ${users.lastName}) ILIKE ${'%' + pageOptionsDto.name + '%'}

4 replies

DTDrizzle Team

•Created by Suji on 6/1/2023 in #help

Infer return type for relational query with pagination

Nope

3 replies

DTDrizzle Team

•Created by Suji on 5/29/2023 in #help

Doent infer type in Callback syntax for query

nvm, i expected relations to get inferred somehow from foreign keys, creations relations in drizzle worked

2 replies

Gaming

Programming