Is there any bulkUpdate (similar to bulkDelete_!!) in Mapper?

Question

Is there a bulkUpdate method similar to bulkDelete_!! in mapper so that i can update records in underlying table ?

vkantiya · Accepted Answer · 2011-11-09T04:44:03.540

As per my knowledge , Unfortunately in order to perform bulk update ( based on some criteria ) we have to use sql query only. No method similar to bulkDelete_!! available for bulk Update.

For example:

def updateNameById (newName : String,  id : Long) = {  
    val updateString = "update MyModel set name = ? where id = ?"    
    DB.use(DefaultConnectionIdentifier) { conn =>
        DB.prepareStatement(updateString, conn) { stmt =>
              stmt.setString(1, newName)
              stmt.setLong(2, id)
              stmt.executeUpdate()
        }
    }
}

score 1 · Answer 2 · answered Nov 08 '11 at 17:25

1

No, there is no bulkUpdate in Mapper, you would have to do a findAll, edit the records and then do a .save on them.

answered Nov 08 '11 at 17:25

fmpwizard

2,758
1
22
24

but that will be querying the database twice, won't it ? ( Once for findAll and onceagain for save ) – vkantiya Nov 09 '11 at 04:45
That is correct. To avoid that you would have to use a custom sql, like @vkantiya wrote – fmpwizard Nov 09 '11 at 17:56

Is there any bulkUpdate (similar to bulkDelete_!!) in Mapper?

2 Answers2