UUID encoder in quill-async not compatible with mysql

[zifeo]

Version: 0.10.1-SNAPSHOT
Module: quill-async-mysql
Database: mariadb
#585 follow up.

Expected behavior

Everything encode/decode without the need of defining encoder/decoder.

Actual behavior

io.netty.handler.codec.EncoderException: scala.MatchError: 9cad8ea5-41f5-4ffb-a35d-ecdba68c2eed (of class java.util.UUID) at runtime.

Steps to reproduce the behavior

val db = new MysqlAsyncContext[SnakeCase]("mysql")
import db._

// This works
//implicit val decoderUUID = MappedEncoding[String, AddressId](x => AddressId(UUID.fromString(x)))
//implicit val encoderUUID = MappedEncoding[AddressId, String](_.value.toString)

// This does not work
implicit val decoderUUID = MappedEncoding[String, UUID](UUID.fromString)
implicit val encoderUUID = MappedEncoding[UUID, String](_.toString)

case class AddressId(value: UUID) extends AnyVal
case class Address(id: AddressId)

val addr = AddressId(UUID.randomUUID())
val res = run {
  query[Address].filter(_.id == lift(addr))
}
Await.result(res, Duration.Inf)

Workaround

@getquill/maintainers

[zifeo]

Note that the workaround is not working anymore in 1.0.1. The async SQL context needs to redefine the encoder/decoder pair depending on your underlying MYSQL type in order to work:

  override implicit val uuidDecoder: Decoder[UUID] =
    AsyncDecoder(SqlTypes.CHAR)(new BaseDecoder[UUID] {
      def apply(index: Index, row: ResultRow): UUID = row(index) match {
        case value: String => UUID.fromString(value)
      }
    })

  override implicit val uuidEncoder: Encoder[UUID] =
    AsyncEncoder[UUID](SqlTypes.CHAR)(new BaseEncoder[UUID] {
      def apply(index: Index, value: UUID, row: PrepareRow): PrepareRow =
        row :+ value.toString
    })