enum value slick table

[Diogo Longo]

Hi,

I have the follow enum:

object LoginStatus extends Enumeration() with BitmaskedEnumeration {

  type LoginStatus = Value

  val Active = Value("A")

  val Inactive = Value("I")

}

I need to persist the value of the enum "A", but when the sql is generated the result is 0.

this is the table mapping:

object LoginTable extends Table[Login]("login") {

  def idLogin = column[Int]("idlogin", O.PrimaryKey, O.AutoInc)

  def cdLogin = column[String]("cdlogin", O.NotNull)

  def cdPass = column[String]("cdPass", O.NotNull)

  def stLogin = column[LoginStatus]("stlogin", O.NotNull, O.DBType("character(1)"))

}

how to persiste the enum value?

[Ricardo Franco]

I use this.

def enum2StringMapper(enum: Enumeration) = MappedTypeMapper.base[enum.Value, String](

    b => b.toString,

    i => enum.withName(i)

  )

def enum2IntTypeMapper(enum: Enumeration) = MappedTypeMapper.base[enum.Value, Int](

    b => b.id,

    i => enum.apply(i)

  )

def enum2BitmaskedMapper(enum:Enumeration) = MappedTypeMapper.base[Set[enum.Value], Long](

      b => b.foldLeft(0L)((bm, v) => bm + (1L << v.id)),

      i => StatusType.values.filter(v => 0 != (i & (1 << v.id)))

  )

How to use:

implicit val LoginStatusMapper = enum2StringMapper(LoginStatus)

--
 
---
You received this message because you are subscribed to the Google Groups "Slick / ScalaQuery" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scalaquery+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Diogo Longo]

Hi Ricardo,

I didn't found the import for type StatusType.

I have to change something in the code?

[Ricardo Franco]

Oh Sorry i copy from my code

This is generic way.

def enum2BitmaskedMapper(enum:Enumeration) = MappedTypeMapper.base[Set[enum.Value], Long](

      b => b.foldLeft(0L)((bm, v) => bm + (1L << v.id)),

      i => enum.values.filter(v => 0 != (i & (1 << v.id)))

  )

[Diogo Longo]

Tks Ricardo,

I changed the code, but slick still complain about the invalid value:

select x2."idlogin", x2."cdlogin", x2."cdpass", x2."stlogin" from "login" x2 where (x2."cdlogin" = ?) and (x2."stlogin" = ?)

ERROR: operator does not exist: character = integer

[Diogo Longo]

I implemented

implicit val charMapper = MappedTypeMapper.base[Char, String](
    b => b.toString(),
    i => i.charAt(0))

  implicit def enum2StringMapper(enum: Enumeration) = MappedTypeMapper.base[enum.Value, Char](
    b => b.toString.charAt(0),
    i => enum.withName(i.toString))

  implicit val LoginStatusMapper = enum2StringMapper(LoginStatus)

but result in:

[error] c.Login - Invalid value for type int : A

[Ricardo Franco]

It should work for you.

object LoginStatus extends Enumeration {

      type LoginStatus = Value

      val Active = Value("A")

      val Inactive = Value("I")

    }

    def enum2String(enum: Enumeration) = MappedTypeMapper.base[enum.Value, String](

      b => b.toString,

      i => enum.withName(i)

    )

    implicit val LoginStatusMapper = enum2String(LoginStatus)

[Diogo Longo]

Tks Ricardo, its works!

I have to move the code from the dao to enum class:

object LoginStatus extends Enumeration {

  def enum2StringMapper(enum: Enumeration) = MappedTypeMapper.base[enum.Value, String](
    b => b.toString,
    i => enum.withName(i))

implicit val LoginStatusMapper = enum2StringMapper(LoginStatus)

[Christopher Vogt]

PLEASE cross-link between Stackoverflow and Mailing List posts if you
post on both platforms.

Here is the link
http://stackoverflow.com/questions/19273805/how-to-persist-enum-value-in-slick