public void bug_1276_can_select_instant(SerializerType serializerType)
{
StoreOptions(_ => _.UseNodaTime());
var dateTime = DateTime.UtcNow;
var instantUTC = Instant.FromDateTimeUtc(dateTime.ToUniversalTime());
var testDoc = TargetWithDates.Generate(dateTime);
using (var session = theStore.OpenSession())
{
session.Insert(testDoc);
session.SaveChanges();
}
using (var query = theStore.QuerySession())
{
var resulta = query.Query <TargetWithDates>()
.Where(c => c.Id == testDoc.Id)
.Single();
var result = query.Query <TargetWithDates>()
.Where(c => c.Id == testDoc.Id)
.Select(c => new { c.Id, c.InstantUTC })
.Single();
result.ShouldNotBeNull();
result.Id.ShouldBe(testDoc.Id);
ShouldBeEqualWithDbPrecision(result.InstantUTC, instantUTC);
}
}
public void can_insert_document()
{
StoreOptions(_ => _.UseNodaTime());
var testDoc = TargetWithDates.Generate();
using (var session = theStore.OpenSession())
{
session.Insert(testDoc);
session.SaveChanges();
}
using (var query = theStore.QuerySession())
{
var docFromDb = query.Query <TargetWithDates>().FirstOrDefault(d => d.Id == testDoc.Id);
docFromDb.ShouldNotBeNull();
docFromDb.Equals(testDoc).ShouldBeTrue();
}
}
public void cannot_query_document_clr_datetime_types()
{
StoreOptions(_ => _.UseNodaTime());
var dateTime = DateTime.UtcNow;
var localDateTime = LocalDateTime.FromDateTime(dateTime);
var instantUTC = Instant.FromDateTimeUtc(dateTime.ToUniversalTime());
var testDoc = TargetWithDates.Generate(dateTime);
using (var session = theStore.OpenSession())
{
session.Insert(testDoc);
session.SaveChanges();
}
using (var query = theStore.QuerySession())
{
Should.Throw <NotSupportedException>
(
() => query.Query <TargetWithDates>().FirstOrDefault(d => d.DateTime == dateTime),
"The CLR type System.DateTime isn't natively supported by Npgsql or your PostgreSQL. To use it with a PostgreSQL composite you need to specify DataTypeName or to map it, please refer to the documentation."
);
}
}
public void can_query_document_with_noda_time_types()
{
StoreOptions(_ =>
{
_.UseNodaTime();
_.DatabaseSchemaName = "NodaTime";
});
var dateTime = DateTime.UtcNow;
var localDateTime = LocalDateTime.FromDateTime(dateTime);
var instantUTC = Instant.FromDateTimeUtc(dateTime.ToUniversalTime());
var testDoc = TargetWithDates.Generate(dateTime);
using (var session = theStore.OpenSession())
{
session.Insert(testDoc);
session.SaveChanges();
}
using (var query = theStore.QuerySession())
{
var results = new List <TargetWithDates>
{
// LocalDate
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDate == localDateTime.Date),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDate < localDateTime.Date.PlusDays(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDate <= localDateTime.Date.PlusDays(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDate > localDateTime.Date.PlusDays(-1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDate >= localDateTime.Date.PlusDays(-1)),
//// Nullable LocalDate
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDate == localDateTime.Date),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDate < localDateTime.Date.PlusDays(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDate <= localDateTime.Date.PlusDays(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDate > localDateTime.Date.PlusDays(-1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDate >= localDateTime.Date.PlusDays(-1)),
//// LocalDateTime
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDateTime == localDateTime),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDateTime < localDateTime.PlusSeconds(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDateTime <= localDateTime.PlusSeconds(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDateTime > localDateTime.PlusSeconds(-1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.LocalDateTime >= localDateTime.PlusSeconds(-1)),
//// Nullable LocalDateTime
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDateTime == localDateTime),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDateTime < localDateTime.PlusSeconds(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDateTime <= localDateTime.PlusSeconds(1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDateTime > localDateTime.PlusSeconds(-1)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableLocalDateTime >= localDateTime.PlusSeconds(-1)),
//// Instant UTC
query.Query <TargetWithDates>().FirstOrDefault(d => d.InstantUTC == instantUTC),
query.Query <TargetWithDates>().FirstOrDefault(d => d.InstantUTC < instantUTC.PlusTicks(1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.InstantUTC <= instantUTC.PlusTicks(1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.InstantUTC > instantUTC.PlusTicks(-1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.InstantUTC >= instantUTC.PlusTicks(-1000)),
// Nullable Instant UTC
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableInstantUTC == instantUTC),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableInstantUTC < instantUTC.PlusTicks(1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableInstantUTC <= instantUTC.PlusTicks(1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableInstantUTC > instantUTC.PlusTicks(-1000)),
query.Query <TargetWithDates>().FirstOrDefault(d => d.NullableInstantUTC >= instantUTC.PlusTicks(-1000))
};
results.ShouldAllBe(x => x.Equals(testDoc));
}
}
