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()); }
public string GetColumnMappingValue() { if (columnMapping is ExcelColumnMapping) { string header = ((ExcelColumnMapping)columnMapping).SourceHeader; SourceDataEntry entry = sourceDataRow.GetSourceDataEntry(header); return(excelColumnMappingPart((ExcelColumnMapping)columnMapping, entry)); } else if (columnMapping is TableColumnMapping) { var tableColMapping = (TableColumnMapping)columnMapping; StatementTableVariablePart tableVariablePart = new StatementTableVariablePart(tableColMapping.SourceTableMapping); string tableVariable = tableVariablePart.GetTableVariable(); return(tableColumnMappingPart(tableColMapping, tableVariable)); } else if (columnMapping is LiteralColumnMapping) { return(literalColumnMappingPart((LiteralColumnMapping)columnMapping)); } else { return(nullColumnMappingPart((NullColumnMapping)columnMapping)); } }
public string GetColumnMappingValue() { if (columnMapping is ExcelColumnMapping) { string header = ((ExcelColumnMapping)columnMapping).SourceHeader; SourceDataEntry entry = sourceDataRow.GetSourceDataEntry(header); return excelColumnMappingPart((ExcelColumnMapping)columnMapping, entry); } else if (columnMapping is TableColumnMapping) { var tableColMapping = (TableColumnMapping)columnMapping; StatementTableVariablePart tableVariablePart = new StatementTableVariablePart(tableColMapping.SourceTableMapping); string tableVariable = tableVariablePart.GetTableVariable(); return tableColumnMappingPart(tableColMapping, tableVariable); } else if (columnMapping is LiteralColumnMapping) { return literalColumnMappingPart((LiteralColumnMapping)columnMapping); } else { return nullColumnMappingPart((NullColumnMapping)columnMapping); } }
private string getTableVariable(TableMapping tableMapping) { StatementTableVariablePart tableVariablePart = new StatementTableVariablePart(tableMapping); return(tableVariablePart.GetTableVariable()); }
private string getTableVariable(TableMapping tableMapping) { StatementTableVariablePart tableVariablePart = new StatementTableVariablePart(tableMapping); return tableVariablePart.GetTableVariable(); }