CODEWITHSUNDEEP
scalaslick
osleonard
osleonard

Reputation: 595

Slick does not know how to map the given types

Below is my code

package com.codemobile.box.modules.groups.repo.sql
import com.codemobile.box.core.services.DatabaseService
import com.codemobile.box.modules.groups.model.GroupEntity
trait GroupEntityTable {
  protected val databaseService: DatabaseService
  import databaseService.driver.api._
  class Groups(tag: Tag) extends Table[GroupEntity](tag, "groups"){
    val id = column[Int]("grp_id",O.PrimaryKey,O.AutoInc)
    val name = column[String]("grp_name")
    val permissions = column[String]("grp_permissions")
    def * = (id, name, permissions) <> (GroupEntity.tupled, GroupEntity.unapply)
  }

  protected val groupsTableQuery = TableQuery[Groups]

}


package com.codemobile.box.modules.groups.model
case class GroupEntity(id: Option[Int] = None, name: String, permissions : Option[String] = None)

however when I run activator run I get below exception

[error] Slick does not know how to map the given types.
[error] Possible causes: T in Table[T] does not match your * projection. Or you use an unsupported type in a Query (e.g. scala List).
[error]   Required level: slick.lifted.FlatShapeLevel
[error]      Source type: (slick.lifted.Rep[String], slick.lifted.Rep[String], slick.lifted.Rep[Option[Int]])
[error]    Unpacked type: (Option[Int], String, Option[String])
[error]      Packed type: Any
[error]     def * = (name, permissions, id.?) <> (GroupEntity.tupled, GroupEntity.unapply)
[error]                                       ^
[error] one error found

Upvotes: 0

Views: 1476

Answers (1)

Paul Dolega
Paul Dolega

Reputation: 2476

Just add Option to your types in mappings:

  class Groups(tag: Tag) extends Table[GroupEntity](tag, "groups"){
    val id = column[Option[Int]]("grp_id",O.PrimaryKey,O.AutoInc)
    val name = column[String]("grp_name")
    val permissions = column[Option[String]]("grp_permissions")
    def * = (id, name, permissions) <> (GroupEntity.tupled, GroupEntity.unapply)
  }

(notice how I changed column for id and permissions)

Alternatively you may do this:

  class Groups(tag: Tag) extends Table[GroupEntity](tag, "groups"){
    val id = column[Int]("grp_id",O.PrimaryKey,O.AutoInc)
    val name = column[String]("grp_name")
    val permissions = column[String]("grp_permissions")
    def * = (id.?, name, permissions.?) <> (GroupEntity.tupled, GroupEntity.unapply)
  }

(notice how I changed * projection and added ? after id and permissions)

Upvotes: 5

Related Questions