DT
Drizzle Team•3mo ago
Ali

Depreciated table

Hi everyone, pgTable is marked here as depreciated but I can't understand why : 
export const clinicsSessions = pgTable(
  'clinicsSessions',
  {
    id: text('id')
      .primaryKey()
      .$defaultFn(() => crypto.randomUUID()),
    year: integer('year').notNull(),
    month: integer('month').notNull(),
  },
  (t) => ({
    unq: unique().on(t.year, t.month),
  })
);
export const clinicsSessions = pgTable(
  'clinicsSessions',
  {
    id: text('id')
      .primaryKey()
      .$defaultFn(() => crypto.randomUUID()),
    year: integer('year').notNull(),
    month: integer('month').notNull(),
  },
  (t) => ({
    unq: unique().on(t.year, t.month),
  })
);
7 Replies
Ali
AliOP•3mo ago
the issue seems to be probably related to 
  (t) => ({
    unq: unique().on(t.year, t.month),
  })
  (t) => ({
    unq: unique().on(t.year, t.month),
  })
because deleting it removes the depreciation warning
oke
oke•3mo ago
Do you have the full error message?
Ali
AliOP•3mo ago
const createTable: PgTableFn <"clinicsSessions", { id: IsPrimaryKey<NotNull<PgUUIDBuilderInitial<"">>>; year: NotNull<PgIntegerBuilderInitial<"">>; month: NotNull<...>; }>(name: "clinicsSessions", columns: { ...; }, extraConfig: (self: { ...; }) => PgTableExtraConfig) => PgTableWithColumns<...> (+3 overloads) @deprecated — This overload is deprecated. Use the other method overload instead.
Darren
Darren•3mo ago
New version uses an array now, see docs
Ali
AliOP•3mo ago
https://orm.drizzle.team/docs/indexes-constraints
Drizzle ORM - Indexes & Constraints
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Ali
AliOP•3mo ago
it doesn't not use arrays here for example 
import { integer, text, unique, pgTable } from "drizzle-orm/pg-core";
export const user = pgTable('user', {
  id: integer('id').unique(),
});
export const table = pgTable('table', {
  id: integer('id').unique('custom_name'),
});
export const composite = pgTable('composite_example', {
  id: integer('id'),
  name: text('name'),
}, (t) => ({
  unq: unique().on(t.id, t.name),
  unq2: unique('custom_name').on(t.id, t.name)
}));
// In Postgres 15.0+ NULLS NOT DISTINCT is available
// This example demonstrates both available usages
export const userNulls = pgTable('user_nulls_example', {
  id: integer('id').unique("custom_name", { nulls: 'not distinct' }),
}, (t) => ({
  unq: unique().on(t.id).nullsNotDistinct()
}));
import { integer, text, unique, pgTable } from "drizzle-orm/pg-core";
export const user = pgTable('user', {
  id: integer('id').unique(),
});
export const table = pgTable('table', {
  id: integer('id').unique('custom_name'),
});
export const composite = pgTable('composite_example', {
  id: integer('id'),
  name: text('name'),
}, (t) => ({
  unq: unique().on(t.id, t.name),
  unq2: unique('custom_name').on(t.id, t.name)
}));
// In Postgres 15.0+ NULLS NOT DISTINCT is available
// This example demonstrates both available usages
export const userNulls = pgTable('user_nulls_example', {
  id: integer('id').unique("custom_name", { nulls: 'not distinct' }),
}, (t) => ({
  unq: unique().on(t.id).nullsNotDistinct()
}));
Darren
Darren•3mo ago
https://github.com/drizzle-team/drizzle-orm/releases/tag/0.36.0
GitHub
Release 0.36.0 · drizzle-team/drizzle-orm
This version of drizzle-orm requires [email protected] to enable all new features New Features The third parameter in Drizzle ORM becomes an array The object API is still available but deprecate...

Did you find this page helpful?