-
Notifications
You must be signed in to change notification settings - Fork 3
/
DoobieIntegraion.scala
64 lines (55 loc) · 2.1 KB
/
DoobieIntegraion.scala
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
/*
* Copyright 2023 Valdemar Grange
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package gql.relational.doobie
import cats.effect._
import cats.implicits._
import cats._
import cats.data._
import doobie._
import doobie.implicits._
import gql.relational.{QueryAlgebra, QueryDsl}
object DoobieIntegraion extends QueryAlgebra {
type Frag = doobie.Fragment
def stringToFrag(s: String): Frag = doobie.Fragment.const(s)
implicit def appliedFragmentMonoid: Monoid[Frag] = doobie.Fragment.FragmentMonoid
type Decoder[A] = doobie.Read[A]
type Encoder[A] = doobie.Write[A]
def optDecoder[A](d: Decoder[A]): Decoder[Option[A]] =
new doobie.Read(
d.gets.map { case (ev, _) => (ev, doobie.enumerated.Nullability.Nullable) },
{ (rs, n) =>
val xs = d.gets.zipWithIndex.traverse { case ((ev, _), i) => ev.unsafeGetNullable(rs, n + i) }
xs.as(d.unsafeGet(rs, n))
}
)
implicit def applicativeForDecoder: Applicative[Decoder] = doobie.Read.ReadApply
type Connection[F[_]] = Transactor[F]
implicit def doobieQueryable[F[_]: MonadCancelThrow]: Queryable[F] = new Queryable[F] {
def apply[A](query: Frag, decoder: Decoder[A], connection: Connection[F]): F[List[A]] =
query.query(decoder).to[List].transact(connection)
}
}
object dsl extends QueryDsl(DoobieIntegraion) {
import algebra._
trait DoobieTable extends Table {
def aliased(x: Fragment): Fragment =
Fragment.const(alias) ++ fr"." ++ x
def sel[A](x: String, d: Decoder[A]): (Fragment, Query.Select[A]) = {
val col = aliased(Fragment.const(x))
col -> Query.Select(Chain(col), d)
}
}
}