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 oceanbase
import (
"fmt"
metadatapb "github.com/bytebase/omni/metadata"
"github.com/bytebase/omni/oceanbase/catalog"
"github.com/pkg/errors"
storepb "github.com/bytebase/bytebase/backend/generated-go/store"
"github.com/bytebase/bytebase/backend/plugin/schema"
)
func init() {
schema.RegisterGetDatabaseMetadata(storepb.Engine_OCEANBASE, GetDatabaseMetadata)
}
// GetDatabaseMetadata parses MySQL schema DDL text and returns database metadata
// using the omni catalog.
func GetDatabaseMetadata(schemaText string) (*metadatapb.DatabaseSchemaMetadata, error) {
if schemaText == "" {
return &metadatapb.DatabaseSchemaMetadata{}, nil
}
const dbName = "tmp"
c := catalog.New()
initSQL := fmt.Sprintf("SET foreign_key_checks = 0;\nCREATE DATABASE IF NOT EXISTS `%s`;\nUSE `%s`;", dbName, dbName)
if _, err := c.Exec(initSQL, nil); err != nil {
return nil, errors.Wrap(err, "failed to initialize catalog")
}
results, err := c.Exec(schemaText, &catalog.ExecOptions{ContinueOnError: true})
if err != nil {
return nil, errors.Wrap(err, "failed to parse schema DDL")
}
// Check for hard errors (not per-statement errors).
for _, r := range results {
if r.Error != nil {
return nil, errors.Wrapf(r.Error, "failed to execute schema DDL")
}
}
proto := catalogToProto(c, dbName)
return proto, nil
}