Query increment db field value with transaction

Questions and Answers
5

You can do increment and decrement on strapi database fields like this:

const req = strapi.db.connection('tickets')
.where({id: 123})
.increment('quantity_available', 1)
.decrement('quantity_sold', 1)

Inside a transaction:

const req = strapi.db.connection('tickets')
.where({id: 123})
.increment('quantity_available', 1)
.decrement('quantity_sold', 1)
.transacting(trx)