String and UUID comparisons should work

[dispalt]

Version: 0.4.1
Module: quill-core

Expected behavior

Quill should support comparisons on two different scenarios. Basic string comparisons in the filter clause.

quote {
 (s:String) => q.filter(_.id > s)
}

And comparisons with UUID which doesn't by default support <, >, etc.

Actual behavior

String comparisons fail with being unable to parse the ast of the string comparisons. With UUID's there's no way to express the comparison.

Maybe you could add a special typeclass and parse that out for things that don't natively implement Ordering?

@getquill/maintainers

[dispalt]

This is my workaround for UUID's,

  implicit class UUIDCompare(left: UUID) {
    def <(right: UUID) = quote(infix"$left < $right".as[Boolean])
    def >(right: UUID) = quote(infix"$left > $right".as[Boolean])
    def <=(right: UUID) = quote(infix"$left <= $right".as[Boolean])
    def >=(right: UUID) = quote(infix"$left >= $right".as[Boolean])
  }

[emanresusername]

👍 similarly for various Date/DateTime etc types

with this particular method with java.util.Date
with something like

db.run(quote{
query[Model].filter(_.expiresAt > lift(new Date()))
})

i get

[info]   java.util.NoSuchElementException: key not found: new java.util.Date()
[info]   at scala.collection.MapLike$class.default(MapLike.scala:228)
[info]   at scala.collection.AbstractMap.default(Map.scala:59)
[info]   at scala.collection.MapLike$class.apply(MapLike.scala:141)
[info]   at scala.collection.AbstractMap.apply(Map.scala:59)

[mxl]

Closed in favor of #677