Esempio n. 1
0
        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"));
        }
Esempio n. 2
0
        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"));
        }