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.
Dernier runRéussi#28 · main · 3 min 34 s
0Étoiles
0Forks
3Issues
| 1 | // The `sql` tagged template (ADR 0048): holes number into parameters. |
| 2 | |
| 3 | import postgres as pg |
| 4 | import postgres.{type Statement, Statement, sql} |
| 5 | import std/test.{assert, assert_equal} |
| 6 | |
| 7 | @test |
| 8 | fn 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 |
| 24 | fn 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 |
| 32 | fn 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 | } |