forked from npgsql/npgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDateHandler.cs
More file actions
69 lines (61 loc) · 2.35 KB
/
DateHandler.cs
File metadata and controls
69 lines (61 loc) · 2.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
using NodaTime;
using Npgsql.BackendMessages;
using Npgsql.PostgresTypes;
using Npgsql.TypeHandling;
#pragma warning disable CS1591 // Missing XML comment for publicly visible type or member
namespace Npgsql.NodaTime
{
public class DateHandlerFactory : NpgsqlTypeHandlerFactory<LocalDate>
{
public override NpgsqlTypeHandler<LocalDate> Create(PostgresType postgresType, NpgsqlConnection conn)
{
var csb = new NpgsqlConnectionStringBuilder(conn.ConnectionString);
return new DateHandler(postgresType, csb.ConvertInfinityDateTime);
}
}
sealed class DateHandler : NpgsqlSimpleTypeHandler<LocalDate>
{
/// <summary>
/// Whether to convert positive and negative infinity values to Instant.{Max,Min}Value when
/// an Instant is requested
/// </summary>
readonly bool _convertInfinityDateTime;
internal DateHandler(PostgresType postgresType, bool convertInfinityDateTime)
: base(postgresType)
{
_convertInfinityDateTime = convertInfinityDateTime;
}
public override LocalDate Read(NpgsqlReadBuffer buf, int len, FieldDescription? fieldDescription = null)
{
var value = buf.ReadInt32();
if (_convertInfinityDateTime)
{
if (value == int.MaxValue)
return LocalDate.MaxIsoValue;
if (value == int.MinValue)
return LocalDate.MinIsoValue;
}
return new LocalDate().PlusDays(value + 730119);
}
public override int ValidateAndGetLength(LocalDate value, NpgsqlParameter? parameter)
=> 4;
public override void Write(LocalDate value, NpgsqlWriteBuffer buf, NpgsqlParameter? parameter)
{
if (_convertInfinityDateTime)
{
if (value == LocalDate.MaxIsoValue)
{
buf.WriteInt32(int.MaxValue);
return;
}
if (value == LocalDate.MinIsoValue)
{
buf.WriteInt32(int.MinValue);
return;
}
}
var totalDaysSinceEra = Period.Between(default(LocalDate), value, PeriodUnits.Days).Days;
buf.WriteInt32(totalDaysSinceEra - 730119);
}
}
}