| 13 | ) |
| 14 | |
| 15 | func TestFieldIsNull(t *testing.T) { |
| 16 | p := FieldIsNull("name") |
| 17 | t.Run("MySQL", func(t *testing.T) { |
| 18 | s := Dialect(dialect.MySQL).Select("*").From(Table("users")) |
| 19 | p(s) |
| 20 | query, args := s.Query() |
| 21 | require.Equal(t, "SELECT * FROM `users` WHERE `users`.`name` IS NULL", query) |
| 22 | require.Empty(t, args) |
| 23 | }) |
| 24 | t.Run("PostgreSQL", func(t *testing.T) { |
| 25 | s := Dialect(dialect.Postgres).Select("*").From(Table("users")) |
| 26 | p(s) |
| 27 | query, args := s.Query() |
| 28 | require.Equal(t, `SELECT * FROM "users" WHERE "users"."name" IS NULL`, query) |
| 29 | require.Empty(t, args) |
| 30 | }) |
| 31 | } |
| 32 | |
| 33 | func TestFieldNotNull(t *testing.T) { |
| 34 | p := FieldNotNull("name") |