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
|
// file : odb/qt/date-time/mysql/qdate-time-traits.hxx
// copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC
// license : GNU GPL v2; see accompanying LICENSE file
#ifndef ODB_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
#define ODB_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
#include <odb/pre.hxx>
#include <QtCore/QDateTime>
#include <odb/mysql/traits.hxx>
namespace odb
{
namespace mysql
{
template <>
struct default_value_traits<QDateTime, id_datetime>
{
typedef QDateTime value_type;
typedef QDateTime query_type;
typedef MYSQL_TIME image_type;
static void
set_value (QDateTime& v, const MYSQL_TIME& i, bool is_null)
{
if (is_null)
// Default constructor creates a null QDateTime.
//
v = QDateTime ();
else
v = QDateTime (QDate (static_cast<int> (i.year),
static_cast<int> (i.month),
static_cast<int> (i.day)),
QTime (static_cast<int> (i.hour),
static_cast<int> (i.minute),
static_cast<int> (i.second)));
}
static void
set_image (MYSQL_TIME& i, bool& is_null, const QDateTime& v)
{
if (v.isNull ())
is_null = true;
else
{
if ((v < QDateTime (QDate (1000, 1, 1))) ||
(v >= QDateTime (QDate (10000, 1, 1))))
throw odb::qt::date_time::value_out_of_range ();
is_null = false;
const QDate& d (v.date ());
i.year = static_cast<unsigned int> (d.year ());
i.month = static_cast<unsigned int> (d.month ());
i.day = static_cast<unsigned int> (d.day ());
const QTime& t (v.time ());
i.hour = static_cast<unsigned int> (t.hour ());
i.minute = static_cast<unsigned int> (t.minute ());
i.second = static_cast<unsigned int> (t.second ());
}
}
};
template <>
struct default_value_traits<QDateTime, id_timestamp>
{
typedef QDateTime value_type;
typedef QDateTime query_type;
typedef MYSQL_TIME image_type;
static void
set_value (QDateTime& v, const MYSQL_TIME& i, bool is_null)
{
if (is_null)
// Default constructor creates a null QDateTime.
//
v = QDateTime ();
else
v = QDateTime (QDate (static_cast<int> (i.year),
static_cast<int> (i.month),
static_cast<int> (i.day)),
QTime (static_cast<int> (i.hour),
static_cast<int> (i.minute),
static_cast<int> (i.second)));
}
static void
set_image (MYSQL_TIME& i, bool& is_null, const QDateTime& v)
{
if (v.isNull ())
is_null = true;
else
{
if ((v <= QDateTime (QDate (1970, 1, 1))) ||
(v > QDateTime (QDate (2038, 1, 19), QTime (3, 14, 7))))
throw odb::qt::date_time::value_out_of_range ();
is_null = false;
const QDate& d (v.date ());
i.year = static_cast<unsigned int> (d.year ());
i.month = static_cast<unsigned int> (d.month ());
i.day = static_cast<unsigned int> (d.day ());
const QTime& t (v.time ());
i.hour = static_cast<unsigned int> (t.hour ());
i.minute = static_cast<unsigned int> (t.minute ());
i.second = static_cast<unsigned int> (t.second ());
}
}
};
template <>
struct default_type_traits<QDateTime>
{
static const database_type_id db_type_od = id_datetime;
};
}
}
#endif // ODB_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
|