tobogganSe connecter

packages

The Louise packages, each released on its own

Clone avec HTTPS, un jeton personnel en mot de passe, ou avec SSH, une clé ajoutée dans vos paramètres.

37 lignes · 961 octetsBrut · Historique
1// The `sql` tagged template (ADR 0048): holes number into parameters.
2
3import postgres as pg
4import postgres.{type Statement, Statement, sql}
5import std/test.{assert, assert_equal}
6
7@test
8fn a_template_numbers_its_parameters ::
9{
10 let id = "s-1"
11 let n = 41
12 let Statement
13 ( text
14 , params
15 ) = sql`select * from streams where id = {id} and version > {n}`
16 assert_equal text "select * from streams where id = $1 and version > $2"
17 // Each hole's `Show` text is the parameter's wire encoding.
18 assert
19 (params == [pg.text "s-1", pg.text "41"])
20 "the parameters in order: {params:?}"
21}
22
23@test
24fn no_holes_is_no_parameters ::
25{
26 let Statement(text, params) = sql`select 1`
27 assert_equal text "select 1"
28 assert (params == []) "no parameters"
29}
30
31@test
32fn adjacent_holes_stay_in_order ::
33{
34 let Statement(text, params) = sql`{1}{2}{3}`
35 assert_equal text "$1$2$3"
36 assert (params == [pg.text "1", pg.text "2", pg.text "3"]) "in order"
37}