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