Need help with the 3rd param becoming an array

[JamesSingleton]

Hey everyone, I just noticed that returning an object for the 3rd param became deprecated and we should be using an array. However, I am not entirely sure how some of what I setup translates over.

export const positions = pgTable(
  'positions',
  {
    id: serial('id').primaryKey(),
    name: text('name').notNull(),
    abbreviation: varchar('abbreviation', { length: 10 }).notNull(),
  },
  (table) => ({
    nameIdx: uniqueIndex('name_idx').on(table.name),
    abbreviationIdx: uniqueIndex('abbreviation_idx').on(table.abbreviation),
  }),
)

export const weeklyFinalRankings = pgTable(
  'weekly_final_rankings',
  {
    id: serial('id').primaryKey(),
    division: varchar('division', { length: 10 }).notNull(),
    week: integer('week').notNull(),
    year: integer('year').notNull(),
    rankings: jsonb('rankings').notNull(),
  },
  (table) => ({
    isUniqueVote: unique().on(table.division, table.year, table.week),
  }),
)

export const seasonsTable = pgTable(
  'seasons',
  {
    id: serial('id').primaryKey(),
    year: integer('year').notNull(),
    start: timestamp('start').notNull(),
    end: timestamp('end').notNull(),
  },
  (table) => ({
    isUniqueSeason: unique().on(table.year),
  }),
)

export const weeksTable = pgTable(
  'weeks',
  {
    id: serial('id').primaryKey(),
    seasonId: integer('seasonId')
      .notNull()
      .references(() => seasonsTable.id),
    week: integer('week').notNull(),
    start: timestamp('start').notNull(),
    end: timestamp('end').notNull(),
  },
  (table) => ({
    isUniqueWeek: unique().on(table.seasonId, table.week),
  }),
)

Does all of that just become

export const positions = pgTable(
  'positions',
  {
    id: serial('id').primaryKey(),
    name: text('name').notNull(),
    abbreviation: varchar('abbreviation', { length: 10 }).notNull(),
  },
  (table) => [
    uniqueIndex('name_idx').on(table.name),
    uniqueIndex('abbreviation_idx').on(table.abbreviation),
  ],
)

export const weeklyFinalRankings = pgTable(
  'weekly_final_rankings',
  {
    id: serial('id').primaryKey(),
    division: varchar('division', { length: 10 }).notNull(),
    week: integer('week').notNull(),
    year: integer('year').notNull(),
    rankings: jsonb('rankings').notNull(),
  },
  (table) => [
    unique().on(table.division, table.year, table.week)
  ],
)

export const seasonsTable = pgTable(
  'seasons',
  {
    id: serial('id').primaryKey(),
    year: integer('year').notNull(),
    start: timestamp('start').notNull(),
    end: timestamp('end').notNull(),
  },
  (table) => [
    unique().on(table.year)
  ],
)

export const weeksTable = pgTable(
  'weeks',
  {
    id: serial('id').primaryKey(),
    seasonId: integer('seasonId')
      .notNull()
      .references(() => seasonsTable.id),
    week: integer('week').notNull(),
    start: timestamp('start').notNull(),
    end: timestamp('end').notNull(),
  },
  (table) => [
    unique().on(table.seasonId, table.week)
  ],
)

[nicholasdly]

That looks right. All you have to do is keep the values of the original object in an array, which is what you're doing.