forked from khellang/npgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathIntervalHandler.cs
More file actions
92 lines (80 loc) · 3.78 KB
/
IntervalHandler.cs
File metadata and controls
92 lines (80 loc) · 3.78 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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
#region License
// The PostgreSQL License
//
// Copyright (C) 2018 The Npgsql Development Team
//
// Permission to use, copy, modify, and distribute this software and its
// documentation for any purpose, without fee, and without a written
// agreement is hereby granted, provided that the above copyright notice
// and this paragraph and the following two paragraphs appear in all copies.
//
// IN NO EVENT SHALL THE NPGSQL DEVELOPMENT TEAM BE LIABLE TO ANY PARTY
// FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES,
// INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
// DOCUMENTATION, EVEN IF THE NPGSQL DEVELOPMENT TEAM HAS BEEN ADVISED OF
// THE POSSIBILITY OF SUCH DAMAGE.
//
// THE NPGSQL DEVELOPMENT TEAM SPECIFICALLY DISCLAIMS ANY WARRANTIES,
// INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
// AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
// ON AN "AS IS" BASIS, AND THE NPGSQL DEVELOPMENT TEAM HAS NO OBLIGATIONS
// TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
#endregion
using System;
using NodaTime;
using Npgsql.BackendMessages;
using Npgsql.TypeHandling;
#pragma warning disable CS1591 // Missing XML comment for publicly visible type or member
namespace Npgsql.NodaTime
{
public class IntervalHandlerFactory : NpgsqlTypeHandlerFactory<Period>
{
// Check for the legacy floating point timestamps feature
protected override NpgsqlTypeHandler<Period> Create(NpgsqlConnection conn)
=> new IntervalHandler(conn.HasIntegerDateTimes);
}
class IntervalHandler : NpgsqlSimpleTypeHandler<Period>
{
/// <summary>
/// A deprecated compile-time option of PostgreSQL switches to a floating-point representation of some date/time
/// fields. Some PostgreSQL-like databases (e.g. CrateDB) use floating-point representation by default and do not
/// provide the option of switching to integer format.
/// </summary>
readonly bool _integerFormat;
public IntervalHandler(bool integerFormat)
{
_integerFormat = integerFormat;
}
public override Period Read(NpgsqlReadBuffer buf, int len, FieldDescription fieldDescription = null)
{
var microsecondsInDay = _integerFormat ? buf.ReadInt64() : (long)(buf.ReadDouble() * 1000000);
var days = buf.ReadInt32();
var totalMonths = buf.ReadInt32();
// Nodatime will normalize most things (i.e. nanoseconds to milliseconds, seconds...)
// but it will not normalize months to years.
var months = totalMonths % 12;
var years = totalMonths / 12;
return new PeriodBuilder
{
Nanoseconds = microsecondsInDay * 1000,
Days = days,
Months = months,
Years = years
}.Build().Normalize();
}
public override int ValidateAndGetLength(Period value, NpgsqlParameter parameter)
=> 16;
public override void Write(Period value, NpgsqlWriteBuffer buf, NpgsqlParameter parameter)
{
var microsecondsInDay =
(((value.Hours * NodaConstants.MinutesPerHour + value.Minutes) * NodaConstants.SecondsPerMinute + value.Seconds) * NodaConstants.MillisecondsPerSecond + value.Milliseconds) * 1000 +
value.Nanoseconds / 1000; // Take the microseconds, discard the nanosecond remainder
if (_integerFormat)
buf.WriteInt64(microsecondsInDay);
else
buf.WriteDouble(microsecondsInDay / 1000000d);
buf.WriteInt32(value.Weeks * 7 + value.Days); // days
buf.WriteInt32(value.Years * 12 + value.Months); // months
}
}
}