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
|
// file : common/view/test.hxx
// author : Boris Kolpackov <boris@codesynthesis.com>
// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
// license : GNU GPL v2; see accompanying LICENSE file
#ifndef TEST_HXX
#define TEST_HXX
#include <string>
#include <memory>
#include <cstddef> // std::size_t
#include <iostream>
#include <odb/core.hxx>
#pragma db object
struct country
{
country (const std::string& c, std::string const& n)
: code (c), name (n)
{
}
country ()
{
}
#pragma db id
std::string code; // ISO 2-letter country code.
std::string name;
};
#pragma db object
struct person
{
person (unsigned long i,
const std::string& fn,
const std::string& ln,
unsigned short a,
country* l)
: id (i), first_name (fn), last_name (ln), age (a), location (l)
{
}
~person ()
{
delete location;
}
person ()
{
}
#pragma db id
unsigned long id;
#pragma db column ("first")
std::string first_name;
#pragma db column ("last")
std::string last_name;
unsigned short age;
#pragma db not_null
country* location;
};
// General view with a custom query.
//
#pragma db view query("SELECT first, last, age FROM common_view_person")
struct view1
{
std::string first;
std::string last;
unsigned short age;
};
// Count view.
//
#pragma db view query("SELECT count(id) FROM common_view_person")
struct view2
{
std::size_t count;
};
// Aggregate view.
//
#pragma db view query("SELECT last, count(last) " \
"FROM common_view_person " \
"GROUP BY last")
struct view3
{
std::string last;
std::size_t count;
};
// JOIN view.
//
#pragma db view query("SELECT first, last, common_view_country.name " \
"FROM common_view_person " \
"LEFT JOIN common_view_country " \
"ON common_view_person.location = " \
"common_view_country.code")
struct view4
{
std::string first;
std::string last;
std::string location;
};
#endif // TEST_HXX
|
