public void StatementColumnMappingPartTest() { DBColumn col = new DBColumn(null, "TestCol", true, DBDatatype.integer); SourceDataEntry entry = SourceDataEntry.CreateDataEntry("Test", DataType.String, "Test"); SourceDataRow row = new SourceDataRow(new SourceDataEntry[] {entry}, ""); DBTable table = new DBTable("dbo", "TestTable"); DBColumn col1 = new DBColumn(table, "TestCol1", true, DBDatatype.integer); table.Columns = new List<DBColumn>() { col1 }; TableMapping tableMapping = new TableMapping(table, TableMappingImportType.Insert, null); NullColumnMapping nullColumnMapping = new NullColumnMapping(col, ColumnUse.Insert); LiteralColumnMapping literalColumnMapping1 = new LiteralColumnMapping("Test", LiteralType.String, col, ColumnUse.Insert); LiteralColumnMapping literalColumnMapping2 = new LiteralColumnMapping("Test's", LiteralType.String, col, ColumnUse.Insert); ExcelColumnMapping excelColumnMapping = new ExcelColumnMapping("Test", col, ColumnUse.Insert); TableColumnMapping tableColMapping = new TableColumnMapping(tableMapping, col1, col, ColumnUse.Insert); StatementColumnMappingPart nullColumnPart = new StatementColumnMappingPart(nullColumnMapping, row); StatementColumnMappingPart literalColumnPart1 = new StatementColumnMappingPart(literalColumnMapping1, row); StatementColumnMappingPart literalColumnPart2 = new StatementColumnMappingPart(literalColumnMapping2, row); StatementColumnMappingPart excelColumnPart = new StatementColumnMappingPart(excelColumnMapping, row); StatementColumnMappingPart tableColumnPart = new StatementColumnMappingPart(tableColMapping, row); Assert.AreEqual("NULL", nullColumnPart.GetColumnMappingValue()); Assert.AreEqual("'Test'", literalColumnPart1.GetColumnMappingValue()); Assert.AreEqual("'Test''s'", literalColumnPart2.GetColumnMappingValue()); Assert.AreEqual("'Test'", excelColumnPart.GetColumnMappingValue()); StatementTableVariablePart tableVariablePart = new StatementTableVariablePart(tableMapping); Assert.AreEqual(String.Format("(SELECT TOP 1 t.TestCol1 FROM {0} t)", tableVariablePart.GetTableVariable()), tableColumnPart.GetColumnMappingValue()); }
private string getColumnMappingValue(ColumnMapping mapping) { StatementColumnMappingPart columnMappingPart = new StatementColumnMappingPart(mapping, sourceDataRow); return(columnMappingPart.GetColumnMappingValue()); }
private string getColumnMappingValue(ColumnMapping mapping) { StatementColumnMappingPart columnMappingPart = new StatementColumnMappingPart(mapping, sourceDataRow); return columnMappingPart.GetColumnMappingValue(); }