public void TestShopHierarchicalFilterWithIncludeOk(int shopKey, string districtManagerId, string stockName)
{
//SETUP
var options = SqliteInMemory.CreateOptions <MultiTenantDbContext>();
using (var context =
new MultiTenantDbContext(options, new MockGetClaimsProvider("user-id", 0, "manager-id")))
{
context.Database.EnsureCreated();
var mUser = new MultiTenantUser
{
UserId = "manager-id",
IsDistrictManager = true
};
var shop1 = new Shop {
Name = "shop1", DistrictManager = mUser
};
var shop2 = new Shop {
Name = "shop2"
};
context.AddRange(shop1, shop2);
context.SaveChanges();
var stock1 = new StockInfo
{
Name = shop1.Name, NumInStock = 10, AtShop = shop1, DistrictManagerId = shop1.DistrictManagerId
};
var stock2 = new StockInfo
{
Name = shop2.Name, NumInStock = 10, AtShop = shop2, DistrictManagerId = shop2.DistrictManagerId
};
context.AddRange(stock1, stock2);
context.SaveChanges();
}
using (var context = new MultiTenantDbContext(options, new MockGetClaimsProvider("user-id", shopKey, districtManagerId)))
{
//ATTEMPT
var filtered = context.CurrentStock.Include(x => x.AtShop).ToList();
//VERIFY
filtered.Count.ShouldEqual(1);
filtered.Single().Name.ShouldEqual(stockName);
}
}
private static void SetupStockInShops(this MultiTenantDbContext context, IEnumerable <Shop> shops)
{
foreach (var shop in shops)
{
var stock1 = new StockInfo {
Name = $"{shop.Name} nice stuff", NumInStock = 10, AtShop = shop, DistrictManagerId = shop.DistrictManagerId
};
var stock2 = new StockInfo {
Name = $"{shop.Name} other stuff", NumInStock = 22, AtShop = shop, DistrictManagerId = shop.DistrictManagerId
};
var stock3 = new StockInfo {
Name = $"{shop.Name} thingy", NumInStock = 3, AtShop = shop, DistrictManagerId = shop.DistrictManagerId
};
context.AddRange(stock1, stock2, stock3);
}
}
public void TestCreateValidDatabaseOk()
{
//SETUP
var options = SqliteInMemory.CreateOptions <MultiTenantDbContext>();
using (var context = new MultiTenantDbContext(options, new MockGetClaimsProvider("user-id", 0, null)))
{
context.Database.EnsureCreated();
//ATTEMPT
var shop1 = new Shop {
Name = "Test1"
};
var shop2 = new Shop {
Name = "Test2"
};
context.AddRange(shop1, shop2);
context.SaveChanges();
//VERIFY
context.Shops.IgnoreQueryFilters().Count().ShouldEqual(2);
}
}
