validate

type Change struct {
	Kind    ChangeKind
	Table   string
	Subject string // column/index name, or empty for table-level changes
	Detail  string // e.g. "TEXT→VARCHAR"
}

type ChangeKind string

type ColumnSpec struct {
	Name string `yaml:"name" json:"name"`
	Type string `yaml:"type" json:"type,omitempty"`
}

type DataSpec map[string]TableDataSpec

type IndexSpec struct {
	Name   string `yaml:"name"   json:"name"`
	Unique bool   `yaml:"unique" json:"unique,omitempty"`
}

type Result struct {
	Passed     bool
	Confirmed  []Change // expected and found
	Unexpected []Change // found but not expected
	Missing    []Change // expected but not found
}

type SchemaSpec struct {
	AddedTables    []string      `yaml:"added_tables"    json:"added_tables,omitempty"`
	RemovedTables  []string      `yaml:"removed_tables"  json:"removed_tables,omitempty"`
	ModifiedTables []TableChange `yaml:"modified_tables" json:"modified_tables,omitempty"`
}

type Spec struct {
	Version     int        `yaml:"version"     json:"version"`
	Description string     `yaml:"description"  json:"description,omitempty"`
	Schema      SchemaSpec `yaml:"schema"       json:"schema"`
	Data        DataSpec   `yaml:"data"         json:"data,omitempty"`
}

type TableChange struct {
	Table          string       `yaml:"table"            json:"table"`
	AddedColumns   []ColumnSpec `yaml:"added_columns"    json:"added_columns,omitempty"`
	RemovedColumns []ColumnSpec `yaml:"removed_columns"  json:"removed_columns,omitempty"`
	AddedIndexes   []IndexSpec  `yaml:"added_indexes"    json:"added_indexes,omitempty"`
	RemovedIndexes []IndexSpec  `yaml:"removed_indexes"  json:"removed_indexes,omitempty"`
}

type TableDataSpec struct {
	MinRows *int64 `yaml:"min_rows" json:"min_rows,omitempty"`
	MaxRows *int64 `yaml:"max_rows" json:"max_rows,omitempty"`
}