public async static Task Run([TimerTrigger("0 0 4-23 * * *")] TimerInfo myTimer, ILogger log)
{
log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
string str = Environment.GetEnvironmentVariable("sqldb_connectionstring");
using SqlConnection conn = new SqlConnection(str);
conn.Open();
List <LegoSet> updatedSets = DbUtils.GetSetsWithEmailToSend(conn);
List <Subscription> subscriptions = DbUtils.GetActiveSubscriptions(conn);
Dictionary <(int number, bool isBigUpdate), MailMessage> messages = MessageCreator.GetMessagesForUpdatedSets(updatedSets);
await EmailSender.SendEmails(subscriptions, messages);
DbUtils.UpdateSetsAfterSendingEmails(conn, updatedSets);
}
