| 57 | } |
| 58 | |
| 59 | func TestQuery_JoinWithParams(t *testing.T) { |
| 60 | q := Q().Space("INSERT INTO users (name, email) VALUES"). |
| 61 | Join(", ", "(?, ?)", "Alice", "alice@example.com"). |
| 62 | Join(", ", "(?, ?)", "Bob", "bob@example.com") |
| 63 | sql, args, err := q.ToSQL() |
| 64 | require.NoError(t, err) |
| 65 | require.Equal(t, "INSERT INTO users (name, email) VALUES, ($1, $2), ($3, $4)", sql) |
| 66 | require.Equal(t, []any{"Alice", "alice@example.com", "Bob", "bob@example.com"}, args) |
| 67 | } |
| 68 | |
| 69 | func TestQuery_NoParameters(t *testing.T) { |
| 70 | q := Q().Space("SELECT * FROM users"). |