public void Handler_ReturnsTrue_WhenFound_ByUserId()
{
var userId = FakeData.Id();
var otherUserId1 = FakeData.Id(userId);
var otherUserId2 = FakeData.Id(userId, otherUserId1);
var user = new ProxiedUser(userId);
var otherUser1 = new ProxiedUser(otherUserId1);
var otherUser2 = new ProxiedUser(otherUserId2);
var localMemberships = new[]
{
new LocalMembership { User = otherUser1, },
new LocalMembership { User = user, },
new LocalMembership { User = otherUser2, },
};
var data = localMemberships.AsQueryable();
var query = new UserHasLocalMembership(user.Id);
var dbSet = new Mock<DbSet<LocalMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<LocalMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<LocalMembership>()).Returns(entitySet);
var handler = new HandleUserHasLocalMembershipQuery(entities.Object);
bool result = handler.Handle(query).Result;
result.ShouldBeTrue();
entities.Verify(x => x.Query<LocalMembership>(), Times.Once);
}
public void Handler_ReturnsRemoteMembershipViews_WhenFound_ByUserId()
{
var userId = FakeData.Id();
var otherUserId1 = FakeData.Id(userId);
var otherUserId2 = FakeData.Id(userId, otherUserId1);
var remoteMemberships = new[]
{
new ProxiedRemoteMembership(FakeData.String(), FakeData.String())
{ UserId = otherUserId1, },
new ProxiedRemoteMembership(FakeData.String(), FakeData.String())
{ UserId = otherUserId2, },
new ProxiedRemoteMembership(FakeData.String(), FakeData.String())
{ UserId = userId, },
};
var data = remoteMemberships.AsQueryable();
var query = new RemoteMembershipViewsBy(userId);
var dbSet = new Mock<DbSet<RemoteMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<RemoteMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<RemoteMembership>()).Returns(entitySet);
var handler = new HandleRemoteMembershipViewsByQuery(entities.Object);
RemoteMembershipView[] results = handler.Handle(query).Result.ToArray();
results.ShouldNotBeNull();
results.Length.ShouldEqual(1);
RemoteMembershipView result = results.Single();
var expectedEntity = data.Single(x => x.UserId == userId);
result.UserId.ShouldEqual(expectedEntity.UserId);
result.Provider.ShouldEqual(expectedEntity.LoginProvider);
result.Key.ShouldEqual(expectedEntity.ProviderKey);
entities.Verify(x => x.Query<RemoteMembership>(), Times.Once);
}
public void Handler_ReturnsRemoteMemberships_WhenFound_ByUserId()
{
var userId = FakeData.Id();
var otherUserId1 = FakeData.Id(userId);
var otherUserId2 = FakeData.Id(userId, otherUserId1);
var remoteMemberships = new[]
{
new RemoteMembership { UserId = otherUserId1, },
new RemoteMembership { UserId = otherUserId2, },
new RemoteMembership { UserId = userId, },
new RemoteMembership { UserId = userId, },
};
var data = remoteMemberships.AsQueryable();
var query = new RemoteMembershipsByUser(userId);
var dbSet = new Mock<DbSet<RemoteMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<RemoteMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<RemoteMembership>()).Returns(entitySet);
var handler = new HandleRemoteMembershipsByUserQuery(entities.Object);
RemoteMembership[] result = handler.Handle(query).Result.ToArray();
result.ShouldNotBeNull();
result.Length.ShouldEqual(2);
var expectedResults = data.Where(x => x.UserId == userId);
result.ShouldContain(expectedResults.First());
result.ShouldContain(expectedResults.Skip(1).First());
entities.Verify(x => x.Query<RemoteMembership>(), Times.Once);
}
public void Test3()
{
var records = new[]
{
new Product("A", 1),
new Product("A", 2)
};
var queryable = records.AsQueryable() as IQueryable;
var results = queryable
.GroupBy("new ( Name )", "it")
.Select("new ( Key.Name AS ProductName, SUM(Quantity) as Total )");
}
public void Handler_ReturnsFalse_WhenNotFound_ByUserName()
{
var userName = FakeData.String();
var user = new User { Name = userName, };
var otherUser1 = new User { Name = FakeData.String(), };
var otherUser2 = new User { Name = FakeData.String(), };
var localMemberships = new[]
{
new LocalMembership { User = otherUser1, },
new LocalMembership { User = otherUser2, },
};
var data = localMemberships.AsQueryable();
var query = new UserHasLocalMembership(user.Name);
var dbSet = new Mock<DbSet<LocalMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<LocalMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<LocalMembership>()).Returns(entitySet);
var handler = new HandleUserHasLocalMembershipQuery(entities.Object);
bool result = handler.Handle(query).Result;
result.ShouldBeFalse();
entities.Verify(x => x.Query<LocalMembership>(), Times.Once);
}
public void Handler_ReturnsTrue_WhenFound_ByPrincipal()
{
var userId = FakeData.Id();
var otherUserId1 = FakeData.Id(userId);
var otherUserId2 = FakeData.Id(userId, otherUserId1);
var user = new ProxiedUser(userId) { Name = FakeData.String(), };
var otherUser1 = new ProxiedUser(otherUserId1) { Name = FakeData.String(), };
var otherUser2 = new ProxiedUser(otherUserId2) { Name = FakeData.String(), };
var localMemberships = new[]
{
new LocalMembership { User = otherUser1, },
new LocalMembership { User = user, },
new LocalMembership { User = otherUser2, },
};
var identity = new ClaimsIdentity(new[]
{
new Claim(ClaimTypes.NameIdentifier, user.Id.ToString(CultureInfo.InvariantCulture)),
});
var principal = new GenericPrincipal(identity, null);
var data = localMemberships.AsQueryable();
var query = new UserHasLocalMembership(principal);
var dbSet = new Mock<DbSet<LocalMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<LocalMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<LocalMembership>()).Returns(entitySet);
var handler = new HandleUserHasLocalMembershipQuery(entities.Object);
bool result = handler.Handle(query).Result;
result.ShouldBeTrue();
entities.Verify(x => x.Query<LocalMembership>(), Times.Once);
}
public void Handler_ReturnsNoRemoteMemberships_WhenNotFound_ByUserName()
{
var userName = FakeData.String();
var otherUser1 = new User { Name = FakeData.String(), };
var otherUser2 = new User { Name = FakeData.String(), };
var remoteMemberships = new[]
{
new RemoteMembership { User = otherUser1, },
new RemoteMembership { User = otherUser2, },
};
var data = remoteMemberships.AsQueryable();
var query = new RemoteMembershipsByUser(userName);
var dbSet = new Mock<DbSet<RemoteMembership>>(MockBehavior.Strict).SetupDataAsync(data);
var entities = new Mock<IReadEntities>(MockBehavior.Strict);
var entitySet = new EntitySet<RemoteMembership>(dbSet.Object, entities.Object);
entities.Setup(x => x.Query<RemoteMembership>()).Returns(entitySet);
var handler = new HandleRemoteMembershipsByUserQuery(entities.Object);
RemoteMembership[] result = handler.Handle(query).Result.ToArray();
result.ShouldNotBeNull();
result.Length.ShouldEqual(0);
entities.Verify(x => x.Query<RemoteMembership>(), Times.Once);
}