public void TestSimpleRangeAboveQuery()
{
var dbTable = DbTable.CreateByRequest("myTable");
for (var i = 0; i <= 100; i++)
{
var key = (i * 2).ToString("000");
var recordToInsert = new TestRecord
{
PartitionKey = "MyPartition",
RowKey = key,
TestField = key
};
var recordIsByteArray = recordToInsert.AsJsonByteArray().AsMyMemory();
var fields = recordIsByteArray.ParseFirstLevelOfJson();
dbTable.Insert(fields.GetEntityInfo(), fields);
}
var query = "PartitionKey eq 'MyPartition' and RowKey ge '199'";
var queryCondition = query.ParseQueryConditions();
var foundRecords = dbTable.ApplyQuery(queryCondition).ToArray();
Assert.Single(foundRecords);
Assert.Equal("200", foundRecords[0].GetValue("TestField"));
}
public void TestSimpleQuery()
{
var dbTable = DbTable.CreateByRequest("myTable");
var recordToInsert = new TestRecord
{
PartitionKey = "MyPartition",
RowKey = "MyRow",
TestField = "Test"
};
var recordIsByteArray = recordToInsert.AsJsonByteArray();
var fields = recordIsByteArray.AsMyMemory().ParseFirstLevelOfJson();
var entityInfo = fields.GetEntityInfo();
dbTable.Insert(entityInfo, fields);
var query = "PartitionKey eq 'MyPartition' and RowKey eq 'MyRow'";
var queryCondition = query.ParseQueryConditions();
var foundItems = dbTable.ApplyQuery(queryCondition).ToArray();
Assert.Equal(recordToInsert.TestField, foundItems.First().GetValue("TestField"));
}