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 plsql
import (
"context"
"errors"
"strings"
"unicode"
"github.com/bytebase/bytebase/backend/generated-go/store"
"github.com/bytebase/bytebase/backend/plugin/parser/base"
)
func init() {
base.RegisterDiagnoseFunc(store.Engine_ORACLE, Diagnose)
}
func Diagnose(_ context.Context, _ base.DiagnoseContext, statement string) ([]base.Diagnostic, error) {
diagnostics := make([]base.Diagnostic, 0)
syntaxError := parsePLSQLStatement(statement)
if syntaxError != nil {
diagnostics = append(diagnostics, base.ConvertSyntaxErrorToDiagnostic(syntaxError, statement))
}
return diagnostics, nil
}
func parsePLSQLStatement(statement string) *base.SyntaxError {
trimmedStatement := strings.TrimRightFunc(statement, unicode.IsSpace)
if len(trimmedStatement) > 0 && !strings.HasSuffix(trimmedStatement, ";") {
// Add a semicolon to the end of the statement to allow users to omit the semicolon
// for the last statement in the script.
statement += ";"
}
if _, err := ParsePLSQL(statement); err != nil {
var syntaxErr *base.SyntaxError
if errors.As(convertOmniError(err, base.Statement{Text: statement}), &syntaxErr) {
return syntaxErr
}
return &base.SyntaxError{
Position: &store.Position{Line: 1, Column: 1},
Message: err.Error(),
}
}
return nil
}