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