public void CompositeKeyObject_Insert() { const int dataKey1ID = 102; const int dataKey2ID = 200; const int dataKey3ID = 300; const string dataTextData = "This is some text data."; var dataDateEntered = DateTime.Now; var poco = new CompositeKeyObject { Key1ID = dataKey1ID, Key2ID = dataKey2ID, Key3ID = dataKey3ID, TextData = dataTextData, DateEntered = dataDateEntered }; var db = TestDatabase.Db; db.Insert(poco); var verify = db.SingleOrDefault <CompositeKeyObject>(@" SELECT * FROM CompositeKeyObjects WHERE Key1ID = @0 AND Key2ID = @1 AND Key3ID = @2 " , dataKey1ID, dataKey2ID, dataKey3ID); db.Execute(@" DELETE FROM CompositeKeyObjects WHERE Key1ID = @0 AND Key2ID = @1 AND Key3ID = @2 " , dataKey1ID, dataKey2ID, dataKey3ID); Assert.IsNotNull(verify); Assert.AreEqual(dataKey1ID, verify.Key1ID); Assert.AreEqual(dataKey2ID, verify.Key2ID); Assert.AreEqual(dataKey3ID, verify.Key3ID); Assert.AreEqual(dataTextData, verify.TextData); int tDiff = dataDateEntered.Subtract(verify.DateEntered).Milliseconds; //Trace.WriteLine("TDiff = " + tDiff); Assert.IsTrue(Math.Abs(tDiff) < 100, "DateEntered difference (ms): " + tDiff); }
public void CompositeKeyObject_Insert() { const int dataKey1ID = 102; const int dataKey2ID = 200; const int dataKey3ID = 300; const string dataTextData = "This is some text data."; var dataDateEntered = DateTime.Now; var poco = new CompositeKeyObject { Key1ID = dataKey1ID, Key2ID = dataKey2ID, Key3ID = dataKey3ID, TextData = dataTextData, DateEntered = dataDateEntered }; var db = TestDatabase.Db; db.Insert(poco); var verify = db.SingleOrDefault<CompositeKeyObject>(@" SELECT * FROM CompositeKeyObjects WHERE Key1ID = @0 AND Key2ID = @1 AND Key3ID = @2 ", dataKey1ID, dataKey2ID, dataKey3ID); db.Execute(@" DELETE FROM CompositeKeyObjects WHERE Key1ID = @0 AND Key2ID = @1 AND Key3ID = @2 ", dataKey1ID, dataKey2ID, dataKey3ID); Assert.IsNotNull(verify); Assert.AreEqual(dataKey1ID, verify.Key1ID); Assert.AreEqual(dataKey2ID, verify.Key2ID); Assert.AreEqual(dataKey3ID, verify.Key3ID); Assert.AreEqual(dataTextData, verify.TextData); int tDiff = dataDateEntered.Subtract(verify.DateEntered).Milliseconds; //Trace.WriteLine("TDiff = " + tDiff); Assert.IsTrue(Math.Abs(tDiff) < 100, "DateEntered difference (ms): "+ tDiff); }
public static void RecreateData(NPoco.Database db) { InMemoryCompositeKeyObjects = new List<CompositeKeyObject>(); InMemoryIdentityObjects = new List<IdentityObject>(); InMemoryKeyedGuidObjects = new List<KeyedGuidObject>(); InMemoryKeyedIntObjects = new List<KeyedIntObject>(); InMemoryListObjects = new List<ListObject>(); InMemoryNoKeyNonDistinctObjects = new List<NoKeyNonDistinctObject>(); InMemoryObjectsWithCustomType = new List<ObjectsWithCustomType>(); // Clear out any old items db.Execute("TRUNCATE TABLE CompositeKeyObjects;"); db.Execute("TRUNCATE TABLE IdentityObjects;"); db.Execute("TRUNCATE TABLE KeyedGuidObjects;"); db.Execute("TRUNCATE TABLE KeyedIntObjects;"); db.Execute("TRUNCATE TABLE ListObjects;"); db.Execute("TRUNCATE TABLE NoKeyNonDistinctObjects;"); db.Execute("DBCC CHECKIDENT ('IdentityObjects', RESEED, 0) WITH NO_INFOMSGS;"); int pos; for (var i = 0; i < 15; i += 1 ) { pos = i + 1; var cko = new CompositeKeyObject { Key1ID = (pos / 5) + 1, Key2ID = (pos / 3) + 1, Key3ID = (pos % 5), TextData = "Text" + pos, DateEntered = new DateTime(1970, 1, 1).AddYears(pos), DateUpdated = DateTime.Now }; db.Insert(cko); InMemoryCompositeKeyObjects.Add(cko); var io = new IdentityObject { Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos*100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(io); InMemoryIdentityObjects.Add(io); var kgo = new KeyedGuidObject { Id = System.Guid.NewGuid(), Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos * 100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(kgo); InMemoryKeyedGuidObjects.Add(kgo); var kio = new KeyedIntObject { Id = pos, Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos * 100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(kio); InMemoryKeyedIntObjects.Add(kio); var nkndo = new NoKeyNonDistinctObject { FullName = "Name " + pos % 2, ItemInt = pos % 2, OptionalInt = (pos % 2 == 0) ? (int?)42 : null, Color = (pos % 2 == 0) ? "Red" : "Blue" }; db.Insert(nkndo); InMemoryNoKeyNonDistinctObjects.Add(nkndo); var owct = new ObjectsWithCustomType { Id = "StringId_" + pos.ToString(), Name = "Blah", MySpecialTypeField = new DateTime(1925 + pos, 2, 15) }; db.Insert(owct); InMemoryObjectsWithCustomType.Add(owct); } InMemoryListObjects.Add(new ListObject { Id = 1, ShortName = "LiveLetter", Description = "Live with Letter of Intent Only", StatusKey = "A", SortOrder =1 }); InMemoryListObjects.Add(new ListObject { Id = 2, ShortName = "TakesPatients", Description = "Will Accept Most Patients", StatusKey = "P", SortOrder = 10 }); InMemoryListObjects.Add(new ListObject { Id = 3, ShortName = "Active", Description = "Active", StatusKey = "I", SortOrder = 20 }); InMemoryListObjects.Add(new ListObject { Id = 4, ShortName = "Prospect", Description = "Prospect", StatusKey = "I", SortOrder = 30 }); InMemoryListObjects.Add(new ListObject { Id = 5, ShortName = "OnHold", Description = "Tracked but not expected to participate", StatusKey = "I", SortOrder = 90 }); foreach (var lo in InMemoryListObjects) { db.Insert(lo); } }
public bool Update(CompositeKeyObject entity) { db.Update(entity); return(true); }
public bool Insert(CompositeKeyObject entity) { db.Insert(entity); return(true); }
public static void RecreateData(NPoco.Database db) { InMemoryCompositeKeyObjects = new List <CompositeKeyObject>(); InMemoryIdentityObjects = new List <IdentityObject>(); InMemoryKeyedGuidObjects = new List <KeyedGuidObject>(); InMemoryKeyedIntObjects = new List <KeyedIntObject>(); InMemoryListObjects = new List <ListObject>(); InMemoryNoKeyNonDistinctObjects = new List <NoKeyNonDistinctObject>(); InMemoryObjectsWithCustomType = new List <ObjectsWithCustomType>(); // Clear out any old items db.Execute("TRUNCATE TABLE CompositeKeyObjects;"); db.Execute("TRUNCATE TABLE IdentityObjects;"); db.Execute("TRUNCATE TABLE KeyedGuidObjects;"); db.Execute("TRUNCATE TABLE KeyedIntObjects;"); db.Execute("TRUNCATE TABLE ListObjects;"); db.Execute("TRUNCATE TABLE NoKeyNonDistinctObjects;"); db.Execute("DBCC CHECKIDENT ('IdentityObjects', RESEED, 0) WITH NO_INFOMSGS;"); int pos; for (var i = 0; i < 15; i += 1) { pos = i + 1; var cko = new CompositeKeyObject { Key1ID = (pos / 5) + 1, Key2ID = (pos / 3) + 1, Key3ID = (pos % 5), TextData = "Text" + pos, DateEntered = new DateTime(1970, 1, 1).AddYears(pos), DateUpdated = DateTime.Now }; db.Insert(cko); InMemoryCompositeKeyObjects.Add(cko); var io = new IdentityObject { Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos * 100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(io); InMemoryIdentityObjects.Add(io); var kgo = new KeyedGuidObject { Id = System.Guid.NewGuid(), Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos * 100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(kgo); InMemoryKeyedGuidObjects.Add(kgo); var kio = new KeyedIntObject { Id = pos, Name = "Name " + pos, Age = (pos % 2 == 0) ? (int?)pos * 3 : null, DateOfBirth = new DateTime(1970, 1, 1).AddYears(pos), Savings = (pos * 100000) / 13, DependentCount = (pos % 2 == 1) ? (byte?)pos : null, Gender = (pos % 2 == 0) ? "M" : "F", IsActive = (pos % 2 == 1) }; db.Insert(kio); InMemoryKeyedIntObjects.Add(kio); var nkndo = new NoKeyNonDistinctObject { FullName = "Name " + pos % 2, ItemInt = pos % 2, OptionalInt = (pos % 2 == 0) ? (int?)42 : null, Color = (pos % 2 == 0) ? "Red" : "Blue" }; db.Insert(nkndo); InMemoryNoKeyNonDistinctObjects.Add(nkndo); var owct = new ObjectsWithCustomType { Id = "StringId_" + pos.ToString(), Name = "Blah", MySpecialTypeField = new DateTime(1925 + pos, 2, 15) }; db.Insert(owct); InMemoryObjectsWithCustomType.Add(owct); } InMemoryListObjects.Add(new ListObject { Id = 1, ShortName = "LiveLetter", Description = "Live with Letter of Intent Only", StatusKey = "A", SortOrder = 1 }); InMemoryListObjects.Add(new ListObject { Id = 2, ShortName = "TakesPatients", Description = "Will Accept Most Patients", StatusKey = "P", SortOrder = 10 }); InMemoryListObjects.Add(new ListObject { Id = 3, ShortName = "Active", Description = "Active", StatusKey = "I", SortOrder = 20 }); InMemoryListObjects.Add(new ListObject { Id = 4, ShortName = "Prospect", Description = "Prospect", StatusKey = "I", SortOrder = 30 }); InMemoryListObjects.Add(new ListObject { Id = 5, ShortName = "OnHold", Description = "Tracked but not expected to participate", StatusKey = "I", SortOrder = 90 }); foreach (var lo in InMemoryListObjects) { db.Insert(lo); } }
public bool Update(CompositeKeyObject entity) { db.Update(entity); return true; }
public bool Insert(CompositeKeyObject entity) { db.Insert(entity); return true; }