public async Task QuerySingleAsync_ReturnsSingleIdCorrectly() { // Arrange var id = Guid.NewGuid().ToString(); var dummies = new List <Dummy> { new Dummy { Id = id, Name = "Nick" }, new Dummy { Id = Guid.NewGuid().ToString(), Name = "John" } }; var dataSource = dummies.AsQueryable(); var expected = dataSource.Where(x => x.Name == "Nick").Select(x => x.Id); var sql = "select value c.id from c where c.Name = 'Nick'"; var entityStore = MockHelpers.ResponseSetupForQuery(sql, null, expected, dataSource, ref _mockDocumentClient); // Act var result = await entityStore.QuerySingleAsync <string>("select value c.id from c where c.Name = 'Nick'"); //Assert result.Should().Be(id); }
public async Task QueryMultipleAsyncReturnsIdAsStringCorrectly() { // Arrange var ids = new[] { Guid.NewGuid().ToString(), Guid.NewGuid().ToString() }; var dummies = new List <Dummy> { new Dummy { Id = ids[0], Name = "Nick" }, new Dummy { Id = ids[1], Name = "John" } }; var dataSource = dummies.AsQueryable(); var expected = dataSource.Select(x => x.Id); var entityStore = MockHelpers.ResponseSetupForQuery("select value c.id from c", null, expected, dataSource, ref _mockDocumentClient); // Act var result = await entityStore.QueryMultipleAsync <string>("select value c.id from c"); //Assert result.Should().BeEquivalentTo(ids); }
public async Task QueryMultipleAsyncReturnsCorrectItems() { // Arrange var dummies = new List <Dummy> { new Dummy { Id = Guid.NewGuid().ToString(), Name = "Nick" }, new Dummy { Id = Guid.NewGuid().ToString(), Name = "John" } }; var dataSource = dummies.AsQueryable(); var entityStore = MockHelpers.ResponseSetupForQuery("select * from c", null, dataSource, dataSource, ref _mockDocumentClient); // Act var result = (await entityStore.QueryMultipleAsync("select * from c")).ToList(); //Assert result.Count.Should().Be(2); result.Should().BeEquivalentTo(dummies); }
public async Task QuerySingleAsync_ReturnsCorrectItem() { // Arrange var nickDummy = new Dummy { Id = Guid.NewGuid().ToString(), Name = "Nick" }; var dummies = new List <Dummy> { nickDummy, new Dummy { Id = Guid.NewGuid().ToString(), Name = "John" } }; var dataSource = dummies.AsQueryable(); var expected = dataSource.Where(x => x.Name == "Nick"); var entityStore = MockHelpers.ResponseSetupForQuery("select top 1 * from c where c.Name = 'Nick'", null, expected, dataSource, ref _mockDocumentClient); // Act var result = await entityStore.QuerySingleAsync("select top 1 * from c where c.Name = 'Nick'"); //Assert result.Should().BeEquivalentTo(nickDummy); }