Function TestOrPredicates

dialect/sql/sql_test.go:445–462

(t *testing.T)

}

func TestOrPredicates(t *testing.T) {
	s := Select("*").From(Table("users")).Where(EQ("name", "a8m"))
	p := OrPredicates(
		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"))
			s.Where(EQ(petT.C("name"), "c"))
		},
	)
	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` = ?) OR `p`.`name` = ?)", query)
	require.Equal(t, []any{"a8m", "foo", 1, "c"}, args)
}

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