public async Task SimpleReadThroughCache() { var path = System.IO.Path.GetTempFileName(); var conn = new SQLite.SQLiteAsyncConnection(path); var db = new TestDatabase(conn); await db.Reset(); var sqliteThingCache = new SqliteClassCache <Parent, long>(db); await sqliteThingCache.Setup(); var cache1 = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), sqliteThingCache } }); // read from origin var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { cache1 }, new CascadeConfig() { DefaultFreshnessSeconds = 1 }); var thing1 = await cascade.Get <Parent>(5); Assert.AreEqual(5, thing1 !.id); Assert.AreEqual(cascade.NowMs, thing1.updatedAtMs); origin.IncNowMs(); var thing2 = await cascade.Get <Parent>(5, freshnessSeconds : 2); Assert.AreEqual(thing1.updatedAtMs, thing2 !.updatedAtMs); var thing3 = await cascade.Get <Parent>(5, freshnessSeconds : 0); Assert.AreEqual(origin.NowMs, thing3 !.updatedAtMs); }
public async Task CreateReadUpdateDeleteTest() { var path = System.IO.Path.GetTempFileName(); var conn = new SQLite.SQLiteAsyncConnection(path); var db = new TestDatabase(conn); await db.Reset(); var thing1 = new Parent() { colour = "red" }; thing1 = await db.Create <Parent>(thing1); Assert.Greater(thing1.id, 0); var loaded = await db.Get <Parent>(thing1.id); Assert.AreEqual(thing1.id, loaded.id); thing1.colour = "green"; await db.Update(thing1); var thing2 = await db.Get <Parent>(thing1.id); Assert.AreEqual(thing1.colour, thing2.colour); await db.Delete(thing2); var thing3 = await db.Get <Parent>(thing2.id); Assert.IsNull(thing3); }
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 TestCollections() { var path = System.IO.Path.GetTempFileName(); var conn = new SQLite.SQLiteAsyncConnection(path); var db = new TestDatabase(conn); await db.Reset(); var sqliteThingCache = new SqliteClassCache <Parent, long>(db); await sqliteThingCache.Setup(); var sqliteGadgetCache = new SqliteClassCache <Child, string>(db); await sqliteGadgetCache.Setup(); var cache = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), sqliteThingCache }, { typeof(Child), sqliteGadgetCache } }); var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { cache }, new CascadeConfig() { DefaultFreshnessSeconds = 1 }); var collection_key = "my_things"; var ids = ImmutableArray.Create <object>(1, 2, 3); var response = await cache.Fetch(RequestOp.QueryOp <Parent>(collection_key, new JsonObject(), 0)); Assert.AreEqual(false, response.Exists); Assert.AreEqual(null, response.Result); await cache.StoreCollection(typeof(Parent), collection_key, ids, 0); response = await cache.Fetch(RequestOp.QueryOp <Parent>(collection_key, null, 0)); Assert.IsTrue(CascadeTypeUtils.IsEqualEnumerable(ids, response.ResultIds)); response = await cache.Fetch(RequestOp.QueryOp <Parent>("not_my_key", null, 0)); Assert.IsFalse(response.Exists); response = await cache.Fetch(RequestOp.QueryOp <Child>(collection_key, null, 0)); Assert.IsFalse(response.Exists); }
public async Task TestMetadata() { var path = System.IO.Path.GetTempFileName(); var conn = new SQLite.SQLiteAsyncConnection(path); var db = new TestDatabase(conn); await db.Reset(); var sqliteThingCache = new SqliteClassCache <Parent, long>(db); await sqliteThingCache.Setup(); var sqliteGadgetCache = new SqliteClassCache <Child, string>(db); await sqliteGadgetCache.Setup(); var cache1 = new ModelCache(aClassCache: new Dictionary <Type, IModelClassCache>() { { typeof(Parent), sqliteThingCache }, { typeof(Child), sqliteGadgetCache } }); // read from origin var cascade = new CascadeDataLayer(origin, new ICascadeCache[] { cache1 }, new CascadeConfig() { DefaultFreshnessSeconds = 1 }); var thing5 = new Parent() { id = 5, colour = "red" }; var thing5ArrivedAt = cascade.NowMs; await sqliteThingCache.Store(thing5.id, thing5, thing5ArrivedAt); origin.IncNowMs(); var gadget6 = new Child() { id = "abc", weight = 2.5, power = 9.2 }; var gadget6ArrivedAt = cascade.NowMs; await sqliteGadgetCache.Store(gadget6.id, gadget6, gadget6ArrivedAt); origin.IncNowMs(); var opResponse = await sqliteThingCache.Fetch(RequestOp.GetOp <Parent>(thing5.id, cascade.NowMs)); var loaded5 = (opResponse.Result as Parent) !; Assert.AreEqual(thing5ArrivedAt, opResponse.ArrivedAtMs); Assert.AreEqual(thing5.colour, loaded5.colour); opResponse = await sqliteGadgetCache.Fetch(RequestOp.GetOp <Child>(gadget6.id, cascade.NowMs)); var loaded6 = (opResponse.Result as Child) !; Assert.AreEqual(gadget6ArrivedAt, opResponse.ArrivedAtMs); Assert.AreEqual(gadget6.weight, loaded6.weight); await sqliteGadgetCache.Clear(); // thing unaffected opResponse = await sqliteThingCache.Fetch(RequestOp.GetOp <Parent>(thing5.id, cascade.NowMs)); Assert.NotNull(opResponse.Result); Assert.AreEqual(thing5ArrivedAt, opResponse.ArrivedAtMs); // gadget cleared including metadata opResponse = await sqliteGadgetCache.Fetch(RequestOp.GetOp <Child>(gadget6.id, cascade.NowMs)); Assert.IsNull(opResponse.Result); Assert.IsNull(opResponse.ArrivedAtMs); var meta6 = await db.Get <CascadeModelMeta>(CascadeModelMeta.GenerateId <Child>(6)); Assert.IsNull(meta6); }