6 replies

Check for empty string in postgres

Hi. First post.

Started looking into migrating our project to drizzle today and am loving it so far.

I want to add a not-empty check and from what I gathered from the docs and this example https://github.com/drizzle-team/drizzle-orm/blob/b003e523c637c81e2c522003db03d3d9bd98b723/drizzle-orm/type-tests/pg/tables.ts#L76 (which is the only one I could find) this code should work:

import { boolean, check, pgTable, uniqueIndex, varchar } from 'drizzle-orm/pg-core'
import { uuidPk } from './helpers'
import { sql } from 'drizzle-orm'

export const users = pgTable(
  'auth_user',
  {
    id: uuidPk,
    name: varchar('name').notNull(),
    password: varchar('password').notNull(),
    isAdmin: boolean('is_admin').notNull().default(false),
  },
  (users) => ({
    nameIdx: uniqueIndex('auth_user_name_idx').on(users.name),
    notEmptyName: check('notEmptyName', sql`${users.name} <> ''`),
  })
)

import { boolean, check, pgTable, uniqueIndex, varchar } from 'drizzle-orm/pg-core'
import { uuidPk } from './helpers'
import { sql } from 'drizzle-orm'

export const users = pgTable(
  'auth_user',
  {
    id: uuidPk,
    name: varchar('name').notNull(),
    password: varchar('password').notNull(),
    isAdmin: boolean('is_admin').notNull().default(false),
  },
  (users) => ({
    nameIdx: uniqueIndex('auth_user_name_idx').on(users.name),
    notEmptyName: check('notEmptyName', sql`${users.name} <> ''`),
  })
)

But it doesn't :/ the index works, but the check does not. There is no SQL generated for the migration but to be sure I also tested it in runtime after migrating but no luck. Any advice?

Drizzle Team•3y ago•

6 replies

Martnart

Check for empty string in postgres

Hi. First post.

import { boolean, check, pgTable, uniqueIndex, varchar } from 'drizzle-orm/pg-core'
import { uuidPk } from './helpers'
import { sql } from 'drizzle-orm'

export const users = pgTable(
  'auth_user',
  {
    id: uuidPk,
    name: varchar('name').notNull(),
    password: varchar('password').notNull(),
    isAdmin: boolean('is_admin').notNull().default(false),
  },
  (users) => ({
    nameIdx: uniqueIndex('auth_user_name_idx').on(users.name),
    notEmptyName: check('notEmptyName', sql`${users.name} <> ''`),
  })
)

import { boolean, check, pgTable, uniqueIndex, varchar } from 'drizzle-orm/pg-core'
import { uuidPk } from './helpers'
import { sql } from 'drizzle-orm'

export const users = pgTable(
  'auth_user',
  {
    id: uuidPk,
    name: varchar('name').notNull(),
    password: varchar('password').notNull(),
    isAdmin: boolean('is_admin').notNull().default(false),
  },
  (users) => ({
    nameIdx: uniqueIndex('auth_user_name_idx').on(users.name),
    notEmptyName: check('notEmptyName', sql`${users.name} <> ''`),
  })
)

But it doesn't :/ the index works, but the check does not. There is no SQL generated for the migration but to be sure I also tested it in runtime after migrating but no luck. Any advice?

Check for empty string in postgres

Similar Threads

Check for empty string in postgres

Similar Threads

Similar Threads

Similar Threads