// The `sql` tagged template (ADR 0048): holes number into parameters. import postgres as pg import postgres.{type Statement, Statement, sql} import std/test.{assert, assert_equal} @test fn a_template_numbers_its_parameters :: { let id = "s-1" let n = 41 let Statement ( text , params ) = sql`select * from streams where id = {id} and version > {n}` assert_equal text "select * from streams where id = $1 and version > $2" // Each hole's `Show` text is the parameter's wire encoding. assert (params == [pg.text "s-1", pg.text "41"]) "the parameters in order: {params:?}" } @test fn no_holes_is_no_parameters :: { let Statement(text, params) = sql`select 1` assert_equal text "select 1" assert (params == []) "no parameters" } @test fn adjacent_holes_stay_in_order :: { let Statement(text, params) = sql`{1}{2}{3}` assert_equal text "$1$2$3" assert (params == [pg.text "1", pg.text "2", pg.text "3"]) "in order" }