public void Test_stores_geo()
{
var data = new LcboDataSource();
var q = data.Stores.Where(o => o.Geolocation == "spadina");
Assert.AreEqual("stores?geo=spadina", GetQuery(q));
}
public void Test_multi_clause_where()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.SearchQuery == "Scotch" && o.IsDead);
Assert.AreEqual("products?q=Scotch&where=is_dead", GetQuery(q));
}
public void Test_product_inventories()
{
var data = new LcboDataSource();
var q = data.Inventories.Where(o => o.ProductId == 18);
Assert.AreEqual("products/18/inventories", GetQuery(q));
}
public void Test_where_and_orderby()
{
var data = new LcboDataSource();
var q = data.Inventories.Where(o => o.IsDead == true).OrderBy(o => o.Quantity);
Assert.AreEqual("inventories?where=is_dead&order=quantity.asc", GetQuery(q));
}
public void Test_stores_searchQuery()
{
var data = new LcboDataSource();
var q = data.Stores.Where(o => o.SearchQuery == "spadina");
Assert.AreEqual("stores?q=spadina", GetQuery(q));
}
public void Test_stores_signle()
{
var data = new LcboDataSource();
Store store = data.Stores.Single(o => o.Id == 511);
Assert.AreEqual(511, store.Id);
}
public void Test_stores_with_multi_where()
{
var data = new LcboDataSource();
var q = data.Stores.Where(o => o.Geolocation == "spadina" && o.SearchQuery == "king");
Assert.AreEqual("stores?q=king&geo=spadina", GetQuery(q));
}
public void Test_bool_where()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.IsDead);
Assert.AreEqual("products?where=is_dead", GetQuery(q));
}
public void Test_multi_clause_orderby()
{
var data = new LcboDataSource();
var q = data.Products.OrderBy(o => o.Id).ThenBy(o => o.Price).ThenByDescending(o => o.ReleasedDate);
Assert.AreEqual("products?order=id.asc,price_in_cents.asc,released_on.desc", GetQuery(q));
}
public void Test_inventories_in_product()
{
var data = new LcboDataSource();
Product product = data.Products.Single(o => o.Id == 18);
var q = product.Inventories;
Assert.AreEqual("products/18/inventories", GetQuery(q));
}
public void Test_single()
{
var data = new LcboDataSource();
Inventory inventory = data.Inventories.Single(o => o.StoreId == 511 && o.ProductId == 18);
Assert.IsTrue(inventory.ProductId == 18);
Assert.IsTrue(inventory.StoreId == 511);
}
public void Test_stores_with_product()
{
var data = new LcboDataSource();
data.Stores.Where(o => o.ProductId == 10 && o.Geolocation == "spadina");
var q = data.Stores.Where(o => o.ProductId == 18);
Assert.AreEqual("products/18/stores", GetQuery(q));
}
public void Test_whhere_then_single()
{
var data = new LcboDataSource();
var inventory = (from i in data.Inventories
where i.ProductId == 18 && i.StoreId == 511
select i).Single();
Assert.AreEqual("stores/511/products/18/inventory", GetQuery(q));
}
public void Test_enumerator()
{
var data = new LcboDataSource();
var products = data.Products.Where(o => !o.IsDead && o.SearchQuery == "heineken");
foreach (var p in products)
{
Assert.AreEqual("Heineken", p.Name);
break;
}
}
public void Test_singleOrDefault()
{
var data = new LcboDataSource();
Product p = data.Products.SingleOrDefault(o => o.Id == 1800000);
Assert.IsNull(p);
}
public void Test_single_with_exception()
{
var data = new LcboDataSource();
Product p = data.Products.Single(o => o.Id == 1800000);
}
public void Test_take_and_skip()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.SearchQuery == "heineken").Take(10).Skip(2);
Assert.AreEqual("products?q=heineken&per_page=10&page=2", GetQuery(q));
}
public void Test_toList()
{
var data = new LcboDataSource();
var products = data.Products.Where(o => !o.IsDead && !o.IsVqa && o.SearchQuery == "heineken").ToList();
Assert.AreEqual("Heineken", products.First().Name);
}
public void Test_single_throws()
{
var data = new LcboDataSource();
data.Inventories.Single(o => o.StoreId == 1);
}
public void Test_where_then_single()
{
var data = new LcboDataSource();
Product heineken = (from p in data.Products
where p.Id == 18
select p).Single();
Assert.AreEqual(18, heineken.Id);
}
public void Test_where_and()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.IsDead && o.IsDiscontinued);
Assert.AreEqual("products?where=is_dead,is_discontinued", GetQuery(q));
}
public void Test_where_and_orderby()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.IsDead).OrderBy(o => o.Id);
Assert.AreEqual("products?where=is_dead&order=id.asc", GetQuery(q));
}
public void Test_orderby()
{
var data = new LcboDataSource();
var q = data.Products.OrderBy(o => o.Id);
Assert.AreEqual("products?order=id.asc", GetQuery(q));
}
public void Test_multi_clause_where_and_where_not()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.SearchQuery == "Scotch" && o.IsDead && o.IsKosher && !o.IsSeasonal);
Assert.AreEqual("products?q=Scotch&where=is_dead,is_kosher&where_not=is_seasonal", GetQuery(q));
}
public void Test_where_not()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => !o.IsSeasonal);
Assert.AreEqual("products?where_not=is_seasonal", GetQuery(q));
}
public void Test_select()
{
var data = new LcboDataSource();
var x = from product in data.Products
where product.SearchQuery == "heineken" && !product.IsDiscontinued
select product;
Assert.AreEqual("products?q=heineken&where_not=is_discontinued", GetQuery(x));
}
public void Test_single()
{
var data = new LcboDataSource();
Product p = data.Products.Single(o => o.Id == 18);
Assert.AreEqual(18, p.Id);
}
public void Test_where()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.SearchQuery == "Scotch");
Assert.AreEqual("products?q=Scotch", GetQuery(q));
}
public void Test_products_in_store_with_where()
{
var data = new LcboDataSource();
var q = data.Products.Where(o => o.StoreId == 511 && o.SearchQuery == "heineken");
var x = q.ToList();
Assert.AreEqual("stores/511/products?q=heineken", GetQuery(q));
}
public void Test_where_then_singleOrDefault()
{
var data = new LcboDataSource();
Product heineken = (from p in data.Products
where p.Id == 180000
select p).SingleOrDefault();
Assert.IsNull(heineken);
}
