mysqldump

type CheckConstraintSchema struct {
	Name       string
	Expression string
}

type ColumnSchema struct {
	Name           string
	Type           string
	CharacterSet   sql.NullString
	Nullable       bool
	Default        sql.NullString
	Extra          string
	Collation      sql.NullString
	Comment        string
	GenerationExpr sql.NullString
	IsVirtual      bool
	CheckExpr      string
}

type Compression string

type Dumper struct {

	// SelectMap contains column rewrites per table (table -> column -> SQL expression)
	SelectMap map[string]map[string]string
	// WhereMap contains WHERE clauses per table (table -> WHERE clause)
	WhereMap map[string]string
	// NoData contains list of tables to dump structure only (no data), supports glob wildcards (e.g. "cart*")
	NoData []string
	// Ignore contains list of tables to skip entirely, supports glob wildcards (e.g. "cart*")
	Ignore []string
	// LimitMap contains row limits per table (table -> limit). Tables referencing
	// a limited table via foreign keys are filtered automatically.
	LimitMap map[string]TableLimit

	// LockTables controls whether to lock tables during dump (default: true)
	LockTables bool
	// Quick enables quick mode for mysqldump (default: false)
	Quick bool
	// InsertIntoLimit controls how many rows are included in each INSERT statement (default: 100).
	// When set to a positive value, it takes priority over Quick mode.
	// When not set (0 or negative) and Quick is true, the batch size is 1.
	InsertIntoLimit int
	// Parallel controls how many tables to dump concurrently (default: 0 = disabled)
	Parallel int
	// contains filtered or unexported fields
}

type ForeignKeySchema struct {
	Name              string
	Columns           []string
	ReferencedTable   string
	ReferencedColumns []string
	OnDelete          string
	OnUpdate          string
}

type IndexColumnSchema struct {
	Name    string
	SubPart sql.NullInt64
	Order   string
}

type IndexSchema struct {
	Name       string
	Columns    []IndexColumnSchema
	IsUnique   bool
	Type       string
	Comment    string
	SeqInTable int
}

type TableLimit struct {
	// Maximum amount of rows to export for this table
	Rows int `yaml:"rows" jsonschema:"required,minimum=1"`
	// SQL ORDER BY clause deciding which rows are kept (e.g. "created_at DESC" for the newest rows). Defaults to "created_at DESC" when the table has a created_at column
	OrderBy string `yaml:"order_by,omitempty"`
}

type TableSchema struct {
	Name             string
	Engine           string
	Charset          string
	Collation        string
	Comment          string
	RowFormat        string
	AutoIncrement    sql.NullInt64
	Columns          []ColumnSchema
	PrimaryKey       []string
	Indexes          []IndexSchema
	ForeignKeys      []ForeignKeySchema
	CheckConstraints []CheckConstraintSchema
}