Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
duckdb-python/src/include/duckdb_python/python_objects.hpp at main · duckdb/duckdb-python · 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 }}
Uh oh!
There was an error while loading.
Please reload this page
.
duckdb
/
duckdb-python
Public
Notifications
You must be signed in to change notification settings
Fork
113
Star
186
Code
Issues
40
Pull requests
29
Discussions
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Discussions
Actions
Projects
Security and quality
Insights
Files
Expand file tree
main
Breadcrumbs
duckdb-python
/
src
/
include
/
duckdb_python
/
python_objects.hpp
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
232 lines (197 loc) · 5.77 KB
main
Breadcrumbs
duckdb-python
/
src
/
include
/
duckdb_python
/
python_objects.hpp
Copy path
Top
File metadata and controls
Code
Blame
232 lines (197 loc) · 5.77 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
#
pragma
once
#
include
"
duckdb_python/nb/casters.hpp
"
#
include
"
duckdb_python/pyutil.hpp
"
#
include
"
duckdb/common/types/time.hpp
"
#
include
"
duckdb/common/types/date.hpp
"
#
include
"
duckdb/common/types/timestamp.hpp
"
#
include
"
duckdb/common/types/interval.hpp
"
#
include
"
duckdb/common/types/value.hpp
"
#
include
"
duckdb/common/types/cast_helpers.hpp
"
#
include
"
duckdb/main/client_properties.hpp
"
#
include
"
datetime.h
"
//
from python
/*
Backport for Python < 3.10
*/
#
if
PY_VERSION_HEX < 0x030a00a1
#
ifndef
PyDateTime_TIME_GET_TZINFO
#
define
PyDateTime_TIME_GET_TZINFO
(
o
) ((((PyDateTime_Time *)o)->hastzinfo) ? ((PyDateTime_Time *)o)->tzinfo : Py_None)
#
endif
#
ifndef
PyDateTime_DATE_GET_TZINFO
#
define
PyDateTime_DATE_GET_TZINFO
(
o
) \
((((PyDateTime_DateTime *)o)->hastzinfo) ? ((PyDateTime_DateTime *)o)->tzinfo : Py_None)
#
endif
#
endif
namespace
duckdb
{
struct
PyDictionary
{
public:
PyDictionary
(nb::object dict);
//
These are cached so we don't have to create new objects all the time
//
The CPython API offers PyDict_Keys but that creates a new reference every time, same for values
nb::object keys;
nb::object values;
idx_t
len;
public:
nb::handle
operator
[](
const
nb::object &obj)
const
{
return
PyDict_GetItem
(dict.
ptr
(), obj.
ptr
());
}
public:
string
ToString
()
const
{
return
nb::cast<std::string>(
nb::str
(dict));
}
private:
nb::object dict;
};
enum
class
PyDecimalExponentType
{
EXPONENT_SCALE
,
//
! Amount of digits after the decimal point
EXPONENT_POWER
,
//
! How many zeros behind the decimal point
EXPONENT_INFINITY
,
//
! Decimal is INFINITY
EXPONENT_NAN
//
! Decimal is NAN
};
struct
PyDecimal
{
struct
PyDecimalScaleConverter
{
template
<
typename
T,
typename
= std::enable_if<std::numeric_limits<T>::is_integer, T>>
static
Value
Operation
(
bool
signed_value, vector<
uint8_t
> &digits,
uint8_t
width,
uint8_t
scale) {
T value =
0
;
for
(
auto
it = digits.
begin
(); it != digits.
end
(); it++) {
value = value *
10
+ *it;
}
if
(signed_value) {
value = -value;
}
return
Value::DECIMAL
(value, width, scale);
}
};
struct
PyDecimalPowerConverter
{
template
<
typename
T,
typename
= std::enable_if<std::numeric_limits<T>::is_integer, T>>
static
Value
Operation
(
bool
signed_value, vector<
uint8_t
> &digits,
uint8_t
width,
uint8_t
scale) {
T value =
0
;
for
(
auto
&digit : digits) {
value = value *
10
+ digit;
}
D_ASSERT
(scale >=
0
);
int64_t
multiplier =
NumericHelper::
POWERS_OF_TEN
[MinValue<
uint8_t
>(scale, NumericHelper::
CACHED_POWERS_OF_TEN
-
1
)];
for
(
auto
power = scale; power > NumericHelper::
CACHED_POWERS_OF_TEN
; power--) {
multiplier *=
10
;
}
value *= multiplier;
if
(signed_value) {
value = -value;
}
return
Value::DECIMAL
(value, width, scale);
}
};
public:
PyDecimal
(nb::handle &obj);
vector<
uint8_t
> digits;
bool
signed_value =
false
;
PyDecimalExponentType exponent_type;
int32_t
exponent_value;
public:
bool
TryGetType
(LogicalType &type);
Value
ToDuckValue
();
private:
void
SetExponent
(nb::handle &exponent);
nb::handle &obj;
};
struct
PyTimeDelta
{
public:
PyTimeDelta
(nb::handle &obj);
int32_t
days;
int32_t
seconds;
int64_t
microseconds;
public:
interval_t
ToInterval
();
private:
static
int64_t
GetDays
(nb::handle &obj);
static
int64_t
GetSeconds
(nb::handle &obj);
static
int64_t
GetMicros
(nb::handle &obj);
};
struct
PyTime
{
public:
PyTime
(nb::handle &obj);
nb::handle &obj;
int32_t
hour;
int32_t
minute;
int32_t
second;
int32_t
microsecond;
nb::object timezone_obj;
public:
dtime_t
ToDuckTime
();
Value
ToDuckValue
();
private:
static
int32_t
GetHours
(nb::handle &obj);
static
int32_t
GetMinutes
(nb::handle &obj);
static
int32_t
GetSeconds
(nb::handle &obj);
static
int32_t
GetMicros
(nb::handle &obj);
static
nb::object
GetTZInfo
(nb::handle &obj);
};
struct
PyDateTime
{
public:
PyDateTime
(nb::handle &obj);
nb::handle &obj;
int32_t
year;
int32_t
month;
int32_t
day;
int32_t
hour;
int32_t
minute;
int32_t
second;
int32_t
micros;
nb::object tzone_obj;
public:
timestamp_t
ToTimestamp
();
date_t
ToDate
();
dtime_t
ToDuckTime
();
Value
ToDuckValue
(
const
LogicalType &target_type);
public:
static
int32_t
GetYears
(nb::handle &obj);
static
int32_t
GetMonths
(nb::handle &obj);
static
int32_t
GetDays
(nb::handle &obj);
static
int32_t
GetHours
(nb::handle &obj);
static
int32_t
GetMinutes
(nb::handle &obj);
static
int32_t
GetSeconds
(nb::handle &obj);
static
int32_t
GetMicros
(nb::handle &obj);
static
nb::object
GetTZInfo
(nb::handle &obj);
};
struct
PyDate
{
public:
PyDate
(nb::handle &ele);
int32_t
year;
int32_t
month;
int32_t
day;
public:
date_t
ToDate
();
Value
ToDuckValue
();
};
struct
PyTimezone
{
public:
PyTimezone
() =
delete
;
public:
DUCKDB_API
static
int32_t
GetUTCOffsetSeconds
(nb::handle &tzone_obj);
DUCKDB_API
static
interval_t
GetUTCOffset
(nb::handle &datetime, nb::handle &tzone_obj);
};
struct
PythonObject
{
static
void
Initialize
();
static
nb::object
FromStruct
(
const
Value &value,
const
LogicalType &id,
const
ClientProperties &client_properties);
static
nb::object
FromValue
(
const
Value &value,
const
LogicalType &id,
const
ClientProperties &client_properties);
};
template
<
class
T
>
class
Optional
:
public
nb
::object {
public:
Optional
(
const
nb::object &o) : nb::object(o, nb::detail::
borrow_t
{}) {
}
using
nb::object::object;
public:
static
bool
check_
(
const
nb::handle &object) {
return
object.
is_none
() || nb::isinstance<T>(object);
}
};
class
FileLikeObject
:
public
nb
::object {
public:
FileLikeObject
(
const
nb::object &o) : nb::object(o, nb::detail::
borrow_t
{}) {
}
using
nb::object::object;
public:
static
bool
check_
(
const
nb::handle &object) {
return
duckdb::PyUtil::IsInstance
(object,
nb::module_::import_
(
"
io
"
).
attr
(
"
IOBase
"
));
}
};
}
//
namespace duckdb
You can’t perform that action at this time.