public void Can_Write_And_Read_A_Null_LocalDate_Stored_As_Date()
{
var timeZone = DateTimeZoneProviders.Tzdb.GetSystemDefault();
LocalDate startLocalDate = TestClock.Now.InZone(timeZone).Date;
var testEvent = new LocalDateTestEntity
{
Description = "Can_Write_And_Read_A_Null_LocalDate_Stored_As_Date",
StartLocalDate = startLocalDate,
FinishLocalDate = null
};
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(testEvent);
transaction.Commit();
}
LocalDateTestEntity retrievedEvent;
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
retrievedEvent = session.Get <LocalDateTestEntity>(testEvent.Id);
transaction.Commit();
}
Assert.That(retrievedEvent.StartLocalDate, Is.EqualTo(testEvent.StartLocalDate));
Assert.That(retrievedEvent.FinishLocalDate, Is.EqualTo(testEvent.FinishLocalDate));
}
public void Can_Write_LocalDate_Stored_As_Date()
{
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var timeZone = DateTimeZoneProviders.Tzdb.GetSystemDefault();
LocalDate startLocalDate = TestClock.Now.InZone(timeZone).Date;
var testEvent = new LocalDateTestEntity
{
Description = "Can_Write_LocalDate_Stored_As_Date",
StartLocalDate = startLocalDate
};
session.Save(testEvent);
transaction.Commit();
Assert.That(testEvent.Id, Is.Not.Null);
}
}
public void Can_Query_By_GreaterThan_LocalDate_Stored_As_Date()
{
var timeZone = DateTimeZoneProviders.Tzdb.GetSystemDefault();
LocalDate startLocalDate = TestClock.Now.InZone(timeZone).Date.Plus(Period.FromWeeks(1));
LocalDate finishLocalDate = startLocalDate.PlusDays(3);
var testEvent = new LocalDateTestEntity
{
Description = "Can_Query_By_GreaterThan_LocalDate_Stored_As_Date",
StartLocalDate = startLocalDate,
FinishLocalDate = finishLocalDate
};
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(testEvent);
transaction.Commit();
}
LocalDate beforeLocalDate = startLocalDate.Minus(Period.FromDays(1));
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var query = session.Query <LocalDateTestEntity>()
.Where(x => x.Id == testEvent.Id && x.StartLocalDate > beforeLocalDate);
var retrievedEvent = query.SingleOrDefault();
transaction.Commit();
Assert.That(testEvent, Is.Not.Null);
Assert.That(testEvent, Is.EqualTo(retrievedEvent));
}
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var query = session.Query <LocalDateTestEntity>()
.Where(x => x.Id == testEvent.Id && x.StartLocalDate > beforeLocalDate && x.FinishLocalDate >= finishLocalDate);
var retrievedEvent = query.SingleOrDefault();
transaction.Commit();
Assert.That(testEvent, Is.Not.Null);
Assert.That(testEvent, Is.EqualTo(retrievedEvent));
}
}