forked from npgsql/npgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathNpgsqlNodatimeExtensions.cs
More file actions
90 lines (88 loc) · 3.88 KB
/
NpgsqlNodatimeExtensions.cs
File metadata and controls
90 lines (88 loc) · 3.88 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
#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.Data;
using NodaTime;
using Npgsql.NodaTime;
using Npgsql.TypeMapping;
using NpgsqlTypes;
// ReSharper disable once CheckNamespace
namespace Npgsql
{
/// <summary>
/// Extension allowing adding the NodaTime plugin to an Npgsql type mapper.
/// </summary>
public static class NpgsqlNodatimeExtensions
{
/// <summary>
/// Sets up NodaTime mappings for the PostgreSQL json and jsonb types.
/// </summary>
/// <param name="mapper">The type mapper to set up (global or connection-specific)</param>
public static INpgsqlTypeMapper UseNodatime(this INpgsqlTypeMapper mapper)
=> mapper
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "timestamp",
NpgsqlDbType = NpgsqlDbType.Timestamp,
DbTypes = new[] { DbType.DateTime, DbType.DateTime2 },
ClrTypes = new[] { typeof(Instant), typeof(LocalDateTime) },
InferredDbType = DbType.DateTime,
TypeHandlerFactory = new TimestampHandlerFactory()
}.Build())
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "timestamptz",
NpgsqlDbType = NpgsqlDbType.TimestampTz,
ClrTypes = new[] { typeof(ZonedDateTime) },
TypeHandlerFactory = new TimestampTzHandlerFactory()
}.Build())
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "date",
NpgsqlDbType = NpgsqlDbType.Date,
DbTypes = new[] { DbType.Date },
ClrTypes = new[] { typeof(LocalDate) },
TypeHandlerFactory = new DateHandlerFactory()
}.Build())
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "time",
NpgsqlDbType = NpgsqlDbType.Time,
DbTypes = new[] { DbType.Time },
ClrTypes = new[] { typeof(LocalTime) },
TypeHandlerFactory = new TimeHandlerFactory()
}.Build())
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "timetz",
NpgsqlDbType = NpgsqlDbType.TimeTz,
TypeHandlerFactory = new TimeTzHandlerFactory()
}.Build())
.AddMapping(new NpgsqlTypeMappingBuilder
{
PgTypeName = "interval",
NpgsqlDbType = NpgsqlDbType.Interval,
ClrTypes = new[] { typeof(Period) },
TypeHandlerFactory = new IntervalHandlerFactory()
}.Build());
}
}