Compile-time Language Integrated Query for Scala - Deprecated Please move to zio-quill in https://discord.gg/MYErPQgkHH
deusaquilus on update-multi-value
fix up contexts (compare)
deusaquilus on update-multi-value
fix (compare)
deusaquilus on update-multi-value
fix (compare)
deusaquilus on update-multi-value
add mixed-case tests (compare)
deusaquilus on update-multi-value
experimenting testing 2 fix continue and 2 more (compare)
deusaquilus on update-multi-value
continue effort (compare)
deusaquilus on update-multi-value
odd situations continue thoughts try to differentiate lifts with… (compare)
case class Unnest(unnest: String)
val strings = quote {
querySchema[Unnest]("now()")
.map(t => infix"UNNEST(${lift(Seq("foo","bar"))})".pure.as[String])
}
run {
query[ResultName]
.rightJoin(infix"${strings}".pure.as[Query[Unnest]])
.on(_.text == _.unnest)
.map{case (rnOpt, n) => rnOpt.map(_.id)}
}
case class Unnest(unnest: String)
val strings = quote {
querySchema[Unnest]("now()")
.map(t => Unnest(infix"UNNEST(${lift(Seq("foo","bar"))})".as[String])).nested
}
run {
query[ResultName]
.rightJoin(strings)
.on(_.text == _.unnest)
.map{case (rnOpt, n) => rnOpt.map(_.id)}
}
SELECT x1.id FROM ResultName x1 RIGHT JOIN (SELECT UNNEST(?) AS unnest FROM now() t) AS x2 ON x1.text = x2.unnest
as unnest
part
now()
is just a function in postgres that returns the time
@ case class Unnest(unnest: String)
@ val strings = quote {
infix"UNNEST(${lift(Seq("foo","bar"))})".as[Query[Unnest]].nested
}
@ run {
query[ResultName]
.rightJoin(strings)
.on(_.text == _.unnest)
.map{case (rnOpt, n) => rnOpt.map(_.id)}
}
cmd67.sc:1: SELECT x1.id FROM ResultName x1 RIGHT JOIN (SELECT x.unnest FROM (UNNEST(?)) AS x) AS x2 ON x1.text = x2.unnest
@ case class Unnest(unnest: String)
@ val strings = quote {
infix"SELECT UNNEST(${lift(Seq("foo","bar"))})".as[Query[Unnest]].nested
}
@ run {
query[ResultName]
.rightJoin(strings)
.on(_.text == _.unnest)
.map{case (rnOpt, n) => rnOpt.map(_.id)}
}
SELECT x1.id FROM ResultName x1 RIGHT JOIN (SELECT x.unnest FROM (SELECT UNNEST(?)) AS x) AS x2 ON x1.text = x2.unnest
.nested
thing do?
@ ctx.run {
query[db.ResultName]
.rightJoin(infix"SELECT UNNEST(${lift(Seq("foo","test-shard-local-database"))})".as[io.getquill.Query[Unnest]])
.on(_.text == _.unnest)
.map{case (rnOpt, n) => rnOpt.map(_.id)}
}
cmd12.sc:1: SELECT x1.id FROM result_name x1 RIGHT JOIN (SELECT UNNEST(?)) AS x2 ON x1.text = x2.unnest
val res12 = ctx.run {
^
res12: List[Option[Long]] = List(None, Some(2674443566L))