| 121 | } |
| 122 | |
| 123 | func TestFieldGT(t *testing.T) { |
| 124 | p := FieldGT("stars", 1000) |
| 125 | t.Run("MySQL", func(t *testing.T) { |
| 126 | s := Dialect(dialect.MySQL).Select("*").From(Table("users")) |
| 127 | p(s) |
| 128 | query, args := s.Query() |
| 129 | require.Equal(t, "SELECT * FROM `users` WHERE `users`.`stars` > ?", query) |
| 130 | require.Equal(t, []any{1000}, args) |
| 131 | }) |
| 132 | t.Run("PostgreSQL", func(t *testing.T) { |
| 133 | s := Dialect(dialect.Postgres).Select("*").From(Table("users")) |
| 134 | p(s) |
| 135 | query, args := s.Query() |
| 136 | require.Equal(t, `SELECT * FROM "users" WHERE "users"."stars" > $1`, query) |
| 137 | require.Equal(t, []any{1000}, args) |
| 138 | }) |
| 139 | } |
| 140 | |
| 141 | func TestFieldsGT(t *testing.T) { |
| 142 | p := FieldsGT("a", "b") |