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.$inferSelectexport 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.$inferSelectyou can see createdAt has default
