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
|
// file : odb/qt/date-time/sqlite/qdate-traits.hxx
// copyright : Copyright (c) 2009-2015 Code Synthesis Tools CC
// license : GNU GPL v2; see accompanying LICENSE file
#ifndef ODB_QT_DATE_TIME_SQLITE_QDATE_TRAITS_HXX
#define ODB_QT_DATE_TIME_SQLITE_QDATE_TRAITS_HXX
#include <odb/pre.hxx>
#include <string>
#include <cstddef> // std::size_t
#include <cstring> // std::memcpy
#include <QtCore/QDate>
#include <odb/details/buffer.hxx>
#include <odb/sqlite/traits.hxx>
#include <odb/qt/date-time/exceptions.hxx>
namespace odb
{
namespace sqlite
{
template <>
struct default_value_traits<QDate, id_text>
{
typedef QDate value_type;
typedef QDate query_type;
typedef details::buffer image_type;
static void
set_value (QDate& v,
const details::buffer& i,
std::size_t n,
bool is_null)
{
if (is_null)
// A null QDate value is equivalent to an invalid QDate value.
// Set v to an invalid date to represent null.
//
v.setDate (0, 0, 0);
else
v = QDate::fromString (
QString::fromLatin1 (i.data (), static_cast<int> (n)),
"yyyy-MM-dd");
}
static void
set_image (details::buffer& i,
std::size_t& n,
bool& is_null,
const QDate& v)
{
if (v.isNull ())
is_null = true;
else
{
is_null = false;
// Cannot use toStdString() here since Qt could have been
// configured without the STL compatibility support.
//
std::string s (v.toString ("yyyy-MM-dd").toLatin1 ().constData ());
n = s.size ();
if (n > i.capacity ())
i.capacity (n);
std::memcpy (i.data (), s.data (), n);
}
}
};
// Implementation of the mapping between QDate and SQLite INTEGER. The
// integer value represents UNIX time.
//
template <>
struct default_value_traits<QDate, id_integer>
{
typedef QDate value_type;
typedef QDate query_type;
typedef long long image_type;
static void
set_value (QDate& v, long long i, bool is_null)
{
if (is_null)
// A null QDate value is equivalent to an invalid QDate value.
// Set v to an invalid date to represent null.
//
v.setDate (0, 0, 0);
else
{
QDateTime dt;
dt.setTimeSpec (Qt::UTC);
dt.setTime_t (static_cast<uint> (i));
v = dt.date ();
}
}
static void
set_image (long long& i, bool& is_null, const QDate& v)
{
if (v.isNull ())
is_null = true;
else if (v < QDate (1970, 1, 1))
throw odb::qt::date_time::value_out_of_range ();
else
{
is_null = false;
i = static_cast<long long> (
QDateTime (v, QTime (0, 0, 0), Qt::UTC).toTime_t ());
}
}
};
template <>
struct default_type_traits<QDate>
{
static const database_type_id db_type_id = id_text;
};
}
}
#include <odb/post.hxx>
#endif // ODB_QT_DATE_TIME_SQLITE_QDATE_TRAITS_HXX
|