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 (
"context"
"database/sql"
"io"
"strings"
metadatapb "github.com/bytebase/omni/metadata"
"github.com/cockroachdb/cockroach-go/v2/crdb"
)
// Dump dumps the database.
func (d *Driver) Dump(ctx context.Context, w io.Writer, _ *metadatapb.DatabaseSchemaMetadata) error {
sb := &strings.Builder{}
if err := crdb.ExecuteTx(ctx, d.db, &sql.TxOptions{
ReadOnly: true,
}, func(txn *sql.Tx) error {
createSchemas, err := dumpCreateSchemas(ctx, txn)
if err != nil {
return err
}
_, _ = sb.WriteString(createSchemas)
createTables, err := dumpCreateTables(ctx, txn)
if err != nil {
return err
}
_, _ = sb.WriteString(createTables)
return nil
}); err != nil {
return err
}
if _, err := w.Write([]byte(sb.String())); err != nil {
return err
}
return nil
}
func dumpCreateTables(ctx context.Context, txn *sql.Tx) (string, error) {
sb := &strings.Builder{}
rows, err := txn.QueryContext(ctx, "SELECT create_statement FROM [SHOW CREATE ALL TABLES];")
if err != nil {
return "", err
}
defer rows.Close()
for rows.Next() {
var payload string
if err := rows.Scan(&payload); err != nil {
return "", err
}
_, _ = sb.WriteString(payload)
_, _ = sb.WriteString("\n\n")
}
if err := rows.Err(); err != nil {
return "", err
}
return sb.String(), nil
}
func dumpCreateSchemas(ctx context.Context, txn *sql.Tx) (string, error) {
sb := &strings.Builder{}
rows, err := txn.QueryContext(ctx, "SELECT create_statement FROM [SHOW CREATE ALL SCHEMAS];")
if err != nil {
return "", err
}
defer rows.Close()
for rows.Next() {
var payload string
if err := rows.Scan(&payload); err != nil {
return "", err
}
// Skip public schema
if strings.HasSuffix(payload, " public;") {
continue
}
_, _ = sb.WriteString(payload)
_, _ = sb.WriteString("\n\n")
}
if err := rows.Err(); err != nil {
return "", err
}
return sb.String(), nil
}