helper class for execution "upsert" (update or insert) query using Skinny-ORM.

sample.scala

import scalikejdbc._
import Implicits._

val column = daos.User.column

def upsertUser(entity: User) = {
  daos.User.upsert(
    sqls.eq(column.id, entity.id)
  )(update =
    column.name -> entity.name,
    column.updatedAt -> java.time.LocalDateTime.now()
  )(insert =
    column.id -> entity.id,
    column.name -> entity.name,
    column.createdAt -> entity.createdAt,
    column.updatedAt -> java.time.LocalDateTime.now()
  )
}

SkinnyORMUpsert.scala

import skinny.orm.feature.NoIdCUDFeature

object Implicits {
  implicit class Upserter[T](val orm: NoIdCUDFeature[T]) extends AnyVal {
    def upsert(condition: SQLSyntax)(update: (SQLSyntax, Any)*)(insert: (SQLSyntax, Any)*)(implicit s: DBSession): Unit = {
      orm.updateBy(condition).withNamedValues(update: _*) match {
        case 1 => ()
        case 0 =>
          orm.createWithNamedValues(insert: _*)
          ()
      }
    }
  }
}