| 142 | } |
| 143 | |
| 144 | func TestQuery_ChainedCalls(t *testing.T) { |
| 145 | // Test that we can chain calls continuously |
| 146 | sql, args, err := Q(). |
| 147 | Space("SELECT * FROM users"). |
| 148 | Where("status = ?", "active"). |
| 149 | And("role = ?", "admin"). |
| 150 | Space("ORDER BY created_at DESC"). |
| 151 | ToSQL() |
| 152 | require.NoError(t, err) |
| 153 | require.Equal(t, "SELECT * FROM users WHERE status = $1 AND role = $2 ORDER BY created_at DESC", sql) |
| 154 | require.Equal(t, []any{"active", "admin"}, args) |
| 155 | } |
| 156 | |
| 157 | func TestQuery_ConditionalBuilding(t *testing.T) { |
| 158 | // Simulate building a query with optional filters |