Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.3 KB
Raw Blame
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
}