Function TestAddJoin

pkg/transform/joins_test.go:23–37

(t *testing.T)

)

func TestAddJoin(t *testing.T) {
	stmt := mustParse(t, "SELECT * FROM users")
	cond := &ast.BinaryExpression{
		Left:     &ast.Identifier{Name: "id", Table: "orders"},
		Operator: "=",
		Right:    &ast.Identifier{Name: "user_id", Table: "users"},
	}
	err := Apply(stmt, AddJoin("LEFT", "orders", cond))
	if err != nil {
		t.Fatal(err)
	}
	out := format(stmt)
	assertContains(t, out, "LEFT JOIN")
	assertContains(t, out, "orders")
}

func TestRemoveJoin(t *testing.T) {
	stmt := mustParse(t, "SELECT * FROM users INNER JOIN orders ON orders.user_id = users.id")