Skip to content

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

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