public async Task CRUDGlobalAsync()
{
var query = new MetricQueryableFactory <DynamicTableEntity>().Create((string)null);
var hasRows = (await query.GetAsync(_JournalTableName, 1)).Results.Count > 0;
if (hasRows)
{
var allRows = await query.GetAsync(_JournalTableName);
foreach (var row in allRows.Results)
{
await _Journal.DeleteAsync(new Identifier( row.RowKey, row.PartitionKey));
}
}
//Create
await InsertByPartitionsAsync(_PartitionKeys, _RowKeys, _Journal);
//Read 1
var rows = await query.GetAsync(_JournalTableName, null, new QueryFilter("PartitionKey", "A"), new QueryFilter("RowKey", "01"));
Assert.IsTrue(rows.Results.Count == 1, "Wrong number of rows returned - 1");
//Read 2
var rows2 = await query.GetAsync(_JournalTableName, null, new QueryFilter("RowKey", "01"));
Assert.IsTrue(rows2.Results.Count == _PartitionKeys.Length, "Wrong number of rows returned - 2");
//Read 2.5
var rows25 = await query.GetAsync(_JournalTableName, 1, new QueryFilter("RowKey", "01"));
Assert.IsTrue(rows25.Results.Count == 1, "Wrong number of rows returned - 2.5");
//Read 3
var rows3 = await query.GetAsync(_JournalTableName, null, new QueryFilter("PartitionKey", "A"));
Assert.IsTrue(rows3.Results.Count == _RowKeys.Length, "Wrong number of rows returned - 3");
//Delete
await DeleteByPartitionsAsync(_PartitionKeys, _RowKeys, _Journal);
}
public async Task TestQueryGlobalAsync()
{
var query = new MetricQueryableFactory <DynamicTableEntity>().Create((string)null);
var hasRows = (await query.GetAsync(_JournalTableName, 1)).Results.Count > 0;
if (hasRows)
{
var allRows = await query.GetAsync(_JournalTableName);
foreach (var row in allRows.Results)
{
await _Journal.DeleteAsync(new Identifier(row.RowKey, row.PartitionKey));
}
}
//Create
await InsertByPartitionsAsync(_PartitionKeys, _RowKeys, _Journal);
//Read
var rows = await query.GetAsync(_JournalTableName, 1,
new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("PartitionKey", "A"), QueryComparisons.Equal),
new QueryFilterCondition(new QueryFilter("RowKey", "01"), QueryComparisons.Equal) }, TableOperators.And);
Assert.IsTrue(rows.Results.Count == 1, "Wrong number of rows returned");
//Read all but 1
var rowsA = await query.GetAsync(_JournalTableName, null,
new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("PartitionKey", "A"), QueryComparisons.NotEqual),
new QueryFilterCondition(new QueryFilter("RowKey", "01"), QueryComparisons.NotEqual) }, TableOperators.And);
int count = rowsA.Results.Count;
Assert.IsTrue(rowsA.Results.Count == ((_PartitionKeys.Length - 1) * (_RowKeys.Length - 1)), "Wrong number of rows returned");
//Read all but 1
var rowsB = await query.GetAsync(_JournalTableName, null,
new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("PartitionKey", "A"), QueryComparisons.NotEqual),
new QueryFilterCondition(new QueryFilter("RowKey", "01"), QueryComparisons.NotEqual) }, TableOperators.Or);
Assert.IsTrue(rowsB.Results.Count == ((_PartitionKeys.Length) * (_RowKeys.Length)) - 1, "Wrong number of rows returned");
//Read all but 1
var rowsC = await query.GetAsync(_JournalTableName, null,
new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("PartitionKey", "A"), QueryComparisons.NotEqual),
new QueryFilterCondition(new QueryFilter("RowKey", "01"), QueryComparisons.NotEqual),
new QueryFilterCondition(new QueryFilter("RowKey", "10"), QueryComparisons.LessThan) }, TableOperators.Or, TableOperators.And);
Assert.IsTrue(rowsC.Results.Count == ((_PartitionKeys.Length) * (_RowKeys.Length)) - 1, "Wrong number of rows returned");
//Read
var rows2 = await query.GetAsync(_JournalTableName, null,
new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("RowKey", "01"), QueryComparisons.Equal) });
Assert.IsTrue(rows2.Results.Count == _PartitionKeys.Length, "Wrong number of rows returned");
//Read
var rows2A = await query.GetAsync(_JournalTableName, null, "RowKey eq '01'");
Assert.IsTrue(rows2A.Results.Count == _PartitionKeys.Length, "Wrong number of rows returned");
//Read
var rows3 = await query.GetAsync(_JournalTableName, null, new QueryFilterCondition[] { new QueryFilterCondition(new QueryFilter("PartitionKey", "A"), QueryComparisons.Equal) });
Assert.IsTrue(rows3.Results.Count == _RowKeys.Length, "Wrong number of rows returned");
//Update
await InsertByPartitionsAsync(_PartitionKeys, _RowKeys, _Journal);
//Delete
await DeleteByPartitionsAsync(_PartitionKeys, _RowKeys, _Journal);
}