Loop of transactions or transactions + promise pool

[jackHedaya]

Introduction

I'm trying to bulk insert to my database that's more complex than a standard query but am having issues with looping through transactions.

Attached SO here

Issue Description

I'm currently looping through all the records I want to insert and generating a transaction for each one. My code looks something like this. The records length is around 30k.

const promises = []

for (const r of json) {
    const p = bookshelf
      .transaction(async (t) => {
        if (r.error && !r.name) throw r.error
        if (r.warning) throw r.warning
       
       <transaction logic that includes fetches and saves>

        customLogger.info(`Saved ${r.name}`)
      })
      .catch((x) => {
        customLogger.error(x)
        throw x
      })

    promises.push(p)
}

Expected behaviour

All the records to save properly and the database pool to properly utilized.

Actual behaviour

The script hangs and I believe throws an error asking if I used transacting right.