| 49 | } |
| 50 | |
| 51 | func TestFieldEQ(t *testing.T) { |
| 52 | p := FieldEQ("name", "a8m") |
| 53 | t.Run("MySQL", func(t *testing.T) { |
| 54 | s := Dialect(dialect.MySQL).Select("*").From(Table("users")) |
| 55 | p(s) |
| 56 | query, args := s.Query() |
| 57 | require.Equal(t, "SELECT * FROM `users` WHERE `users`.`name` = ?", query) |
| 58 | require.Equal(t, []any{"a8m"}, args) |
| 59 | }) |
| 60 | t.Run("PostgreSQL", func(t *testing.T) { |
| 61 | s := Dialect(dialect.Postgres).Select("*").From(Table("users")) |
| 62 | p(s) |
| 63 | query, args := s.Query() |
| 64 | require.Equal(t, `SELECT * FROM "users" WHERE "users"."name" = $1`, query) |
| 65 | require.Equal(t, []any{"a8m"}, args) |
| 66 | }) |
| 67 | } |
| 68 | |
| 69 | func TestFieldsEQ(t *testing.T) { |
| 70 | p := FieldsEQ("create_time", "update_time") |