private void RunAllScriptFilesFor(SqlTableSelect table)
{
IEnumerator<SqlScript> scriptEnumerator = _sqlScriptFileStrategy.GetEnumeratorFor(table.TableName);
while (scriptEnumerator.MoveNext())
{
var script = scriptEnumerator.Current;
ExecuteScriptIfNotEmpty(script);
}
}
private void GenerateCsv(SqlTableSelect table)
{
_logger.Log(" " + table.TableName);
var select = _selectionFilteringStrategy.GetFilteredSelectStatement(table);
DataTable results =
_queryExecutor.ExecuteSelectStatement(select);
foreach (var column in table.ExcludedColumns)
{
results.Columns.Remove(column);
}
var csvOptions = new CsvOptions(DontCare, ',', results.Columns.Count) {DateFormat = "g"};
CsvEngine.DataTableToCsv(results, _destinationDirectory + table.TableName.ToLower() + ".csv", csvOptions);
}
public string GetFilteredSelectStatement(SqlTableSelect table)
{
return "select * from " + table.TableName;
}
public string GetFilteredSelectStatement(SqlTableSelect table)
{
return !String.IsNullOrWhiteSpace(table.Select ) ? table.Select : "select * from " + table.TableName;
}
