public static async Task WriteReport(SqlExportArguments args, string content) { if (!String.IsNullOrEmpty(args.OutputDirectory)) { await WriteToFile(args.OutputDirectory, content, args.Name); } else { await WriteToBlob(args.DestinationContainer, content, args.Name); } }
public override bool Init(IDictionary <string, string> jobArgsDictionary) { _args = new SqlExportArguments(jobArgsDictionary, "ng-search-data", "owners.json"); return(true); }
public static void TraceSqlExportArguments(SqlExportArguments args) { Trace.TraceInformation(String.Format("Generating Curated feed report from {0}.", TracableConnectionString(args.ConnectionString))); }
public static async Task<bool> RunSqlExport(SqlExportArguments args, string sql, string col0, string col1) { JobHelper.TraceSqlExportArguments(args); using (SqlConnection connection = new SqlConnection(args.ConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sql, connection); command.CommandType = CommandType.Text; JArray result = JobHelper.SqlDataReader2Json(command.ExecuteReader(), col0, col1); await JobHelper.WriteReport(args, result.ToString(Formatting.None)); } return true; }
public override bool Init(IDictionary<string, string> jobArgsDictionary) { _args = new SqlExportArguments(jobArgsDictionary, "ng-search-data", "owners.json"); return true; }