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);
}
