public void AutoId_Test() { using (var db = new LiteDatabase(DB.Path())) { var cs_int = db.GetCollection<EntityInt>("int"); var cs_guid = db.GetCollection<EntityGuid>("guid"); var cs_oid = db.GetCollection<EntityOid>("oid"); // int32 var cint_1 = new EntityInt { Name = "Using Int 1" }; var cint_2 = new EntityInt { Name = "Using Int 2" }; var cint_5 = new EntityInt { Id = 5, Name = "Using Int 5" }; // set Id, do not generate (jump 3 and 4)! var cint_6 = new EntityInt { Id = 0, Name = "Using Int 6" }; // for int, 0 is empty // guid var guid = Guid.NewGuid(); var cguid_1 = new EntityGuid { Id = guid, Name = "Using Guid" }; var cguid_2 = new EntityGuid { Name = "Using Guid" }; // oid var oid = ObjectId.NewObjectId(); var coid_1 = new EntityOid { Name = "ObjectId-1" }; var coid_2 = new EntityOid { Id = oid, Name = "ObjectId-2" }; cs_int.Insert(cint_1); cs_int.Insert(cint_2); cs_int.Insert(cint_5); cs_int.Insert(cint_6); cs_guid.Insert(cguid_1); cs_guid.Insert(cguid_2); cs_oid.Insert(coid_1); cs_oid.Insert(coid_2); // test for int Assert.AreEqual(cint_1.Id, 1); Assert.AreEqual(cint_2.Id, 2); Assert.AreEqual(cint_5.Id, 5); Assert.AreEqual(cint_6.Id, 6); // test for guid Assert.AreEqual(cguid_1.Id, guid); Assert.AreNotEqual(cguid_2.Id, Guid.Empty); Assert.AreNotEqual(cguid_1.Id, cguid_2.Id); // test for oid Assert.AreNotEqual(coid_1, ObjectId.Empty); Assert.AreEqual(coid_2.Id, oid); } }
public void AutoId_Test() { using (var db = new LiteDatabase(DB.Path())) { var cs_int = db.GetCollection <EntityInt>("int"); var cs_guid = db.GetCollection <EntityGuid>("guid"); var cs_oid = db.GetCollection <EntityOid>("oid"); // int32 var cint_1 = new EntityInt { Name = "Using Int 1" }; var cint_2 = new EntityInt { Name = "Using Int 2" }; var cint_5 = new EntityInt { Id = 5, Name = "Using Int 5" }; // set Id, do not generate (jump 3 and 4)! var cint_6 = new EntityInt { Id = 0, Name = "Using Int 6" }; // for int, 0 is empty // guid var guid = Guid.NewGuid(); var cguid_1 = new EntityGuid { Id = guid, Name = "Using Guid" }; var cguid_2 = new EntityGuid { Name = "Using Guid" }; // oid var oid = ObjectId.NewObjectId(); var coid_1 = new EntityOid { Name = "ObjectId-1" }; var coid_2 = new EntityOid { Id = oid, Name = "ObjectId-2" }; cs_int.Insert(cint_1); cs_int.Insert(cint_2); cs_int.Insert(cint_5); cs_int.Insert(cint_6); cs_guid.Insert(cguid_1); cs_guid.Insert(cguid_2); cs_oid.Insert(coid_1); cs_oid.Insert(coid_2); // test for int Assert.AreEqual(cint_1.Id, 1); Assert.AreEqual(cint_2.Id, 2); Assert.AreEqual(cint_5.Id, 5); Assert.AreEqual(cint_6.Id, 6); // test for guid Assert.AreEqual(cguid_1.Id, guid); Assert.AreNotEqual(cguid_2.Id, Guid.Empty); Assert.AreNotEqual(cguid_1.Id, cguid_2.Id); // test for oid Assert.AreNotEqual(coid_1, ObjectId.Empty); Assert.AreEqual(coid_2.Id, oid); } }
public void AutoId_Test() { using (var db = new LiteDatabase(DB.Path())) { var cs_int = db.GetCollection<EntityInt>("int"); var cs_guid = db.GetCollection<EntityGuid>("guid"); var cs_oid = db.GetCollection<EntityOid>("oid"); var cs_str = db.GetCollection<EntityString>("str"); // int32 var cint_1 = new EntityInt { Name = "Using Int 1" }; var cint_2 = new EntityInt { Name = "Using Int 2" }; var cint_5 = new EntityInt { Id = 5, Name = "Using Int 5" }; // set Id, do not generate (jump 3 and 4)! var cint_6 = new EntityInt { Id = 0, Name = "Using Int 6" }; // for int, 0 is empty // guid var guid = Guid.NewGuid(); var cguid_1 = new EntityGuid { Id = guid, Name = "Using Guid" }; var cguid_2 = new EntityGuid { Name = "Using Guid" }; // oid var oid = ObjectId.NewObjectId(); var coid_1 = new EntityOid { Name = "ObjectId-1" }; var coid_2 = new EntityOid { Id = oid, Name = "ObjectId-2" }; // string - there is no AutoId for string var cstr_1 = new EntityString { Name = "Object using String" }; cs_int.Insert(cint_1); cs_int.Insert(cint_2); cs_int.Insert(cint_5); cs_int.Insert(cint_6); cs_guid.Insert(cguid_1); cs_guid.Insert(cguid_2); cs_oid.Insert(coid_1); cs_oid.Insert(coid_2); try { cs_str.Insert(cstr_1); //Assert.Fail(); throw new Exception("Exception not thrown on Insert"); } catch (LiteException) { // must fail because EntityString class has a defined Id // but has no value and no auto_id funtion - issue #43 } // test for int Assert.Equal(cint_1.Id, 1); Assert.Equal(cint_2.Id, 2); Assert.Equal(cint_5.Id, 5); Assert.Equal(cint_6.Id, 6); // test for guid Assert.Equal(cguid_1.Id, guid); Assert.NotEqual(cguid_2.Id, Guid.Empty); Assert.NotEqual(cguid_1.Id, cguid_2.Id); // test for oid Assert.NotEqual(coid_1.Id, ObjectId.Empty); Assert.Equal(coid_2.Id, oid); } }
public void AutoId_Test() { using (var db = new LiteDatabase(DB.Path())) { var cs_int = db.GetCollection <EntityInt>("int"); var cs_guid = db.GetCollection <EntityGuid>("guid"); var cs_oid = db.GetCollection <EntityOid>("oid"); var cs_str = db.GetCollection <EntityString>("str"); // int32 var cint_1 = new EntityInt { Name = "Using Int 1" }; var cint_2 = new EntityInt { Name = "Using Int 2" }; var cint_5 = new EntityInt { Id = 5, Name = "Using Int 5" }; // set Id, do not generate (jump 3 and 4)! var cint_6 = new EntityInt { Id = 0, Name = "Using Int 6" }; // for int, 0 is empty // guid var guid = Guid.NewGuid(); var cguid_1 = new EntityGuid { Id = guid, Name = "Using Guid" }; var cguid_2 = new EntityGuid { Name = "Using Guid" }; // oid var oid = ObjectId.NewObjectId(); var coid_1 = new EntityOid { Name = "ObjectId-1" }; var coid_2 = new EntityOid { Id = oid, Name = "ObjectId-2" }; // string - there is no AutoId for string var cstr_1 = new EntityString { Name = "Object using String" }; cs_int.Insert(cint_1); cs_int.Insert(cint_2); cs_int.Insert(cint_5); cs_int.Insert(cint_6); cs_guid.Insert(cguid_1); cs_guid.Insert(cguid_2); cs_oid.Insert(coid_1); cs_oid.Insert(coid_2); try { cs_str.Insert(cstr_1); Assert.Fail(); } catch (LiteException) { // must fail because EntityString class has a defined Id // but has no value and no auto_id funtion - issue #43 } // test for int Assert.AreEqual(cint_1.Id, 1); Assert.AreEqual(cint_2.Id, 2); Assert.AreEqual(cint_5.Id, 5); Assert.AreEqual(cint_6.Id, 6); // test for guid Assert.AreEqual(cguid_1.Id, guid); Assert.AreNotEqual(cguid_2.Id, Guid.Empty); Assert.AreNotEqual(cguid_1.Id, cguid_2.Id); // test for oid Assert.AreNotEqual(coid_1, ObjectId.Empty); Assert.AreEqual(coid_2.Id, oid); } }