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); }