public void CompareSingleTable_Same_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData);
compareUnits.Compare("event_received_local", "event_received_local");
Assert.False(compareUnits.ChangeSql.Any());
}
public void CompareSingleTable_AddColumn_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData);
compareUnits.Compare("event_received_template", "event_received_local");
Assert.True(compareUnits.ChangeSql.Count == 1);
Assert.Contains("alter table demo.event_received_local add COLUMN Remark varchar(45) NOT NULL COMMENT '备注' after db_updated_at;", compareUnits.ChangeSql);
}
public void CompareSingleTable_NotDropRedundancy_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData, new CompareUnitsOption {
IsDropRedundancy = false
});
compareUnits.Compare("event_received_local", "event_received_template");
Assert.True(compareUnits.ChangeSql.Count == 0);
}
public void CompareSingleTable_DropColumn_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData, new CompareUnitsOption {
IsDropRedundancy = true
});
compareUnits.Compare("event_received_local", "event_received_template");
Assert.True(compareUnits.ChangeSql.Count == 1);
Assert.Contains("alter table demo.event_received_template drop COLUMN Remark ;", compareUnits.ChangeSql);
}
public void CompareSingleTable_AddColumnAndIndex_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData, new CompareUnitsOption {
IsSyncIndex = true
});
compareUnits.Compare("event_received_template", "event_received_local");
Assert.True(compareUnits.ChangeSql.Count == 2);
Assert.Contains("alter table demo.event_received_local add index idx_statusname_retry (`StatusName`,`Retry`);", compareUnits.ChangeSql);
}
public void CompareSingleTable_DropColumnAndIndex_Apply_Test()
{
var metaData = new MetaData(connectionString1);
var compareUnits = new CompareUnits(metaData, metaData, new CompareUnitsOption {
IsSyncIndex = true, IsDropRedundancy = true
});
compareUnits.Compare("event_received_local", "event_received_template");
Assert.True(compareUnits.ChangeSql.Count == 2);
Assert.Contains("alter table demo.event_received_template drop index idx_statusname_retry ;", compareUnits.ChangeSql);
compareUnits.ApplyChanges();
compareUnits.Compare("event_received_local", "event_received_template");
Assert.Empty(compareUnits.ChangeSql);
}
