Search code examples
scalaslick

How to map in Slick MySQL TINYINT(1) column?

Is it ok to map MySQL column of type TINYINT(1) as

def deleted = column[Boolean]("deleted")

in Slick?

When I map the column this way then it is not working as I would expect in filters like one below:

def cleanUpDeletedSegments(implicit db:ADMPDB)={
    db.run{
      segments.filter(_.deleted === true).delete
    }

}

Solution

  • From what I've tried I can conclude that TINYINT(1) will not map to Boolean.

    I have changed mapping to def deleted = column[Int]("deleted") and filtering just by ===1 or ===0.