Function compareTableDetails

backend/plugin/schema/differ.go:534–597

compareTableDetails compares the details of two tables.

(engine storepb.Engine, schemaName, tableName string, oldTable, newTable *model.TableMetadata)

// compareTableDetails compares the details of two tables.
func compareTableDetails(engine storepb.Engine, schemaName, tableName string, oldTable, newTable *model.TableMetadata) *TableDiff {
	tableDiff := &TableDiff{
		Action:     MetadataDiffActionAlter,
		SchemaName: schemaName,
		TableName:  tableName,
		OldTable:   oldTable.GetProto(),
		NewTable:   newTable.GetProto(),
	}

	hasChanges := false

	// Compare columns
	columnChanges := compareColumns(engine, oldTable, newTable)
	if len(columnChanges) > 0 {
		tableDiff.ColumnChanges = columnChanges
		hasChanges = true
	}

	// Compare indexes
	indexChanges := compareIndexes(engine, oldTable, newTable)
	if len(indexChanges) > 0 {
		tableDiff.IndexChanges = indexChanges
		hasChanges = true
	}

	// Compare foreign keys
	fkChanges := compareForeignKeys(oldTable.GetProto().ForeignKeys, newTable.GetProto().ForeignKeys)
	if len(fkChanges) > 0 {
		tableDiff.ForeignKeyChanges = fkChanges
		hasChanges = true
	}

	// Compare check constraints
	checkChanges := compareCheckConstraints(engine, oldTable.GetProto().CheckConstraints, newTable.GetProto().CheckConstraints)
	if len(checkChanges) > 0 {
		tableDiff.CheckConstraintChanges = checkChanges
		hasChanges = true
	}

	// Compare partitions
	partitionChanges := comparePartitions(engine, oldTable.GetProto().Partitions, newTable.GetProto().Partitions)
	if len(partitionChanges) > 0 {
		tableDiff.PartitionChanges = partitionChanges
		hasChanges = true
	}

	// Compare triggers
	triggerChanges := compareTriggers(oldTable.GetProto().Triggers, newTable.GetProto().Triggers)
	if len(triggerChanges) > 0 {
		tableDiff.TriggerChanges = triggerChanges
		hasChanges = true
	}

	// Compare table comments
	if oldTable.GetProto().Comment != newTable.GetProto().Comment {
		hasChanges = true
	}