public async void CancelJobTest()
{
AzureSqlJobCredentials creds = new AzureSqlJobCredentials()
{
DatabaseName = "edjb0d1a0ab363747abbc2ee",
Password = "******",
ServerName = "edjb0d1a0ab363747abbc2ee.database.windows.net",
Username = "******"
};
var elasticJobs = CreateAzureSqlJobClient(creds);
var id = Guid.Parse("549DF45D-112B-4998-9AB2-03DDD7BE1D96");
var children = await elasticJobs.JobExecutions
.ListJobExecutionsAsync(new JobExecutionFilter()
{
ParentJobExecutionId = id
});
foreach (var jobExecutionInfo in children)
{
await elasticJobs.JobExecutions.CancelJobExecutionAsync(jobExecutionInfo.JobExecutionId);
}
await elasticJobs.JobExecutions.CancelJobExecutionAsync(id);
}
public async void TestJobExecutionTaskList()
{
AzureSqlJobCredentials creds = new AzureSqlJobCredentials()
{
DatabaseName = "edjb0d1a0ab363747abbc2ee",
Password = "******",
ServerName = "edjb0d1a0ab363747abbc2ee.database.windows.net",
Username = "******"
};
JobStatHelper helper = new JobStatHelper(creds);
var name = "Apply DACPAC 0-7-8298f0c72525-2414-master 42adfc7b-282e-4207-9470-80459c2e78d5";
var l = helper.GetChilderJobExecutionStat(name);
var s = l.Select(x => x.Lifecycle + " " + x.Count).JoinString("\n");
Debug.WriteLine(s);
/*var te = helper.GetJobTaskExecutions(name, null, null);
* foreach (var jobTaskExecution in te)
* {
* Debug.WriteLine(jobTaskExecution.EndTime.ToString() + " " + jobTaskExecution.Message);
* }*/
}
public async void CancelPrivateJobsInProgress()
{
AzureSqlJobCredentials creds = new AzureSqlJobCredentials()
{
DatabaseName = "edjb0d1a0ab363747abbc2ee",
Password = "******",
ServerName = "edjb0d1a0ab363747abbc2ee.database.windows.net",
Username = "******"
};
var elasticJobs = CreateAzureSqlJobClient(creds);
var list = await elasticJobs.Jobs.ListJobsAsync();
var privateJobs = list.Where(x => x.JobName.Contains("private-build")).ToList();
foreach (var job in privateJobs)
{
Console.WriteLine($"Job: {job}");
var executions = await elasticJobs.JobExecutions.ListJobExecutionsAsync(new JobExecutionFilter
{
JobName = job.JobName
});
foreach (var execution in executions)
{
Console.WriteLine($"Execution: {execution}, status {execution.Lifecycle}");
await elasticJobs.JobExecutions.CancelJobExecutionAsync(execution.JobExecutionId);
Console.WriteLine($"Cancelled {execution.JobExecutionId}");
}
}
}
public async void ListPrivateJobsInProgress()
{
AzureSqlJobCredentials creds = new AzureSqlJobCredentials()
{
DatabaseName = "edjb0d1a0ab363747abbc2ee",
Password = "******",
ServerName = "edjb0d1a0ab363747abbc2ee.database.windows.net",
Username = "******"
};
var elasticJobs = CreateAzureSqlJobClient(creds);
var list = await elasticJobs.Jobs.ListJobsAsync();
var privateJobs = list.ToList();
foreach (var job in privateJobs)
{
//Console.WriteLine($"Job: {job}");
var executions = await elasticJobs.JobExecutions.ListJobExecutionsAsync(new JobExecutionFilter
{
JobName = job.JobName
});
foreach (var execution in executions)
{
if (!(execution.Lifecycle == JobExecutionLifecycle.InProgress || execution.Lifecycle == JobExecutionLifecycle.WaitingForChildJobExecutions))
{
continue;
}
Console.WriteLine($"Execution: {execution} of {job}, status {execution.Lifecycle}");
var children = await elasticJobs.JobExecutions.ListJobExecutionsAsync(new JobExecutionFilter
{
ParentJobExecutionId = execution.JobExecutionId
});
/*foreach (var child in children)
* {
* Console.WriteLine($"Execution child: {child}, status {child.Lifecycle}");
*
* var tasks = await elasticJobs.JobTaskExecutions.ListJobTaskExecutions(child.JobExecutionId);
*
* foreach (var task in tasks)
* {
* Console.WriteLine($"Execution child task: {task}, status {task.Lifecycle}, {task.Message}");
*
* var scripts =
* await
* elasticJobs.ScriptBatchExecutions.ListScriptBatchExecutions(task.JobTaskExecutionId);
* foreach (var script in scripts)
* {
* Console.WriteLine($"Execution child task script: {script}, status {script.Lifecycle}, {script.Message}");
* }
* }
* }*/
}
}
}
private static AzureSqlJobClient CreateAzureSqlJobClient(AzureSqlJobCredentials creds)
{
var securePassword = new SecureString();
foreach (var ch in creds.Password)
{
securePassword.AppendChar(ch);
}
securePassword.MakeReadOnly();
var connection = new AzureSqlJobConnection(creds.ServerName, creds.DatabaseName, creds.Username, securePassword);
return(new AzureSqlJobClient(connection));
}
public void Test()
{
AzureSqlJobCredentials creds = new AzureSqlJobCredentials()
{
DatabaseName = "edjb0d1a0ab363747abbc2ee",
Password = "******",
ServerName = "edjb0d1a0ab363747abbc2ee.database.windows.net",
Username = "******"
};
var id = Guid.NewGuid();
Debug.WriteLine(id);
BackgroundTaskService.BackgroundTaskLog log = new BackgroundTaskService.BackgroundTaskLog(id, 1);
var data = DatabaseDacPacUpdateTaskData.FromString("{\"DacPacName\":\"0-7-1d38ca879106-2321\",\"MasterDacPacUri\":\"https://chalkablestat.blob.core.windows.net/artifacts-db/0-7-1d38ca879106-2321/Chalkable.Database.Master.dacpac\",\"SchoolDacPacUri\":\"https://chalkablestat.blob.core.windows.net/artifacts-db/0-7-1d38ca879106-2321/Chalkable.Database.School.dacpac\",\"ServerName\":\"edjb0d1a0ab363747abbc2ee.database.windows.net\",\"DatabaseName\":\"edjb0d1a0ab363747abbc2ee\",\"Username\":\"chalkadmin@edjb0d1a0ab363747abbc2ee\",\"Password\":\"Hellowebapps1!\"}");
DatabaseDacPacUpdateTaskHandler.Test(creds, log, data).Wait();
}
