| 193 | } |
| 194 | |
| 195 | func TestFieldLT(t *testing.T) { |
| 196 | p := FieldLT("stars", 1000) |
| 197 | t.Run("MySQL", func(t *testing.T) { |
| 198 | s := Dialect(dialect.MySQL).Select("*").From(Table("users")) |
| 199 | p(s) |
| 200 | query, args := s.Query() |
| 201 | require.Equal(t, "SELECT * FROM `users` WHERE `users`.`stars` < ?", query) |
| 202 | require.Equal(t, []any{1000}, args) |
| 203 | }) |
| 204 | t.Run("PostgreSQL", func(t *testing.T) { |
| 205 | s := Dialect(dialect.Postgres).Select("*").From(Table("users")) |
| 206 | p(s) |
| 207 | query, args := s.Query() |
| 208 | require.Equal(t, `SELECT * FROM "users" WHERE "users"."stars" < $1`, query) |
| 209 | require.Equal(t, []any{1000}, args) |
| 210 | }) |
| 211 | } |
| 212 | |
| 213 | func TestFieldsLT(t *testing.T) { |
| 214 | p := FieldsLT("a", "b") |