public static async Task RunAsync(
[TimerTrigger("0 */2 * * * *")] TimerInfo myTimer,
//[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "sites/state/import")] Microsoft.AspNetCore.Http.HttpRequest req,
[CosmosDB(ConnectionStringSetting = "CosmosDBConnectionString")] DocumentClient documentClient,
ILogger log)
{
log.LogInformation($"Sites State import starting at: {DateTime.Now}");
//Query all the old objects in the db
Uri collectionUri = UriFactory.CreateDocumentCollectionUri("parkingdb", "sitesstate");
IDocumentQuery <SiteState> query = documentClient.CreateDocumentQuery <SiteState>(collectionUri,
new FeedOptions()
{
PartitionKey = new PartitionKey(null)
})
.Where(x => x.RecordState != SiteState.EntityState.Deleted)
.AsDocumentQuery();
var oldSites = await query.ToDictionary(x => x.Id);
// return new ObjectResult(oldSites);
log.LogInformation($"Sites State import old records imported at: {DateTime.Now}");
var newSites = new List <SiteState>();
using (HttpResponseMessage res = await httpClient.GetAsync(parkingApiUrl))
{
using (HttpContent content = res.Content)
{
var lastUpdate = DateTime.UtcNow;
//Retrieve the values from the api
dynamic result = JsonConvert.DeserializeObject(await content.ReadAsStringAsync());
log.LogInformation($"Sites State import origin downloaded at: {DateTime.Now}. Total sites {result.Count}");
foreach (var item in result)
{
var newSite = new SiteState()
{
Id = item.bay_id.ToString(),
Status = item.status,
Location = new Point(
(double)item.location.longitude,
(double)item.location.latitude
),
RecordState = SiteState.EntityState.Created,
Ttl = -1
// LastUpdate = lastUpdate
};
SiteState oldSite;
//Replace the old values when they changed
if (!oldSites.TryGetValue(newSite.Id, out oldSite))
{
newSites.Add(newSite);
}
else
{
oldSites.Remove(newSite.Id);
if (oldSite.Status != newSite.Status) //|| !oldSite.Location.Equals(newSite.Location))
{
newSite.RecordState = SiteState.EntityState.Updated;
newSites.Add(newSite);
}
}
}
}
}
log.LogInformation($"Sites State import processed at: {DateTime.Now}. Sites to upsert {newSites.Count}. Sites to delete {oldSites.Count}");
// Do the update
foreach (var item in newSites)
{
await documentClient.UpsertDocumentAsync(collectionUri, item);
}
// Stablish a time to live if the bay was removed
foreach (var keyPair in oldSites)
{
keyPair.Value.RecordState = SiteState.EntityState.Deleted;
keyPair.Value.Ttl = 2000; // 2 seconds
await documentClient.UpsertDocumentAsync(collectionUri, keyPair.Value);
// await documentClient.DeleteDocumentAsync(
// UriFactory.CreateDocumentUri("parkingdb", "sitesstate", keyPair.Key),
// new RequestOptions() { PartitionKey = new PartitionKey(null) });
}
// return new NoContentResult();
}