public void Init()
{
CsvFile m_ReadFile = new CsvFile();
m_ReadFile.ID = "Read";
m_ReadFile.FileName = Path.Combine(m_ApplicationDirectory, "BasicCSV.txt");
m_ReadFile.FileFormat.FieldDelimiter = ",";
var cf = m_ReadFile.ColumnAdd(new Column {
Name = "ExamDate", DataType = DataType.DateTime
});
cf.DateFormat = @"dd/MM/yyyy";
m_ReadFile.FileFormat.CommentLine = "#";
m_ReadFile.ColumnAdd(new Column {
Name = "Score", DataType = DataType.Integer
});
m_ReadFile.ColumnAdd(new Column {
Name = "Proficiency", DataType = DataType.Numeric
});
m_ReadFile.ColumnAdd(new Column
{
Name = "IsNativeLang",
DataType = DataType.Boolean,
Ignore = true
});
ApplicationSetting.ToolSetting.Input.Add(m_ReadFile);
mimicReader.AddSetting(m_ReadFile);
m_WriteFile = new CsvFile();
m_WriteFile.ID = "Write";
m_WriteFile.SqlStatement = m_ReadFile.ID;
var add = new Column();
add.Name = "ExamDate";
add.DataType = DataType.DateTime;
add.DateFormat = @"MM/dd/yyyy";
add.TimePart = "ExamTime";
m_WriteFile.ColumnAdd(add);
m_WriteFile.ColumnAdd(new Column
{
Name = "Proficiency",
Ignore = true
});
}
public void DetermineColumnFormatFillGuessColumnFormatWriter()
{
var reader = new CsvFile
{
ID = "Reader",
FileName = Path.Combine(m_ApplicationDirectory, "BasicCSV.txt"),
HasFieldHeader = true
};
ApplicationSetting.ToolSetting.Input.Clear();
ApplicationSetting.ToolSetting.Input.Add(reader);
var mimic = new MimicSQLReader();
mimic.AddSetting(reader);
reader.FileFormat.FieldDelimiter = ",";
var writer = new CsvFile
{
SqlStatement = reader.ID
};
ApplicationSetting.ToolSetting.Output.Clear();
ApplicationSetting.ToolSetting.Output.Add(writer);
// setting.TreatTextNullAsNull = true;
ApplicationSetting.FillGuessSettings.IgnoreIdColums = false;
using (var processDisplay = new DummyProcessDisplay())
{
writer.FillGuessColumnFormatWriter(true, processDisplay.CancellationToken);
Assert.AreEqual(6, writer.Column.Count);
}
}
public void Init()
{
var m_ReadFile = new CsvFile
{
ID = "Read",
FileName = Path.Combine(m_ApplicationDirectory, "BasicCSV.txt")
};
var cf = m_ReadFile.ColumnAdd(new Column {
Name = "ExamDate", DataType = DataType.DateTime
});
cf.DateFormat = @"dd/MM/yyyy";
m_ReadFile.FileFormat.CommentLine = "#";
m_ReadFile.ColumnAdd(new Column {
Name = "Score", DataType = DataType.Integer
});
m_ReadFile.ColumnAdd(new Column {
Name = "Proficiency", DataType = DataType.Numeric
});
m_ReadFile.ColumnAdd(new Column
{
Name = "IsNativeLang",
DataType = DataType.Boolean,
Ignore = true
});
mimicReader.AddSetting(m_ReadFile);
ApplicationSetting.ToolSetting.Input.Clear();
ApplicationSetting.ToolSetting.Input.Add(m_ReadFile);
}