public static void WhereShortCutShouldWork() { SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider); DaoReferenceObject test = new DaoReferenceObject(); test.StringProperty = "".RandomString(8); test.Commit(); DaoReferenceObjectCollection checking = DaoReferenceObject.Where(c => c.StringProperty == test.StringProperty); Expect.IsTrue(checking.Count == 1); }
public static void ShortcutShouldWorkLikeLongcut() { SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider); DaoReferenceObject test = new DaoReferenceObject(); string val = "".RandomString(8); test.StringProperty = val; test.Commit(); DaoReferenceObjectCollection results = DaoReferenceObject.Where(f => f.Id == test.Id); Expect.IsTrue(results.Count > 0); Expect.IsTrue(results[0].StringProperty.Equals(val)); }
public void CanQueryByUlongProperty() { Database db = new SQLiteDatabase(nameof(SaveAndQueryTest)); db.TryEnsureSchema <DaoReferenceObject>(); DaoReferenceObject.LoadAll(db).Delete(db); ulong testValue = 8374384738473847; DaoReferenceObject referenceObject = new DaoReferenceObject() { IntProperty = 10, DecimalProperty = 10, LongProperty = 10, ULongProperty = testValue, DateTimeProperty = Instant.Now, BoolProperty = true, ByteArrayProperty = "This is the byte array property".ToBytes(), StringProperty = "This is the string property" }; referenceObject.Id.ShouldBeNull("Id should have been null"); referenceObject.Save(db); string referenceJson = referenceObject.ToJsonSafe().ToJson(); referenceObject.Id.ShouldNotBeNull("Id should not have been null"); DaoReferenceObject[] retrieved = DaoReferenceObject.Where(c => c.ULongProperty == testValue, db).ToArray(); Expect.AreEqual(1, retrieved.Length); DaoReferenceObject instance = retrieved[0]; Expect.AreEqual(instance.ULongProperty, referenceObject.ULongProperty); Expect.AreEqual(referenceObject, instance); Expect.AreEqual(referenceJson, instance.ToJsonSafe().ToJson()); Expect.AreEqual(testValue, instance.ULongProperty); Message.PrintLine(db.ConnectionString); }
public object[] Where(QiQuery query) { return(DaoReferenceObject.Where(query).ToJsonSafe()); }