Slick: Return inserted row with auto increment id

Question

I'm trying to make an insert into a MySQL table and to return the row with the auto increment id. My code is below:

private val Log = TableQuery[GCMLogTable]

def save(log: GCMLog): Try[GCMLog] = Try {
    val newId = (Log returning Log.map(_.id)) += log
    log.copy(id = newId)
}

But my compilation fails for my code with the below error:

type mismatch;
    found   : slick.profile.FixedSqlAction[Long,slick.dbio.NoStream,slick.dbio.Effect.Write]
    required: Long

Also tried

def save(log: GCMLog): Try[GCMLog] = Try {
    (Log returning Log.map(_.id)
      into ((log, newId) => log.copy(id = newId))
      ) += log
}

But still fails with

type mismatch;
found   : slick.profile.FixedSqlAction[models.GCMLog,slick.dbio.NoStream,slick.dbio.Effect.Write]
required: models.GCMLog

[I referred the SO question How to catch slick postgres exceptions for duplicate key value violations and Slick documentation here http://slick.typesafe.com/doc/3.1.1/queries.html ]

Much appreciated if someone can tell me what's going on and how this can be fixed.

Thanks!

I think your problem (type mismatch) is because you're not actually running your query ```db.run(...)```. — Mirko Stocker, Apr 07 '16 at 09:36
@MirkoStocker db.run works (with a different syntax), but is there a way to return the inserted row if I use db.run? — shyam, Apr 11 '16 at 05:52
So what does your code currently return when you do a db.run? — Mirko Stocker, Apr 11 '16 at 13:59
@MirkoStocker I just got it to work. I rewrote it and now it's working with db.run. Not even sure what I've been doing wrong. Thanks! — shyam, Apr 12 '16 at 04:56

TheKojuEffect · Accepted Answer · 2016-04-07T06:08:05.860

4

 def save(log: GCMLog): Try[GCMLog] = Try {
    (Log returning Log.map(_.id))
       into ((log, newId) => log.copy(id = newId))
        ) += log
  }

UPDATE:

It looks db.run needs to be perform to convert that Action into result.

edited Apr 07 '16 at 06:08

answered Apr 07 '16 at 05:54

TheKojuEffect

20,103
19
89
125

It doesn't work either. I've edited my question with the error. – shyam Apr 07 '16 at 06:05
@shyam It looks like `db.run` needs to be done to convert `Action` into result – TheKojuEffect Apr 07 '16 at 06:08
Trying different things, still can't get it to work. :( – shyam Apr 07 '16 at 06:18

score 2 · Answer 2 · answered Apr 07 '16 at 09:24

2

slick supports it:

def create(objectToCreate: MyCaseClass): MyCaseClass = {
    db.withSession {
      (self returning self) += objectToCreate
    }
  }

answered Apr 07 '16 at 09:24

pedrorijo91

7,635
9
44
82

score 1 · Answer 3 · answered Apr 11 '16 at 11:39

Try this

private val Log = TableQuery[GCMLogTable]
private val db = Database.forConfig("mysql")

def save(log: GCMLog): Try[GCMLog] = Try {
    val newId = db.run((Log returning Log.map(_.id) into ((Log,id) => Log.copy(id=id))) += log)
    Await.result(newId, Duration.Inf)
}

Slick: Return inserted row with auto increment id

3 Answers3