Lucid: Truncate within transaction

[rbartholomay]

Ho can use truncate within transaction?

I can´t set the ModelAdapterOptions when calling truncate() and everytime i get a pool error:

Knex: Timeout acquiring
a connection. The pool is probably full. Are you missing a .transacting(trx) call?

        await Database.transaction(async (trx) => {
          await MyLucidModel.truncate()  // <-- can´t set  { client: trx } as an option here
          await MyLucidModel.createMany(data, { client: trx })
        })

Bye, René

[thetutlage]

Use this

await Database.transaction(async (trx) => {
  await trx.truncate(MyLucidModel.table)
  await MyLucidModel.createMany(data, { client: trx })
})

[rbartholomay]

Wow! So easy... Thanks!