How to do batch updates?

Question

I am trying to update a specific column on a list of rows in MySql using Exposed.

Actually Exposed supports a batchInsert, but there is nothing similar to a batchUpdate, is there any workaround for this?

NOTE: the table is not an IdTable.

nope, just kotlin with exposed – Julian Zelayeta Jun 25 '18 at 15:58 — Julian Zelayeta, Jun 25 '18 at 15:58

score 1 · Accepted Answer · answered Jun 25 '18 at 09:34

1

There are BatchUpdateStatement which works with IdTables.

val yourData = listOf<DataToUpdate>()
BatchUpdateStatement(FooTable).apply {
    yourData.forEach {
        addBatch(it.id)
        this[FooTable.name] = it.name
        this[FooTable.column] = it.field
    }
    execute(Transaction.current())
}

answered Jun 25 '18 at 09:34

Tapac

1,889
1
14
18

2

actually the table isn't an IdTable – Julian Zelayeta Jun 25 '18 at 13:43
Then it's impossible to make batch update because Exposed can't determine identity condition for each update. – Tapac Jun 26 '18 at 15:06
any idea how do we add the where condition to this – Vishal Akkalkote Oct 24 '22 at 15:23

How to do batch updates?

1 Answers1