Function TestRenderDelete_AllClauses

pkg/formatter/render_test.go:298–315

(t *testing.T)

}

func TestRenderDelete_AllClauses(t *testing.T) {
	stmt := &ast.DeleteStatement{
		With: &ast.WithClause{CTEs: []*ast.CommonTableExpr{
			{Name: "c", Statement: &ast.SelectStatement{Columns: []ast.Expression{&ast.Identifier{Name: "x"}}}},
		}},
		TableName: "t",
		Alias:     "tt",
		Using:     []ast.TableReference{{Name: "other"}},
		Where:     &ast.Identifier{Name: "true"},
		Returning: []ast.Expression{&ast.Identifier{Name: "id"}},
	}
	result := fmtStmt(stmt, ast.ReadableStyle())
	for _, want := range []string{"WITH", "DELETE FROM t tt", "USING", "WHERE", "RETURNING"} {
		if !strings.Contains(result, want) {
			t.Errorf("missing %q in: %s", want, result)
		}
	}
}

func TestRenderDelete_Nil(t *testing.T) {
	var stmt *ast.DeleteStatement