Scala-Slick Array Column

Question

I'm using scala slick + slick-pg (v0.21.1) for my db integration with my play application. Following the documentation: https://github.com/tminglei/slick-pg/tree/v0.21.1 I set up MyPostgresProfile as shown in the documentation.

However, I still can't get a column of List[Int] to compile.

In my code I have something like:

import com.nbcuas.promo.common.db.PromoPostgresProfile.api._

class MyTable(tag: Tag) extends Table[MyObject](tag, "my_table") {
  def id: Rep[Int] = column[Int]("id")
  def numbers:Rep[List[Int]] = column[List[Int]]("id")
} 

and this fails with error: could not find implicit value for parameter tt: slick.ast.TypedType[List[Int]]

I tried looking into other objects to import from slick-pg to see if it'd work, but couldn't get anything to compile.

Answer 1

So, the code I was working on was legacy code.

For some reason my code had: override val api: API = new API with ArrayImplicits with ...

instead of following the convention of:

override val api: API = MyAPI
object MyAPI extends API with ArrayImplicits with ... 

In the comments, I noted that I still had issues. I was missing the explicit type declaration of api: API. This is really important, and without it created a lot of runtime exceptions.