aboutsummaryrefslogtreecommitdiff
path: root/common/view/test.hxx
blob: 9ceed60e7802bd0d65c5495acbe567d7aa4d0eaa (plain)
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
// 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;
  unsigned short age;
};

// 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