Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
python-cx_Oracle/src/DateTimeVar.c at master · vonhng/python-cx_Oracle · 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 }}
vonhng
/
python-cx_Oracle
Public
forked from
oracle/python-cx_Oracle
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Files
Expand file tree
master
Breadcrumbs
python-cx_Oracle
/
src
/
DateTimeVar.c
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
115 lines (96 loc) · 4.56 KB
master
Breadcrumbs
python-cx_Oracle
/
src
/
DateTimeVar.c
Copy path
Top
File metadata and controls
Code
Blame
115 lines (96 loc) · 4.56 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
//-----------------------------------------------------------------------------
// Copyright 2016, 2017, Oracle and/or its affiliates. All rights reserved.
//
// Portions Copyright 2007-2015, Anthony Tuininga. All rights reserved.
//
// Portions Copyright 2001-2007, Computronix (Canada) Ltd., Edmonton, Alberta,
// Canada. All rights reserved.
//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------
// DateTimeVar.c
// Defines the routines for handling date (time) variables.
//-----------------------------------------------------------------------------
//-----------------------------------------------------------------------------
// Declaration of date/time variable functions.
//-----------------------------------------------------------------------------
static
int
DateTimeVar_SetValue
(
udt_Variable
*
,
uint32_t
,
dpiData
*
,
PyObject
*
);
static
PyObject
*
DateTimeVar_GetValue
(
udt_Variable
*
,
dpiData
*
);
//-----------------------------------------------------------------------------
// Python type declarations
//-----------------------------------------------------------------------------
DECLARE_VARIABLE_TYPE
(
g_DateTimeVarType
,
DATETIME
)
DECLARE_VARIABLE_TYPE
(
g_TimestampVarType
,
TIMESTAMP
)
//-----------------------------------------------------------------------------
// variable type declarations
//-----------------------------------------------------------------------------
static
udt_VariableType
vt_DateTime
=
{
(
SetValueProc
)
DateTimeVar_SetValue
,
(
GetValueProc
)
DateTimeVar_GetValue
,
&
g_DateTimeVarType
,
// Python type
DPI_ORACLE_TYPE_DATE
,
// Oracle type
DPI_NATIVE_TYPE_TIMESTAMP
,
// native type
0
// element length
};
static
udt_VariableType
vt_Date
=
{
(
SetValueProc
)
DateTimeVar_SetValue
,
(
GetValueProc
)
DateTimeVar_GetValue
,
&
g_DateTimeVarType
,
// Python type
DPI_ORACLE_TYPE_DATE
,
// Oracle type
DPI_NATIVE_TYPE_TIMESTAMP
,
// native type
0
// element length
};
static
udt_VariableType
vt_Timestamp
=
{
(
SetValueProc
)
DateTimeVar_SetValue
,
(
GetValueProc
)
DateTimeVar_GetValue
,
&
g_TimestampVarType
,
// Python type
DPI_ORACLE_TYPE_TIMESTAMP
,
// Oracle type
DPI_NATIVE_TYPE_TIMESTAMP
,
// native type
0
// element length
};
static
udt_VariableType
vt_TimestampLTZ
=
{
(
SetValueProc
)
DateTimeVar_SetValue
,
(
GetValueProc
)
DateTimeVar_GetValue
,
&
g_TimestampVarType
,
// Python type
DPI_ORACLE_TYPE_TIMESTAMP_LTZ
,
// Oracle type
DPI_NATIVE_TYPE_TIMESTAMP
,
// native type
0
// element length
};
//-----------------------------------------------------------------------------
// DateTimeVar_SetValue()
// Set the value of the variable.
//-----------------------------------------------------------------------------
static
int
DateTimeVar_SetValue
(
udt_Variable
*
var
,
uint32_t
pos
,
dpiData
*
data
,
PyObject
*
value
)
{
if
(
PyDateTime_Check
(
value
)) {
dpiData_setTimestamp
(
data
,
PyDateTime_GET_YEAR
(
value
),
PyDateTime_GET_MONTH
(
value
),
PyDateTime_GET_DAY
(
value
),
PyDateTime_DATE_GET_HOUR
(
value
),
PyDateTime_DATE_GET_MINUTE
(
value
),
PyDateTime_DATE_GET_SECOND
(
value
),
PyDateTime_DATE_GET_MICROSECOND
(
value
)
*
1000
,
0
,
0
);
}
else
if
(
PyDate_Check
(
value
)) {
dpiData_setTimestamp
(
data
,
PyDateTime_GET_YEAR
(
value
),
PyDateTime_GET_MONTH
(
value
),
PyDateTime_GET_DAY
(
value
),
0
,
0
,
0
,
0
,
0
,
0
);
}
else
{
PyErr_SetString
(
PyExc_TypeError
,
"expecting date data"
);
return
-1
;
}
return
0
;
}
//-----------------------------------------------------------------------------
// DateTimeVar_GetValue()
// Returns the value stored at the given array position.
//-----------------------------------------------------------------------------
static
PyObject
*
DateTimeVar_GetValue
(
udt_Variable
*
var
,
dpiData
*
data
)
{
dpiTimestamp
*
timestamp
;
timestamp
=
&
data
->
value
.
asTimestamp
;
if
(
var
->
type
==
&
vt_Date
)
return
PyDate_FromDate
(
timestamp
->
year
,
timestamp
->
month
,
timestamp
->
day
);
return
PyDateTime_FromDateAndTime
(
timestamp
->
year
,
timestamp
->
month
,
timestamp
->
day
,
timestamp
->
hour
,
timestamp
->
minute
,
timestamp
->
second
,
timestamp
->
fsecond
/
1000
);
}
You can’t perform that action at this time.
