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