Drizzle updatedAt on SQLite

[ghost]

Hello, I am fairly new to SQL and Drizzle. I was wondering if the following code will update my updatedAt table upon an update. If so, is there a better solution than this, or is this already correct?

export const products = sqliteTable('products', {
  ...other tables
  updatedAt: text('updated_at').$onUpdate(() => sql`CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP`),
});

[buldezir]

almost same, but

updatedAt: text("updated_at")
     .notNull()
     .default(sql`(CURRENT_TIMESTAMP)`)
     .$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),

[intellimat]

@buldezir I'm getting a similar error when I write .$onUpdateOn in a schema. I'm using Expo SQLite with Drizzle, and this is the error:

[Error: FunctionCallException: Calling the 'prepareSync' function has failed (at ExpoModulesCore/SyncFunctionDefinition.swift:137) → Caused by: SQLiteErrorException: Error code 1: no such function: NOW (at ExpoSQLite/SQLiteModule.swift:284)]

My code:

export const travelsTable = sqliteTable(
  "travels_table",
  {
    id: int().primaryKey({ autoIncrement: true }),
    name: text().notNull().unique(),
    createdAt: text().default(sql`(CURRENT_TIMESTAMP)`),
    updatedAt: text()
      .notNull()
      .default(sql`(CURRENT_TIMESTAMP)`)
      .$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),
  },
  () => []
);

Any idea why is this happening and how can I solve it?

Thank you

[intellimat]

@buldezir I'm getting a similar error when I write .$onUpdateOn in a schema. I'm using Expo SQLite with Drizzle, and this is the error:

[Error: FunctionCallException: Calling the 'prepareSync' function has failed (at ExpoModulesCore/SyncFunctionDefinition.swift:137) → Caused by: SQLiteErrorException: Error code 1: no such function: NOW (at ExpoSQLite/SQLiteModule.swift:284)]

My code:

export const travelsTable = sqliteTable(
  "travels_table",
  {
    id: int().primaryKey({ autoIncrement: true }),
    name: text().notNull().unique(),
    createdAt: text().default(sql`(CURRENT_TIMESTAMP)`),
    updatedAt: text()
      .notNull()
      .default(sql`(CURRENT_TIMESTAMP)`)
      .$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),
  },
  () => []
);

Any idea why is this happening and how can I solve it?

Thank you

SOLVED

I was setting "updatedAt" property when editing data:

drizzleDB
      .update(travelsTable)
      .set({ ...values, updatedAt: sql`NOW()` })    <------- here was the problem
      .where(eq(travelsTable.id, travelId));