public async Task QueryWithSqliteCache() { var path = System.IO.Path.GetTempFileName(); var conn = new SQLite.SQLiteAsyncConnection(path); var db = new TestDatabase(conn); await db.Reset(); Child[] allGadgets = new[] { new Child() { id = "aaa", power = 1, weight = 100 }, new Child() { id = "bbb", power = 2, weight = 123 }, new Child() { id = "ccc", power = 3, weight = 456 }, new Child() { id = "ddd", power = 4, weight = 100 } }; foreach (var t in allGadgets) { await gadgetOrigin.Store(t.id, t); } var memoryGadgetCache = new ModelClassCache <Child, string>(); var memoryCache = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Child), memoryGadgetCache } }); var sqliteGadgetCache = new SqliteClassCache <Child, string>(db); await sqliteGadgetCache.Setup(); var sqliteCache = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Child), sqliteGadgetCache } }); var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { memoryCache, sqliteCache }, new CascadeConfig()); var gadgets100 = await cascade.Query <Child>("gadgets100", new JsonObject { ["weight"] = 100 }); var gadgets100Ids = gadgets100.Select(t => t.id).ToImmutableArray(); Assert.That(gadgets100Ids, Is.EqualTo(new string[] { "aaa", "ddd" })); }
public async Task Simple() { Parent[] allThings = new[] { new Parent() { id = 1, colour = "red" }, new Parent() { id = 2, colour = "green" }, new Parent() { id = 3, colour = "red" }, new Parent() { id = 4, colour = "yellow" }, }; foreach (var t in allThings) { await thingOrigin.Store(t.id, t); } var thingModelStore1 = new ModelClassCache <Parent, long>(); var cache1 = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), thingModelStore1 } }); var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { cache1 }, new CascadeConfig()); var redThings = await cascade.Query <Parent>("red_things", new JsonObject { ["colour"] = "red" }); var redIds = redThings.Select(t => t.id).ToImmutableArray(); Assert.That(redIds, Is.EqualTo(new long[] { 1, 3 })); // check that collection & models are in cache Parent?thing; thing = await thingModelStore1.Fetch <Parent>(1); Assert.AreEqual(1, thing.id); Assert.AreEqual("red", thing.colour); thing = await thingModelStore1.Fetch <Parent>(3); Assert.AreEqual(3, thing.id); Assert.AreEqual("red", thing.colour); thing = await thingModelStore1.Fetch <Parent>(2); Assert.AreEqual(null, thing); var rcBefore = origin.RequestCount; origin.IncNowMs(); // request with freshness=2 var redThings2 = await cascade.Query <Parent>("red_things", new JsonObject { ["colour"] = "red" }, freshnessSeconds : 2); Assert.That(redThings2.Select(t => t.id).ToImmutableArray(), Is.EqualTo(new long[] { 1, 3 })); // same response Assert.AreEqual(rcBefore, origin.RequestCount); // didn't use origin rcBefore = origin.RequestCount; origin.IncNowMs(); redThings2 = (await cascade.Query <Parent>("red_things", new JsonObject { ["colour"] = "red" }, freshnessSeconds: 0)).ToImmutableArray(); Assert.That(redThings2.Select(t => t.id).ToImmutableArray(), Is.EqualTo(new long[] { 1, 3 })); // same response Assert.AreEqual(rcBefore + 1, origin.RequestCount); // did use origin }
public async Task ReadWithModelCachesMultitest() { var thingModelStore1 = new ModelClassCache <Parent, long>(); var cache1 = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), thingModelStore1 } }); var thingModelStore2 = new ModelClassCache <Parent, long>(); var cache2 = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), thingModelStore2 } }); // read from origin var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { cache1, cache2 }, new CascadeConfig() { DefaultFreshnessSeconds = 1 }); var thing1 = await cascade.Get <Parent>(5); Assert.AreEqual(5, thing1 !.id); Assert.AreEqual(cascade.NowMs, thing1.updatedAtMs); // should also be in both caches var store1ThingResponse = await thingModelStore1.Fetch(RequestOp.GetOp <Parent>(5, cascade.NowMs)); Assert.AreEqual((store1ThingResponse.Result as Parent) !.id, 5); Assert.AreEqual(cascade.NowMs, (store1ThingResponse.Result as Parent) !.updatedAtMs); var store2ThingResponse = await thingModelStore2.Fetch(RequestOp.GetOp <Parent>(5, cascade.NowMs)); Assert.AreEqual((store2ThingResponse.Result as Parent) !.id, 5); Assert.AreEqual(cascade.NowMs, (store2ThingResponse.Result as Parent) !.updatedAtMs); origin.IncNowMs(); // freshness=5 allows for cached version var thing2 = (await cascade.Get <Parent>(5, freshnessSeconds: 5)) !; Assert.AreEqual(thing1.updatedAtMs, thing2.updatedAtMs); // freshness=0 doesn't allow for cached version var thing3 = (await cascade.Get <Parent>(5, freshnessSeconds: 0)) !; Assert.AreEqual(origin.NowMs, thing3.updatedAtMs); // caches should also be updated store1ThingResponse = await thingModelStore1.Fetch(RequestOp.GetOp <Parent>(5, cascade.NowMs)); Assert.AreEqual(origin.NowMs, (store1ThingResponse.Result as Parent) !.updatedAtMs); store2ThingResponse = await thingModelStore2.Fetch(RequestOp.GetOp <Parent>(5, cascade.NowMs)); Assert.AreEqual(origin.NowMs, (store2ThingResponse.Result as Parent) !.updatedAtMs); origin.IncNowMs(2000); // freshness=2 should allow for cached version var thing4 = (await cascade.Get <Parent>(5, freshnessSeconds: 2)) !; Assert.AreEqual(thing3.updatedAtMs, thing4.updatedAtMs); // freshness=1 should get fresh version var thing5 = (await cascade.Get <Parent>(5, freshnessSeconds: 1)) !; Assert.AreEqual(origin.NowMs, thing5.updatedAtMs); origin.IncNowMs(1000); // clear cache1, freshnessSeconds=1 should return value from cache2 and update cache1 await cache1.Clear(); var thing6 = (await cascade.Get <Parent>(thing4.id, freshnessSeconds: 1)) !; // should get cache2 version Assert.AreEqual(thing6.updatedAtMs, thing5.updatedAtMs); store1ThingResponse = await thingModelStore1.Fetch(RequestOp.GetOp <Parent>(5, cascade.NowMs)); Assert.AreEqual(thing6.updatedAtMs, (store1ThingResponse.Result as Parent) !.updatedAtMs); }