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
|
// file : mapping/person.hxx
// copyright : not copyrighted - public domain
#ifndef PERSON_HXX
#define PERSON_HXX
#include <string>
#include <ostream>
#include <odb/core.hxx>
// In our database boolean values are stored as strings with valid
// values being "true" and "false".
//
#pragma db value(bool) type("VARCHAR(5)")
#pragma db value type("DATE")
class date
{
public:
date (unsigned int year, unsigned int month, unsigned int day)
: year_ (year), month_ (month), day_ (day)
{
}
unsigned int
year () const
{
return year_;
}
unsigned int
month () const
{
return month_;
}
unsigned int
day () const
{
return day_;
}
private:
unsigned int year_;
unsigned int month_;
unsigned int day_;
};
inline std::ostream&
operator<< (std::ostream& os, const date& d)
{
return os << d.year () << '-' << d.month () << '-' << d.day ();
}
#pragma db object
class person
{
public:
person (const std::string& first,
const std::string& last,
const date& born,
bool married)
: first_ (first), last_ (last), born_ (born), married_ (married)
{
}
const std::string&
first () const
{
return first_;
}
const std::string&
last () const
{
return last_;
}
const date&
born () const
{
return born_;
}
bool
married () const
{
return married_;
}
private:
friend class odb::access;
person (): born_ (0, 0, 0) {}
#pragma db id auto
unsigned long id_;
std::string first_;
std::string last_;
date born_;
bool married_;
};
#endif // PERSON_HXX
|
