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
|
// file : boost/mysql/date-time/test.hxx
// copyright : Copyright (c) 2009-2015 Code Synthesis Tools CC
// license : GNU GPL v2; see accompanying LICENSE file
#ifndef TEST_HXX
#define TEST_HXX
#include <vector>
#include <boost/date_time/gregorian/gregorian_types.hpp>
#include <boost/date_time/posix_time/posix_time_types.hpp>
#include <odb/core.hxx>
#pragma db object
struct object
{
object ()
{
}
bool
operator== (const object& x) const
{
return
id == x.id &&
dates == x.dates &&
times == x.times &&
timestamps == x.timestamps &&
durations == x.durations;
}
#pragma db id auto
unsigned long id;
std::vector<boost::gregorian::date> dates;
std::vector<boost::posix_time::ptime> times;
// Make timestamp NULL-able to suppress the auto-initialization and
// auto-update characteristics of the TIMESTAMP datatype, and to
// allow NULL values.
//
#pragma db value_type ("TIMESTAMP") value_null
std::vector<boost::posix_time::ptime> timestamps;
std::vector<boost::posix_time::time_duration> durations;
};
// MySQL server version view.
//
#pragma db view query( \
"SELECT " \
"CAST(SUBSTRING_INDEX(@@version, '.', 1) AS UNSIGNED)," \
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@@version, '.', 2), '.', -1) AS UNSIGNED)," \
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@@version, '-', 1), '.', -1) AS UNSIGNED)," \
"@@protocol_version")
struct mysql_version
{
unsigned int major;
unsigned int minor;
unsigned int release;
unsigned int protocol;
};
#endif // TEST_HXX
|
