public static EntityKey GetDateEntityKey(DateTimeOffset buildDate, BuildId buildId, string identifier)
{
identifier = AzureUtil.NormalizeKey(identifier, '_');
return(new EntityKey(
DateTimeKey.GetDateKey(buildDate),
$"{new BuildKey(buildId).Key}-{identifier}"));
}
private static async Task TestFailureYesterday(int days = -1)
{
var account = GetStorageAccount();
var tableClient = account.CreateCloudTableClient();
var table = tableClient.GetTableReference(TableNames.BuildState);
var date = DateTimeOffset.UtcNow.AddDays(days);
var query = TableQueryUtil.And(
TableQueryUtil.PartitionKey(DateTimeKey.GetDateKey(date)),
TableQueryUtil.Column(nameof(BuildStateEntity.IsBuildFinished), true),
TableQueryUtil.Column(nameof(BuildStateEntity.IsDataComplete), false));
var list = await AzureUtil.QueryAsync <BuildStateEntity>(table, query);
foreach (var entity in list)
{
var populator = new BuildTablePopulator(tableClient, CounterUtilFactory, CreateClient(entity.BoundBuildId), TextWriter.Null);
try
{
Console.Write($"{entity.BuildId} ... ");
await populator.PopulateBuild(entity.BoundBuildId);
Console.WriteLine("good");
}
catch (Exception ex)
{
Console.WriteLine("ERRROR");
Console.WriteLine(ex);
}
}
}
public List <string> GetViewNames(DateTimeOffset startDate)
{
var key = DateTimeKey.GetDateKey(startDate);
var filter = TableQueryUtil.PartitionKey(key, ColumnOperator.GreaterThanOrEqual);
var query = new TableQuery <ViewNameEntity>().Where(filter);
var viewNameList = _viewNameDateTable.ExecuteQuery(query);
var list = new List <string>();
list.Add(AzureUtil.ViewNameAll);
list.AddRange(viewNameList.Select(x => x.ViewName).Distinct());
return(list);
}
public async Task QuerySimple()
{
var date = DateTimeOffset.Parse("2016/01/02");
var key = DateTimeKey.GetDateKey(date);
var entity = new TestEntity()
{
PartitionKey = key,
RowKey = Guid.NewGuid().ToString("N"),
Count = 42
};
await Table.ExecuteAsync(TableOperation.Insert(entity));
var list = await CounterUtil.QueryAsync(date, date);
Assert.Equal(1, list.Count);
Assert.Equal(42, list[0].Count);
}
public static EntityKey GetDateEntityKey(DateTimeOffset buildDate, BuildId buildId)
{
return(new EntityKey(
DateTimeKey.GetDateKey(buildDate),
new BuildKey(buildId).Key));
}
private static string FilterSinceDate(DateTimeOffset startDate)
{
var key = DateTimeKey.GetDateKey(startDate);
return(TableQueryUtil.Column(ColumnName.PartitionKey, key, ColumnOperator.GreaterThanOrEqual));
}
