By Alvin Alexander. Last updated: July 16, 2018
Here’s an example of how to write a SQL UPDATE query with ScalikeJdbc:
def updateUrlClickGeoInfo(urlClickId: Long, gi: GeoInfo): Int = NamedDB('kbhr) localTx { implicit session => sql""" update url_clicks set city = ${gi.city}, state = ${gi.state}, country = ${gi.country} where id = ${urlClickId} """.update.apply() }
(As a note to self, this code comes from my PopulateKbhrGeo1 app.)
As I’ve written before, at some point I hope to take some time to write a ScalikeJdbc tutorial, but until then, I hope this is another helpful example.