public void DeleteRandomValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction1 = manager.BeginTransaction();
NullableDateTimeTestObject test1 = transaction1.Create(typeof(NullableDateTimeTestObject)) as NullableDateTimeTestObject;
test1.Date = DateTime.Today.AddDays(-30);
test1.SmallDate = DateTime.Today.AddMonths(1);
transaction1.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableDateTimes"));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableDateTimeTestObject test2 = transaction2.Select(typeof(NullableDateTimeTestObject), test1.Id) as NullableDateTimeTestObject;
Assert.AreEqual(DateTime.Today.AddDays(-30), test2.Date);
Assert.AreEqual(DateTime.Today.AddMonths(1), test2.SmallDate);
transaction2.Delete(test2);
transaction2.Commit();
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
}
public void UpdateValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test1 = transaction.Select(typeof(NullableDateTimeTestObject), UpdateValue) as NullableDateTimeTestObject;
Assert.AreEqual(new DateTime(2003, 10, 23), test1.Date);
Assert.AreEqual(new DateTime(2003, 10, 23), test1.SmallDate);
test1.Date = test1.Date.AddDays(-6);
test1.SmallDate = test1.SmallDate.AddYears(1);
transaction.Commit();
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableDateTimeTestObject test2 = transaction2.Select(typeof(NullableDateTimeTestObject), UpdateValue) as NullableDateTimeTestObject;
Assert.AreEqual(new DateTime(2003, 10, 17), test2.Date);
Assert.AreEqual(new DateTime(2004, 10, 23), test2.SmallDate);
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
}
public void SelectNonExistantValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test = transaction.Select(typeof(NullableDateTimeTestObject), DoesNotExistValues) as NullableDateTimeTestObject;
Assert.IsNull(test);
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
}
public void CreateNullValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test = transaction.Create(typeof(NullableDateTimeTestObject)) as NullableDateTimeTestObject;
Assert.AreEqual(new DateTime(2004, 1, 1), test.Date);
Assert.AreEqual(new DateTime(1981, 7, 11), test.SmallDate);
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
}
public void SelectMinValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test = transaction.Select(typeof(NullableDateTimeTestObject), MinValues) as NullableDateTimeTestObject;
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("NullableDateTimes"));
}
public void InsertRandomValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test = transaction.Create(typeof(NullableDateTimeTestObject)) as NullableDateTimeTestObject;
test.Date = DateTime.Now.AddDays(1);
test.SmallDate = DateTime.Now.AddDays(-1);
transaction.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableDateTimes"));
}
public void SelectNullValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
Assert.IsTrue(DataUtil.IsRowNull("NullableDateTimes", "id", NullValues));
ObjectTransaction transaction = manager.BeginTransaction();
NullableDateTimeTestObject test = transaction.Select(typeof(NullableDateTimeTestObject), NullValues) as NullableDateTimeTestObject;
Assert.AreEqual(new Guid(NullValues), test.Id);
Assert.AreEqual(new DateTime(2004, 1, 1), test.Date);
Assert.AreEqual(new DateTime(1981, 7, 11), test.SmallDate);
Assert.AreEqual(count, DataUtil.CountRows("NullableDateTimes"));
}
public void InsertNullImplicitValues()
{
int count = DataUtil.CountRows("NullableDateTimes");
ObjectTransaction transaction1 = manager.BeginTransaction();
NullableDateTimeTestObject test1 = transaction1.Create(typeof(NullableDateTimeTestObject)) as NullableDateTimeTestObject;
transaction1.Commit();
Assert.IsTrue(DataUtil.IsRowNull("NullableDateTimes", "id", test1.Id));
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableDateTimes"));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableDateTimeTestObject test2 = transaction2.Select(typeof(NullableDateTimeTestObject), test1.Id) as NullableDateTimeTestObject;
Assert.AreEqual(new DateTime(2004, 1, 1), test2.Date);
Assert.AreEqual(new DateTime(1981, 7, 11), test2.SmallDate);
}
