Drizzle Team•15mo ago

inferSelect doesnt take into account defaults in schema

export const event = sqliteTable('event', {
  id: integer('id').primaryKey({ autoIncrement: true }),
  name: text('name').notNull(),
  startTime: integer('start_time', { mode: 'timestamp' }).notNull(),
  endTime: integer('end_time', { mode: 'timestamp' }).notNull(),
  createdAt: integer('created_at', { mode: 'timestamp_ms' })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  updatedAt: integer('updated_at', { mode: 'timestamp_ms' })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  deletedAt: integer('deleted_at', { mode: 'timestamp_ms' }),
  is_recurring: integer('is_recurring', { mode: 'boolean' }),
});
export type Event = typeof event.$inferSelect

export const event = sqliteTable('event', {
  id: integer('id').primaryKey({ autoIncrement: true }),
  name: text('name').notNull(),
  startTime: integer('start_time', { mode: 'timestamp' }).notNull(),
  endTime: integer('end_time', { mode: 'timestamp' }).notNull(),
  createdAt: integer('created_at', { mode: 'timestamp_ms' })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  updatedAt: integer('updated_at', { mode: 'timestamp_ms' })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP`),
  deletedAt: integer('deleted_at', { mode: 'timestamp_ms' }),
  is_recurring: integer('is_recurring', { mode: 'boolean' }),
});
export type Event = typeof event.$inferSelect

you can see createdAt has default

12 Replies

Angelelz•15mo ago

Which one of the columns you think has a problem?

BraveheartOP•15mo ago

updatedAt: integer('updated_at', { mode: 'timestamp_ms' }) .notNull() .default(sqlCURRENT_TIMESTAMP), should be optional type

Angelelz•15mo ago

You are probably looking for $inferInsert, that will give you the type for insert, where all columns that have default are optional

BraveheartOP•15mo ago

ah ok thx

BraveheartOP•15mo ago

its happy

Ravi kiran•14mo ago

hey guys im trying to insert start_dtime and end_dtime fields as integers. im trying the attached code. but i run into this error. Types of property 'start_dtime' are incompatible. Type 'number' is not assignable to type 'SQL<unknown> | Placeholder<string, any> | Date | null | undefined'. i have attached both my schema and the code. can someone help me with this.

Angelelz•14mo ago

When you use { mode: 'timestamp_ms' }, that column now accepts a Date object, and drizzle will run .getTime() for you

Ravi kiran•14mo ago

but it is an integer field right? how can i modify my code? any suggestions?

Angelelz•14mo ago

Just remove .getTime() from start_date and end_date

Ravi kiran•14mo ago

ok ill try and get back

Angelelz•14mo ago

Just let it be a Date object

Ravi kiran•14mo ago

yes it works. thank you.

Gaming

Programming

inferSelect doesnt take into account defaults in schema

Did you find this page helpful?