public void InsertOrMergeGalleryEntry(GalleryEntry galleryEntry)
{
var yesterday = DateTime.Now.AddDays(-1);
var previousDayEntry = GetEntryByDayAsync(galleryEntry.Version.ToString(), yesterday).Result;
var entryToInsert = new TableEntryEntity(galleryEntry.Version.ToString());
if (previousDayEntry == null)
{
Console.WriteLine("Couldn't find entry for day [{0}]", yesterday.Date.ToString());
entryToInsert.VersionTotalToDate = galleryEntry.VersionDownloadCount;
entryToInsert.ModuleTotalToDate = galleryEntry.TotalModuleDownloadCount;
entryToInsert.VersionDayCount = 0;
}
else
{
entryToInsert.VersionTotalToDate = galleryEntry.VersionDownloadCount;
entryToInsert.ModuleTotalToDate = galleryEntry.TotalModuleDownloadCount;
entryToInsert.VersionDayCount = galleryEntry.VersionDownloadCount - previousDayEntry.VersionTotalToDate;
}
InsertOrMergeTableEntryAsync(entryToInsert).Wait();
}
private static async Task <TableEntryEntity> RetrieveEntityUsingPointQueryAsync(string partitionKey, string rowKey)
{
TableOperation retrieveOperation = TableOperation.Retrieve <TableEntryEntity>(partitionKey, rowKey);
TableResult result = await CloudTable.ExecuteAsync(retrieveOperation);
TableEntryEntity tableEntry = result.Result as TableEntryEntity;
if (tableEntry != null)
{
Console.WriteLine("Found table entry:\n[Version\\PartitionKey = {0}]\n[Date\\Rowkey = {1}]\n[ModuleTotalToDate = {2}]\n[VersionTotalToDate{3}\n[VersionDayCount = {4}]]", tableEntry.PartitionKey, tableEntry.RowKey, tableEntry.ModuleTotalToDate, tableEntry.VersionTotalToDate, tableEntry.VersionDayCount);
}
return(tableEntry);
}
private static async Task <TableEntryEntity> RetrieveEntityUsingPointQueryAsync(string partitionKey, string rowKey)
{
TableOperation retrieveOperation = TableOperation.Retrieve <TableEntryEntity>(partitionKey, rowKey);
TableResult result = await CloudTable.ExecuteAsync(retrieveOperation);
TableEntryEntity tableEntry = result.Result as TableEntryEntity;
if (tableEntry != null)
{
Console.WriteLine("Found table entry for [{0}] with [TotalToDate = {1}]", tableEntry.RowKey, tableEntry.VersionTotalToDate);
}
return(tableEntry);
}
private async Task <TableEntryEntity> InsertOrMergeTableEntryAsync(TableEntryEntity tableEntry)
{
if (tableEntry == null)
{
throw new ArgumentNullException("tableEntry");
}
// Create the InsertOrReplace TableOperation
TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(tableEntry);
// Execute the operation.
TableResult result = await CloudTable.ExecuteAsync(insertOrMergeOperation);
TableEntryEntity insertedTableEntry = result.Result as TableEntryEntity;
Console.WriteLine("Inserted/Updated table entry:\n\t[Version\\PartitionKey = {0}]\n\t[Date\\Rowkey = {1}]\n\t[ModuleTotalToDate = {2}]\n\t[VersionTotalToDate = {3}\n\t[VersionDayCount = {4}]", insertedTableEntry.PartitionKey, insertedTableEntry.RowKey, insertedTableEntry.ModuleTotalToDate, insertedTableEntry.VersionTotalToDate, insertedTableEntry.VersionDayCount);
return(insertedTableEntry);
}