public void DeleteRandomValues() { int count = DataUtil.CountRows("DateTimes"); ObjectTransaction transaction1 = manager.BeginTransaction(); DateTimeTestObject test1 = transaction1.Create(typeof(DateTimeTestObject)) as DateTimeTestObject; test1.Date = DateTime.Today.AddDays(1); test1.SmallDate = DateTime.Today.AddMonths(1); transaction1.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("DateTimes")); ObjectTransaction transaction2 = manager.BeginTransaction(); DateTimeTestObject test2 = transaction2.Select(typeof(DateTimeTestObject), test1.Id) as DateTimeTestObject; Assert.AreEqual(DateTime.Today.AddDays(1), test2.Date); Assert.AreEqual(DateTime.Today.AddMonths(1), test2.SmallDate); transaction2.Delete(test2); transaction2.Commit(); Assert.AreEqual(count, DataUtil.CountRows("DateTimes")); }
public void UpdateValues() { int count = DataUtil.CountRows("DateTimes"); ObjectTransaction transaction = manager.BeginTransaction(); DateTimeTestObject test1 = transaction.Select(typeof(DateTimeTestObject), UpdateValue) as DateTimeTestObject; Assert.AreEqual(new DateTime(2004, 10, 23), test1.Date); Assert.AreEqual(new DateTime(2004, 10, 23), test1.SmallDate); test1.Date = test1.Date.AddDays(1); test1.SmallDate = test1.SmallDate.AddDays(-1); transaction.Commit(); Assert.AreEqual(count, DataUtil.CountRows("DateTimes")); ObjectTransaction transaction2 = manager.BeginTransaction(); DateTimeTestObject test2 = transaction2.Select(typeof(DateTimeTestObject), UpdateValue) as DateTimeTestObject; Assert.AreEqual(new DateTime(2004, 10, 24), test2.Date); Assert.AreEqual(new DateTime(2004, 10, 22), test2.SmallDate); Assert.AreEqual(count, DataUtil.CountRows("DateTimes")); }
public void SelectNonExistantValues() { int count = DataUtil.CountRows("DateTimes"); ObjectTransaction transaction = manager.BeginTransaction(); DateTimeTestObject test = transaction.Select(typeof(DateTimeTestObject), DoesNotExistValues) as DateTimeTestObject; Assert.IsNull(test); Assert.AreEqual(count, DataUtil.CountRows("DateTimes")); }
public void InsertMissingValues() { int count = DataUtil.CountRows("DateTimes"); ObjectTransaction transaction = manager.BeginTransaction(); DateTimeTestObject test = transaction.Create(typeof(DateTimeTestObject)) as DateTimeTestObject; test.SmallDate = DateTime.Now.AddDays(-1); transaction.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("DateTimes")); }
public void SelectMinValues() { int count = DataUtil.CountRows("DateTimes"); ObjectTransaction transaction = manager.BeginTransaction(); DateTimeTestObject test = transaction.Select(typeof(DateTimeTestObject), MinValues) as DateTimeTestObject; Assert.AreEqual(new Guid(MinValues), test.Id); Assert.AreEqual(new DateTime(1753, 1, 1), test.Date); Assert.AreEqual(new DateTime(1900, 1, 1), test.SmallDate); Assert.AreEqual(count, DataUtil.CountRows("DateTimes")); }
public void SetDateTimeProperty() { DateTimeTestObject o = new DateTimeTestObject(); ObjectWrapper wrapper = GetWrapper(o); wrapper.SetPropertyValue("TriggerDateTime", "1991-10-10"); Assert.AreEqual(1991, ((DateTime) wrapper.GetPropertyValue("TriggerDateTime")).Year); }