public async void GetFirstOrDefaultAsync_Poco_WithCql() { // Get random first or default user and verify they are same as user from test data var user = await CqlClient.FirstOrDefaultAsync <PlainUser>("SELECT * FROM users"); user.ShouldBeEquivalentTo(TestDataHelper.Users.Single(u => u.UserId == user.UserId), opt => opt.AccountForTimestampAccuracy()); // Get first or default where user id doesn't exist and make sure we get null var notExistingUser = await CqlClient.FirstOrDefaultAsync <PlainUser>("SELECT * FROM users WHERE userid = ?", Guid.Empty); notExistingUser.Should().BeNull(); }
public async void GetFirstOrDefaultAsync_OneColumnFlattened_WithCql() { // Get random first or default name and make sure it was one from our test data var name = await CqlClient.FirstOrDefaultAsync <string>("SELECT name FROM users"); TestDataHelper.Users.Select(u => u.Name).Should().Contain(name); // Get random first or default login history for user that does not exist and make sure we get null var loginHistory = await CqlClient.FirstOrDefaultAsync <List <DateTimeOffset> >("SELECT loginhistory FROM users WHERE userid = ?", Guid.Empty); loginHistory.Should().BeNull(); }