giacomocavalieri.me
🐿️ Type safe SQL in Gleam
574 B
30 lines
1---
2version: 2.0.0
3title: numeric encoding
4file: ./test/squirrel_test.gleam
5test_name: numeric_encoding_test
6---
7
8import gleam/dynamic/decode
9import pog
10
11pub type QueryRow {
12 QueryRow(res: Bool)
13}
14
15pub fn query(
16 connection: pog.Connection,
17 arg_1: Float,
18) -> Result(pog.Returned(QueryRow), pog.QueryError) {
19 let decoder = {
20 use res <- decode.field(0, decode.bool)
21 decode.success(QueryRow(res:))
22 }
23
24 "select true as res where $1 = 1.1::numeric"
25 |> pog.query
26 |> pog.parameter(pog.float(arg_1))
27 |> pog.returning(decoder)
28 |> pog.execute(connection)
29}
30