(t *testing.T)
| 23 | } |
| 24 | |
| 25 | func TestQuery_MultipleParameters(t *testing.T) { |
| 26 | q := Q().Space("SELECT * FROM users"). |
| 27 | Where("id = ?", 123). |
| 28 | And("active = ?", true). |
| 29 | And("role = ?", "admin") |
| 30 | sql, args, err := q.ToSQL() |
| 31 | require.NoError(t, err) |
| 32 | require.Equal(t, "SELECT * FROM users WHERE id = $1 AND active = $2 AND role = $3", sql) |
| 33 | require.Equal(t, []any{123, true, "admin"}, args) |
| 34 | } |
| 35 | |
| 36 | func TestQuery_AndOr(t *testing.T) { |
| 37 | q := Q().Space("SELECT * FROM users"). |