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
|
// file : mapping/traits-pgsql.hxx
// author : Constantin Michael <constantin@codesynthesis.com>
// copyright : not copyrighted - public domain
#ifndef TRAITS_PGSQL_HXX
#define TRAITS_PGSQL_HXX
//
// PostgreSQL implementation.
//
#include <cstring>
#include <ctime>
#include <odb/pgsql/traits.hxx>
#include <odb/pgsql/details/endian-traits.hxx>
#include "person.hxx" // date
namespace odb
{
namespace pgsql
{
template <>
class value_traits<bool, id_string>
{
public:
typedef bool value_type;
typedef bool query_type;
typedef details::buffer image_type;
static void
set_value (bool& v,
const details::buffer& b,
std::size_t n,
bool is_null)
{
v = (!is_null && n == 4 && std::strncmp ("true", b.data (), n) == 0);
}
static void
set_image (details::buffer& b,
std::size_t& n,
bool& is_null,
bool v)
{
is_null = false;
n = v ? 4 : 5;
if (n > b.capacity ())
b.capacity (n);
std::memcpy (b.data (), (v ? "true" : "false"), n);
}
};
// Mapping of date to PostgreSQL DATE. DATE is stored as the number
// of days since the PostgreSQL epoch 2000-01-01.
//
template <>
class value_traits<date, id_date>
{
public:
typedef date value_type;
typedef date query_type;
typedef int image_type;
// The difference between the PostgreSQL epoch and the Unix epoch
// in seconds.
//
static const time_t epoch_diff = 946684800;
static const time_t seconds_per_day = 86400;
static void
set_value (date& v, const int& i, bool is_null)
{
if (is_null)
{
v = date (0, 0, 0);
return;
}
time_t v_tt (epoch_diff +
static_cast<time_t> (details::endian_traits::ntoh (i)) *
seconds_per_day);
// Assume that the date is specified as UTC. Use localtime so as
// to avoid any timeshift that could be introduced by the system
// time locale not being UTC.
//
tm v_tm (*localtime (&v_tt));
v = date (v_tm.tm_year + 1900, v_tm.tm_mon, v_tm.tm_mday);
}
static void
set_image (int& i, bool& is_null, const date& v)
{
is_null = false;
tm v_tm;
memset (&v_tm, 0, sizeof (v_tm));
v_tm.tm_mday = v.day ();
v_tm.tm_mon = v.month ();
v_tm.tm_year = v.year () - 1900;
time_t v_tt (mktime (&v_tm));
i = details::endian_traits::hton (
static_cast<int> ((v_tt - epoch_diff) / seconds_per_day));
}
};
}
}
#endif // TRAITS_PGSQL_HXX
|
