diff

type AlterStatementGenerator struct {
	// contains filtered or unexported fields
}

type BooleanStatistics struct {
	TrueCount  int64
	FalseCount int64
	NullCount  int64
	Count      int64
}

type Column struct {
	Name           string
	Type           string         // Original database-specific type (e.g., "INTEGER", "VARCHAR(255)")
	NormalizedType CommonDataType // Normalized common type (e.g., "numeric", "string")
	Nullable       bool
	PrimaryKey     bool
	Unique         bool

	Stats ColumnStatistics
}

type ColumnDifference struct {
	ColumnName            string
	TypeDifference        *TypeDifference
	NullabilityDifference *NullabilityDifference
	UniquenessDifference  *UniquenessDifference
}

type ColumnStatistics interface {
	Type() string
}

type CommonDataType string

type DatabaseDialect string

type DatabaseTypeMapper struct {
	// contains filtered or unexported fields
}

type DateTimeStatistics struct {
	EarliestDate *time.Time // Earliest datetime value or nil
	LatestDate   *time.Time // Latest datetime value or nil
	Count        int64
	NullCount    int64
	UniqueCount  int64
}

type JSONStatistics struct {
	Count     int64
	NullCount int64
}

type MissingColumn struct {
	ColumnName  string
	Type        string
	Nullable    bool
	PrimaryKey  bool
	Unique      bool
	TableName   string // The table where this column exists
	MissingFrom string // The table where this column is missing
}

type NullabilityDifference struct {
	Table1Nullable bool
	Table2Nullable bool
}

type NumericalStatistics struct {
	Min       *float64 // pointer to handle NULL values
	Max       *float64
	Avg       *float64
	Sum       *float64
	Count     int64
	NullCount int64
	StdDev    *float64
}

type SchemaComparisonResult struct {
	Table1 *TableSummaryResult
	Table2 *TableSummaryResult

	SamePropertiesCount      int                // Columns with identical properties in both tables
	DifferentPropertiesCount int                // Columns present in both tables but with different properties
	InTable1OnlyCount        int                // Columns present in table1 but not in table2
	InTable2OnlyCount        int                // Columns present in table2 but not in table1
	ColumnDifferences        []ColumnDifference // Structured differences for columns present in both tables
	MissingColumns           []MissingColumn    // Columns missing from one of the tables
	HasSchemaDifferences     bool               // True if DifferentPropertiesCount, InTable1OnlyCount, or InTable2OnlyCount > 0
	RowCountDiff             int64              // Difference in row count between the two tables
	HasRowCountDifference    bool               // True if RowCountDiff != 0
}

type StringStatistics struct {
	DistinctCount int64
	MaxLength     int
	MinLength     int
	AvgLength     float64
	Count         int64
	NullCount     int64
	EmptyCount    int64
	MostCommon    map[string]int64 // value -> frequency
	TopNDistinct  []string         // top N most common values
}

type Table struct {
	Name    string
	Columns []*Column
}

type TableSummarizer interface {
	GetTableSummary(ctx context.Context, tableName string, schemaOnly bool) (*TableSummaryResult, error)
}

type TableSummaryResult struct {
	RowCount int64
	Table    *Table
}

type Type struct {
	Name      string
	Size      int
	Precision int
	Scale     int
}

type TypeDifference struct {
	Table1Type           string
	Table2Type           string
	Table1NormalizedType CommonDataType
	Table2NormalizedType CommonDataType
	IsComparable         bool // True if normalized types are the same (e.g., both numeric)
}

type TypeMapping interface {
	MapType(databaseType string) CommonDataType
	IsNumeric(databaseType string) bool
	IsString(databaseType string) bool
	IsBoolean(databaseType string) bool
	IsDateTime(databaseType string) bool
}

type UniquenessDifference struct {
	Table1Unique bool
	Table2Unique bool
}

type UnknownStatistics struct{}