Function TestAndPredicates

dialect/sql/sql_test.go:429–443

(t *testing.T)

}

func TestAndPredicates(t *testing.T) {
	s := Select("*").From(Table("users")).Where(EQ("name", "a8m"))
	p := AndPredicates(
		FieldEQ("a", "foo"),
		FieldEQ("b", 1),
		func(s *Selector) {
			petT := Table("pets").As("p")
			s.Join(petT).On(petT.C("owner_id"), s.C("id"))
		},
	)
	p(s)
	query, args := s.Query()
	require.Equal(t, "SELECT * FROM `users` JOIN `pets` AS `p` ON `p`.`owner_id` = `users`.`id` WHERE `name` = ? AND (`users`.`a` = ? AND `users`.`b` = ?)", query)
	require.Equal(t, []any{"a8m", "foo", 1}, args)
}

func TestOrPredicates(t *testing.T) {
	s := Select("*").From(Table("users")).Where(EQ("name", "a8m"))