ScalikeJdbc Multiple Insert

Question

How do we perform multiple inserts in the same transaction?

  def insertData(dataList: List[Data])(implicit session: DBSession = autoSession) = {

    // todo: this is probably opening and closing a connection every time?
    dataList.foreach(data => insertData(data))
  }

  def insertData(data: Data) = withSQL {
    val t = DataTable.column
    insert.into(DataTable).namedValues(
      d.name -> data.name,
      d.title -> data.title
    )
  }.update().apply()

It would not be efficient to have a different transaction for every insert if these numbered in the thousands and up.

http://scalikejdbc.org/documentation/operations.html

score 3 · Accepted Answer · edited Aug 20 '15 at 15:43

3

Modify your insertData method like this:

def insertData(data: Data)(implicit session: DBSession = AutoSession) = withSQL {
  val t = DataTable.column
  insert.into(DataTable).namedValues(
    d.name -> data.name,
    d.title -> data.title
  )
}.update().apply()

And then, use DB.localTx:

DB.localTx { implicit s =>
  dataList.foreach(data => insertData(data))
}

edited Aug 20 '15 at 15:43

BAR

15,909
27
97
185

answered Jul 27 '15 at 08:20

Kazuhiro Sera

1,822
12
15

So this would perform a single transaction as opposed to mine that would create one for each insert? – BAR Jul 27 '15 at 18:50
1

Yes, accepting DBSession as an implicit parameter enables the operations to join the same transaction. – Kazuhiro Sera Aug 13 '15 at 01:16
Is the `DB.localTx` block necessary? – BAR Aug 20 '15 at 15:44
Yes, it is if you need to run the operations within a same transaction. – Kazuhiro Sera Aug 20 '15 at 16:30
5

Wouldn't this perform insert `dataList.length()` times? – Kakaji Jul 04 '17 at 06:27
1

@KazuhiroSera I'd really appreciate an answer for @kakaji question - Wouldn't this perform insert `dataList.length()` times? – Hagai Jul 09 '19 at 07:07

ScalikeJdbc Multiple Insert

1 Answers1