Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
npgsql/src/Npgsql/NpgsqlTypes/NpgsqlCube.cs at main · npgsql/npgsql · GitHub
Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
npgsql
npgsql
Repository navigation
Code
Issues
194
(194)
Pull requests
46
(46)
Actions
Security and quality
1
(1)
Insights
More
items
Files
Expand file tree
main
Breadcrumbs
npgsql
/
src
/
Npgsql
/
NpgsqlTypes
/
NpgsqlCube.cs
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
251 lines (221 loc) · 8.44 KB
main
Breadcrumbs
npgsql
/
src
/
Npgsql
/
NpgsqlTypes
/
NpgsqlCube.cs
Copy path
Top
File metadata and controls
Code
Blame
251 lines (221 loc) · 8.44 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
using
System
;
using
System
.
Collections
.
Generic
;
using
System
.
Globalization
;
using
System
.
Linq
;
using
System
.
Text
;
// ReSharper disable once CheckNamespace
namespace
NpgsqlTypes
;
/// <summary>
/// Represents a PostgreSQL cube data type.
/// </summary>
/// <remarks>
/// See https://www.postgresql.org/docs/current/cube.html
/// </remarks>
public
readonly
struct
NpgsqlCube
:
IEquatable
<
NpgsqlCube
>
{
// Store the coordinates as a value tuple array
readonly
double
[
]
_lowerLeft
;
readonly
double
[
]
_upperRight
;
/// <summary>
/// The lower left coordinates of the cube.
/// </summary>
public
IReadOnlyList
<
double
>
LowerLeft
=>
_lowerLeft
;
/// <summary>
/// The upper right coordinates of the cube.
/// </summary>
public
IReadOnlyList
<
double
>
UpperRight
=>
_upperRight
;
/// <summary>
/// The number of dimensions of the cube.
/// </summary>
public
int
Dimensions
=>
_lowerLeft
.
Length
;
/// <summary>
/// True if the cube is a point, that is, the two defining corners are the same.
/// </summary>
public
bool
IsPoint
{
get
;
}
/// <summary>
/// Makes a cube with upper right and lower left coordinates as defined by the two arrays, which must be of the same length.
/// </summary>
/// <note>This is an internal constructor to optimize the number of allocations.</note>
/// <param name="lowerLeft">The lower left values.</param>
/// <param name="upperRight">The upper right values.</param>
/// <exception cref="ArgumentException">
/// Thrown if the number of dimensions in the upper left and lower right values do not match.
/// </exception>
internal
NpgsqlCube
(
double
[
]
lowerLeft
,
double
[
]
upperRight
)
{
if
(
lowerLeft
.
Length
!=
upperRight
.
Length
)
throw
new
ArgumentException
(
$
"Not a valid cube: Different point dimensions in
{
lowerLeft
}
and
{
upperRight
}
."
)
;
IsPoint
=
lowerLeft
.
SequenceEqual
(
upperRight
)
;
_lowerLeft
=
lowerLeft
;
_upperRight
=
upperRight
;
}
/// <summary>
/// Makes a one dimensional cube with both coordinates the same.
/// </summary>
/// <param name="coord">The point coordinate.</param>
public
NpgsqlCube
(
double
coord
)
{
IsPoint
=
true
;
_lowerLeft
=
[
coord
]
;
_upperRight
=
_lowerLeft
;
}
/// <summary>
/// Makes a one dimensional cube.
/// </summary>
/// <param name="lowerLeft">The lower left value.</param>
/// <param name="upperRight">The upper right value.</param>
public
NpgsqlCube
(
double
lowerLeft
,
double
upperRight
)
{
IsPoint
=
lowerLeft
.
CompareTo
(
upperRight
)
==
0
;
_lowerLeft
=
[
lowerLeft
]
;
_upperRight
=
IsPoint
?
_lowerLeft
:
[
upperRight
]
;
}
/// <summary>
/// Makes a zero-volume cube using the coordinates defined by the array.
/// </summary>
/// <param name="coords">The coordinates.</param>
public
NpgsqlCube
(
IEnumerable
<
double
>
coords
)
{
// Always create a defensive copy to prevent external mutation
_lowerLeft
=
coords
.
ToArray
(
)
;
IsPoint
=
true
;
_upperRight
=
_lowerLeft
;
}
/// <summary>
/// Makes a cube with upper right and lower left coordinates as defined by the two arrays, which must be of the same length.
/// </summary>
/// <param name="lowerLeft">The lower left values.</param>
/// <param name="upperRight">The upper right values.</param>
/// <exception cref="ArgumentException">
/// Thrown if the number of dimensions in the upper left and lower right values do not match
/// or if the cube exceeds the maximum dimensions (100).
/// </exception>
public
NpgsqlCube
(
IEnumerable
<
double
>
lowerLeft
,
IEnumerable
<
double
>
upperRight
)
:
this
(
lowerLeft
.
ToArray
(
)
,
upperRight
.
ToArray
(
)
)
{
}
/// <summary>
/// Makes a new cube by adding a dimension on to an existing cube, with the same values for both endpoints of the new coordinate.
/// This is useful for building cubes piece by piece from calculated values.
/// </summary>
/// <param name="cube">The existing cube.</param>
/// <param name="coord">The coordinate to add.</param>
public
NpgsqlCube
(
NpgsqlCube
cube
,
double
coord
)
{
IsPoint
=
cube
.
IsPoint
;
if
(
IsPoint
)
{
_lowerLeft
=
cube
.
_lowerLeft
.
Append
(
coord
)
.
ToArray
(
)
;
_upperRight
=
_lowerLeft
;
}
else
{
_lowerLeft
=
cube
.
_lowerLeft
.
Append
(
coord
)
.
ToArray
(
)
;
_upperRight
=
cube
.
_upperRight
.
Append
(
coord
)
.
ToArray
(
)
;
}
}
/// <summary>
/// Makes a new cube by adding a dimension on to an existing cube.
/// This is useful for building cubes piece by piece from calculated values.
/// </summary>
/// <param name="cube">The existing cube.</param>
/// <param name="lowerLeft">The lower left value.</param>
/// <param name="upperRight">The upper right value.</param>
public
NpgsqlCube
(
NpgsqlCube
cube
,
double
lowerLeft
,
double
upperRight
)
{
IsPoint
=
cube
.
IsPoint
&&
lowerLeft
.
CompareTo
(
upperRight
)
==
0
;
if
(
IsPoint
)
{
_lowerLeft
=
cube
.
_lowerLeft
.
Append
(
lowerLeft
)
.
ToArray
(
)
;
_upperRight
=
_lowerLeft
;
}
else
{
_lowerLeft
=
cube
.
_lowerLeft
.
Append
(
lowerLeft
)
.
ToArray
(
)
;
_upperRight
=
cube
.
_upperRight
.
Append
(
upperRight
)
.
ToArray
(
)
;
}
}
/// <summary>
/// Makes a new cube from an existing cube, using a list of dimension indexes from an array.
/// Can be used to extract the endpoints of a single dimension, or to drop dimensions, or to reorder them as desired.
/// </summary>
/// <param name="indexes">The list of dimension indexes.</param>
/// <returns>A new cube.</returns>
/// <example>
/// <code>
/// var cube = new NpgsqlCube(new[] { 1, 3, 5 }, new[] { 6, 7, 8 }); // '(1,3,5),(6,7,8)'
/// cube.ToSubset(1); // '(3),(7)'
/// cube.ToSubset(2, 1, 0, 0); // '(5,3,1,1),(8,7,6,6)'
/// </code>
/// </example>
public
NpgsqlCube
ToSubset
(
params
int
[
]
indexes
)
{
var
lowerLeft
=
new
double
[
indexes
.
Length
]
;
var
upperRight
=
new
double
[
indexes
.
Length
]
;
for
(
var
i
=
0
;
i
<
indexes
.
Length
;
i
++
)
{
lowerLeft
[
i
]
=
_lowerLeft
[
indexes
[
i
]
]
;
upperRight
[
i
]
=
_upperRight
[
indexes
[
i
]
]
;
}
return
new
NpgsqlCube
(
lowerLeft
,
upperRight
)
;
}
/// <inheritdoc />
public
bool
Equals
(
NpgsqlCube
other
)
=>
Dimensions
==
other
.
Dimensions
&&
_lowerLeft
.
SequenceEqual
(
other
.
_lowerLeft
)
&&
_upperRight
.
SequenceEqual
(
other
.
_upperRight
)
;
/// <inheritdoc />
public
override
bool
Equals
(
object
?
obj
)
=>
obj
is
NpgsqlCube
other
&&
Equals
(
other
)
;
/// <inheritdoc cref="IEquatable{T}" />
public
static
bool
operator
==
(
NpgsqlCube
x
,
NpgsqlCube
y
)
=>
x
.
Equals
(
y
)
;
/// <inheritdoc cref="IEquatable{T}" />
public
static
bool
operator
!=
(
NpgsqlCube
x
,
NpgsqlCube
y
)
=>
!
(
x
==
y
)
;
/// <inheritdoc />
public
override
int
GetHashCode
(
)
{
var
hashCode
=
new
HashCode
(
)
;
for
(
var
i
=
0
;
i
<
Dimensions
;
i
++
)
{
hashCode
.
Add
(
_lowerLeft
[
i
]
)
;
hashCode
.
Add
(
_upperRight
[
i
]
)
;
}
return
hashCode
.
ToHashCode
(
)
;
}
/// <summary>
/// Writes the cube in PostgreSQL's text format.
/// </summary>
void
Write
(
StringBuilder
stringBuilder
)
{
var
leftBuilder
=
new
StringBuilder
(
)
;
var
rightBuilder
=
new
StringBuilder
(
)
;
leftBuilder
.
Append
(
'('
)
;
rightBuilder
.
Append
(
'('
)
;
for
(
var
i
=
0
;
i
<
Dimensions
;
i
++
)
{
leftBuilder
.
Append
(
CultureInfo
.
InvariantCulture
,
$
"
{
_lowerLeft
[
i
]
:
G17
}
"
)
;
rightBuilder
.
Append
(
CultureInfo
.
InvariantCulture
,
$
"
{
_upperRight
[
i
]
:
G17
}
"
)
;
if
(
i
>=
Dimensions
-
1
)
continue
;
leftBuilder
.
Append
(
", "
)
;
rightBuilder
.
Append
(
", "
)
;
}
leftBuilder
.
Append
(
')'
)
;
rightBuilder
.
Append
(
')'
)
;
if
(
IsPoint
)
{
stringBuilder
.
Append
(
leftBuilder
)
;
}
else
{
stringBuilder
.
Append
(
leftBuilder
)
;
stringBuilder
.
Append
(
','
)
;
stringBuilder
.
Append
(
rightBuilder
)
;
}
}
/// <summary>
/// Writes the cube in PostgreSQL's text format.
/// </summary>
public
override
string
ToString
(
)
{
var
sb
=
new
StringBuilder
(
)
;
Write
(
sb
)
;
return
sb
.
ToString
(
)
;
}
}
You can’t perform that action at this time.