public void Export(string itemPath, CremaDataSet dataSet)
{
if (!dataSet.Tables.Any())
{
return;
}
var settings = this.Settings as CsvExporterSettings;
if (settings == null)
{
throw new NullReferenceException(nameof(settings));
}
var spreadCsvWriterSettings = new SpreadsheetCsvWriterSettings
{
OmitAttribute = settings.OmitAttribute,
OmitSignatureDate = settings.OmitSignatureDate,
CategorySeperatorString = settings.CategorySeperatorString,
Delimiter = settings.Delimiter,
Extension = settings.Extension,
FilenamePattern = settings.FilenamePattern,
CreateDirectoryIfNotExists = settings.CreateDirectoryIfNotExists
};
var writer = new SpreadsheetCsvWriter(dataSet, spreadCsvWriterSettings);
foreach (var outputPath in this.OutputPaths)
{
var filePath = Path.Combine(outputPath, spreadCsvWriterSettings.FilenamePattern);
writer.Write(filePath);
}
this.configs.Commit(this.Settings);
this.configs.Commit(this);
}
public void WriteCsvTest(string databaseName, string userId, string tableName, string childTableName)
{
// given
var(authentication, dataBase) = this.fixture.InitDataBaseAndUser(databaseName, userId);
CreateTableTemplate(tableName, dataBase, authentication);
AddChildTableData(tableName, childTableName, dataBase, authentication);
AddTableData(tableName, childTableName, dataBase, authentication);
// when
var dataSet = dataBase.Dispatcher.Invoke(() => dataBase.TableContext.Tables[tableName].GetDataSet(authentication, -1));
var writer = new SpreadsheetCsvWriter(dataSet, new SpreadsheetCsvWriterSettings
{
OmitAttribute = false,
});
writer.Write(".\\test-{categoryName}{name}{extension}");
}
