Easiest Way To Map Optional Nested Case Class with Slick in Scala

Table of contents

Reading Time: 2 minutes

Few days ago, I had a scenario, in which I was supposed to map optional nested case class in slick using Scala.

case class Employee(emdId:String,name: String, record: Option[Record])
case class Record(subject: String, mark: Int)

I was trying to do this mapping the way, I have explained below.

class EmployeeSlickMapping(tag: Tag) extends Table[Employee](tag, "Employee") {
def emdId = column[String]("emdId")
def name = column[String]("name")
def subject = column[String]("subject", O.Nullable)
def mark = column[Int]("mark", O.Nullable)
def record = (subject, mark) <> (Record.tupled, Record.unapply)
def * = (emdId,name, address) <> (User.tupled, User.unapply)
}

But I was getting below compilation error.

Multiple markers at this line
- No matching Shape found. Slick does not know how to map the given types. Possible causes: T in Table[T] does not match your * projection. Or you use an unsupported
type in a Query (e.g. scala List). Required level: scala.slick.lifted.FlatShapeLevel Source type: (scala.slick.lifted.Column[String], scala.slick.lifted.Column[String],
scala.slick.lifted.MappedProjection[platform3.models.mail.Record,(String, Int)]) Unpacked type: (String, String, Option[platform3.models.mail.Record]) Packed type: Any
- not enough arguments for method <>: (implicit evidence$2: scala.reflect.ClassTag[platform3.models.mail.Employee], implicit shape: scala.slick.lifted.Shape[_ <:
scala.slick.lifted.FlatShapeLevel, (scala.slick.lifted.Column[String], scala.slick.lifted.Column[String], scala.slick.lifted.MappedProjection[platform3.models.mail.Record,
(String, Int)]), (String, String, Option[platform3.models.mail.Record]), _])scala.slick.lifted.MappedProjection[platform3.models.mail.Employee,(String, String,
Option[platform3.models.mail.Record])]. Unspecified value parameter shape.
- No matching Shape found. Slick does not know how to map the given types. Possible causes: T in Table[T] does not match your * projection. Or you use an unsupported
type in a Query (e.g. scala List). Required level: scala.slick.lifted.FlatShapeLevel Source type: (scala.slick.lifted.Column[String], scala.slick.lifted.Column[String],
scala.slick.lifted.MappedProjection[platform3.models.mail.Record,(String, Int)]) Unpacked type: (String, String, Option[platform3.models.mail.Record]) Packed type: Any
- Implicit conversions found: => anyToToShapedValue()
- not enough arguments for method <>: (implicit evidence$2: scala.reflect.ClassTag[platform3.models.mail.Employee], implicit shape: scala.slick.lifted.Shape[_ <:
scala.slick.lifted.FlatShapeLevel, (scala.slick.lifted.Column[String], scala.slick.lifted.Column[String], scala.slick.lifted.MappedProjection[platform3.models.mail.Record,
(String, Int)]), (String, String, Option[platform3.models.mail.Record]), _])scala.slick.lifted.MappedProjection[platform3.models.mail.Employee,(String, String,
Option[platform3.models.mail.Record])]. Unspecified value parameter shape.

After beating my head two days, I found a solution by adding custom mapping.

class EmployeeSlickMapping(tag: Tag) extends Table[Employee](tag, "Employee") {
def emdId = column[String]("emdId")
def name = column[String]("name")
def subject = column[String]("subject")
def mark = column[Int]("mark")
def record = (subject.?, mark.?).<>[Option[Record], (Option[String], Option[Int])](
{ mappedRecord =>
mappedRecord match {
case (Some(subject), Some(mark)) => Some(Record(subject, mark))
case _ => None
}
},
{ result =>
result match {
case rec: Option[Record] => Some(rec.map(_.subject), rec.map(_.mark))
}
})
def * = (emdId, name, record) <> (Employee.tupled, Employee.unapply)
}

It worked and now I am able to compile and run my code.