forked from oracle/python-cx_Oracle
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDateTimeVar.c
More file actions
115 lines (96 loc) · 4.56 KB
/
DateTimeVar.c
File metadata and controls
115 lines (96 loc) · 4.56 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
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);
}