public void CycleTestTwoTable() { DBTable table1 = new DBTable("dbo", "1"); DBColumn table1ID = new DBColumn(table1, "1_id", true, DBDatatype.integer); table1.Columns = new List <DBColumn>() { table1ID }; DBTable table2 = new DBTable("dbo", "2"); DBColumn table2ID = new DBColumn(table2, "2_id", true, DBDatatype.integer); table2.Columns = new List <DBColumn>() { table2ID }; TableMapping t1Mapping = new TableMapping(table1, TableMappingImportType.Insert, new ColumnMapping[0]); TableMapping t2Mapping = new TableMapping(table2, TableMappingImportType.Insert, new ColumnMapping[0]); TableColumnMapping t1ColMaping = new TableColumnMapping(t2Mapping, table2ID, table1ID, ColumnUse.Insert); TableColumnMapping t2ColMaping = new TableColumnMapping(t1Mapping, table1ID, table2ID, ColumnUse.Insert); t1Mapping.ColumnMappings = new ColumnMapping[] { t1ColMaping }; t2Mapping.ColumnMappings = new ColumnMapping[] { t2ColMaping }; TableMapping[] mappingArray = new TableMapping[] { t1Mapping, t2Mapping }; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); }
public void NoTableTest() { TableMapping[] mappingArray = new TableMapping[0]; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); Assert.AreEqual(0, order.Length); }
public void OneTableTest() { TableMapping[] mappingArray = new TableMapping[1] { new TableMapping(new DBTable("", ""), TableMappingImportType.Insert, new ColumnMapping[0]) }; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); Assert.AreEqual(1, order.Length); }
public void CycleTestFourTable() { DBTable table1 = new DBTable("dbo", "1"); DBColumn table1ID = new DBColumn(table1, "1_id", true, DBDatatype.integer); table1.Columns = new List <DBColumn>() { table1ID }; DBTable table2 = new DBTable("dbo", "2"); DBColumn table2ID = new DBColumn(table2, "2_id", true, DBDatatype.integer); table2.Columns = new List <DBColumn>() { table2ID }; DBTable table3 = new DBTable("dbo", "3"); DBColumn table3ID = new DBColumn(table3, "3_id", true, DBDatatype.integer); table3.Columns = new List <DBColumn>() { table3ID }; DBTable table4 = new DBTable("dbo", "4"); DBColumn table4ID = new DBColumn(table4, "4_id", true, DBDatatype.integer); table4.Columns = new List <DBColumn>() { table4ID }; TableMapping t1Mapping = new TableMapping(table1, TableMappingImportType.Insert, new ColumnMapping[0]); TableMapping t2Mapping = new TableMapping(table2, TableMappingImportType.Insert, new ColumnMapping[0]); TableMapping t3Mapping = new TableMapping(table3, TableMappingImportType.Insert, new ColumnMapping[0]); TableMapping t4Mapping = new TableMapping(table4, TableMappingImportType.Insert, new ColumnMapping[0]); TableColumnMapping t21ColMaping = new TableColumnMapping(t1Mapping, table1ID, table2ID, ColumnUse.Insert); TableColumnMapping t24ColMaping = new TableColumnMapping(t4Mapping, table1ID, table2ID, ColumnUse.Insert); TableColumnMapping t3ColMaping = new TableColumnMapping(t2Mapping, table1ID, table2ID, ColumnUse.Insert); TableColumnMapping t4ColMaping = new TableColumnMapping(t3Mapping, table1ID, table2ID, ColumnUse.Insert); t2Mapping.ColumnMappings = new ColumnMapping[] { t21ColMaping, t24ColMaping }; t3Mapping.ColumnMappings = new ColumnMapping[] { t3ColMaping }; t4Mapping.ColumnMappings = new ColumnMapping[] { t4ColMaping }; TableMapping[] mappingArray = new TableMapping[] { t1Mapping, t2Mapping, t3Mapping, t4Mapping }; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); }
public void FourTableTest() { TableMapping[] testMappings = TestData.TableMappingTestData(); TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(testMappings); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); Assert.AreEqual(4, order.Length); Assert.AreEqual(testMappings[2].TableMappingReference, order[0].TableMappingReference); Assert.AreEqual(testMappings[0].TableMappingReference, order[1].TableMappingReference); Assert.AreEqual(testMappings[1].TableMappingReference, order[2].TableMappingReference); Assert.AreEqual(testMappings[3].TableMappingReference, order[3].TableMappingReference); }
public void TwoTablesSameOrderTest() { TableMapping[] testMappings = TestData.TableMappingTestData(); TableMapping[] mappingArray = new TableMapping[2] { testMappings[1], testMappings[3] }; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); Assert.AreEqual(2, order.Length); Assert.AreEqual(testMappings[1].TableMappingReference, order[0].TableMappingReference); Assert.AreEqual(testMappings[3].TableMappingReference, order[1].TableMappingReference); }
public void ThreeTablesDifferentOrderTest() { TableMapping[] testMappings = TestData.TableMappingTestData(); TableMapping[] mappingArray = new TableMapping[3] { testMappings[0], testMappings[1], testMappings[2] }; TableMappingOrderer tableMappingOrderer = new TableMappingOrderer(mappingArray); TableMapping[] order = tableMappingOrderer.OrderTableMappings(); Assert.AreEqual(3, order.Length); Assert.AreEqual(testMappings[2].TableMappingReference, order[0].TableMappingReference); Assert.AreEqual(testMappings[0].TableMappingReference, order[1].TableMappingReference); Assert.AreEqual(testMappings[1].TableMappingReference, order[2].TableMappingReference); }