public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
ILogger log)
{
log.LogInformation("C# HTTP trigger function processed a request.");
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject(requestBody);
string[] targetsarr = data?.data.essentials.alertTargetIDs.ToObject <string[]>();
string[] targetsplit = targetsarr[0].ToString().Split(new string("/"), StringSplitOptions.RemoveEmptyEntries);
string resourcegroup = targetsplit[3];
string sqlsrv = targetsplit[7];
string database = targetsplit[(targetsplit.Length - 1)];
log.LogInformation("Delete Database:");
log.LogInformation("ResourceGroup:" + resourcegroup);
log.LogInformation("SQLServer:" + sqlsrv);
log.LogInformation("Database:" + database);
AzSQL sqlclass = new AzSQL();
bool deleteresult = await sqlclass.DeleteDatabase(sqlsrv, database);
log.LogInformation("State:" + deleteresult);
string state = "executed";
return((ActionResult) new OkObjectResult(state));
}
public static async void Run([TimerTrigger("0 */2 * * * *")] TimerInfo myTimer, ILogger log)
{
log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
log.LogInformation($"Execute function AddDB");
List <DatabaseModel> entriesfromazure = new List <DatabaseModel>();
AzureClass azurec = new AzureClass();
entriesfromazure = await azurec.getazressources();
List <DatabaseModel> entriesfromdb = new List <DatabaseModel>();
AzSQL sqlc = new AzSQL();
entriesfromdb = await sqlc.GetDatabase();
//Check database for old entries
foreach (DatabaseModel item in entriesfromdb)
{
if (entriesfromazure.Contains(item))
{
}
else
{
}
}
}
