Scala anorm retrieve inserted id

anorm, mysql, playframework-2.0, scala, typesafe-stack

Solution

In the latest version you need a scalar:

   val newId = SQL(
      """
      insert into accom (places,lat,lon,permaname,country,defaultLanguage) 
      values ({places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage})
      """).on(
        'places -> places,
        'lat -> lat,
        'lon -> lon,
        'permaname -> permaname,
        'country -> country,
        'defaultLanguage -> defaultLanguage).executeInsert(scalar[Long].single)

Problem

I have a table with autoid for the id field. After inserting a row with anorm I'd like to retrieve the generated id. Any idea? ``` SQL( """ insert into accom (id,places,lat,lon,permaname,country,defaultLanguage) values ( {places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage} ) """).on( 'id -> id, 'places -> places, 'lat -> lat, 'lon -> lon, 'permaname -> permaname, 'country -> country, 'defaultLanguage -> defaultLanguage).executeUpdate() } ```

Original source

Related problems