Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
package cockroachdb
import (
"strings"
crrawparser "github.com/cockroachdb/cockroachdb-parser/pkg/sql/parser"
"github.com/cockroachdb/cockroachdb-parser/pkg/sql/parser/statements"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
"github.com/bytebase/bytebase/backend/plugin/parser/base"
"github.com/bytebase/bytebase/backend/utils"
)
func init() {
base.RegisterParseStatementsFunc(storepb.Engine_COCKROACHDB, parseCockroachDBStatements)
}
// parseCockroachDBStatements is the ParseStatementsFunc for CockroachDB.
// Returns []ParsedStatement with both text and AST populated.
func parseCockroachDBStatements(statement string) ([]base.ParsedStatement, error) {
// First split to get Statement with text and positions (uses PostgreSQL splitter)
stmts, err := base.SplitMultiSQL(storepb.Engine_COCKROACHDB, statement)
if err != nil {
return nil, err
}
// Then parse to get ASTs
parseResult, err := ParseCockroachDBSQL(statement)
if err != nil {
return nil, err
}
// Combine: Statement provides text/positions, AST provides parsed tree
var result []base.ParsedStatement
astIndex := 0
for _, stmt := range stmts {
ps := base.ParsedStatement{
Statement: stmt,
}
if !stmt.Empty && parseResult != nil && astIndex < len(parseResult.Stmts) {
ps.AST = &AST{
StartPosition: &storepb.Position{Line: 1},
Stmt: parseResult.Stmts[astIndex],
}
astIndex++
}
result = append(result, ps)
}
return result, nil
}
type ParseResult struct {
Stmts statements.Statements
}
// ParseCockroachDBSQL parses the given CockroachDB statement by using LALR(1) parser. Returns the AST if no error.
func ParseCockroachDBSQL(statement string) (*ParseResult, error) {
statement = strings.TrimRightFunc(statement, utils.IsSpaceOrSemicolon) + ";"
stmts, err := crrawparser.Parse(statement)
if err != nil {
return nil, err
}
result := &ParseResult{
Stmts: stmts,
}
return result, nil
}
func SplitSQLStatement(statement string) ([]string, error) {
statement = strings.TrimRightFunc(statement, utils.IsSpaceOrSemicolon) + ";"
stmts, err := crrawparser.Parse(statement)
if err != nil {
return nil, err
}
var result []string
for _, stmt := range stmts {
sql := stmt.SQL
if !strings.HasSuffix(sql, ";") {
sql += ";"
}
result = append(result, sql)
}
return result, nil
}