aboutsummaryrefslogblamecommitdiffhomepage
path: root/server/models/shared/update.ts
blob: d02c4535dc5ec02783d6bdd2891c3f01df23a30c (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
                                                              

                                                                     








                                                       











                                                                    
import { QueryTypes, Sequelize, Transaction } from 'sequelize'

// Sequelize always skip the update if we only update updatedAt field
function setAsUpdated (options: {
  sequelize: Sequelize
  table: string
  id: number
  transaction?: Transaction
}) {
  const { sequelize, table, id, transaction } = options

  return sequelize.query(
    `UPDATE "${table}" SET "updatedAt" = :updatedAt WHERE id = :id`,
    {
      replacements: { table, id, updatedAt: new Date() },
      type: QueryTypes.UPDATE,
      transaction
    }
  )
}

export {
  setAsUpdated
}