common/index/test.hxx


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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143

// file      : common/index/test.hxx
// copyright : Copyright (c) 2009-2017 Code Synthesis Tools CC
// license   : GNU GPL v2; see accompanying LICENSE file

#ifndef TEST_HXX
#define TEST_HXX

#include <vector>

#include <odb/core.hxx>

// Test basic functionality.
//
#pragma db namespace table("t1_")
namespace test1
{
  #pragma db object
  struct object
  {
    #pragma db id auto
    unsigned long id_;

    #pragma db index
    int i1;

    #pragma db unique
    int i2;

    #pragma db unique index
    int i3;

    int i4;
    #pragma db index unique member(i4)

    int i5;
    #pragma db index type("UNIQUE") member(i5)

    int i6;
    #pragma db index("object_i6_index") member(i6)

    int i7;
    int i8;
    int i9;

    int i10;
    #pragma db index member(i10, "ASC")
  };

  #pragma db index(object) member(i7)
  #pragma db index(object::"object_i8_index") member(i8)
}

#pragma db index(test1::object::"object_i9_index") member(i9)

// Test composite indexes.
//
#pragma db namespace table("t2_")
namespace test2
{
  #pragma db value
  struct nested
  {
    int x;
    int y;
  };

  #pragma db value
  struct comp
  {
    int x;
    int y;
    nested n;
  };

  #pragma db object
  struct object
  {
    #pragma db id auto
    unsigned long id_;

    int i1a;
    int i1b;
    #pragma db index("object_i1_i") member(i1a) member(i1b)

    int i2a;
    int i2b;
    #pragma db index("object_i2_i") members(i2a, i2b)

    #pragma db index
    comp c1;

    #pragma db index column("")
    comp c2;

    comp c3;
    #pragma db index member(c3.x)
    #pragma db index member(c3.y)

    comp c4;
    #pragma db index("object_c4_i") members(c4.x, c4.y, c4.n.x)

    comp c5;
    int i5;
    #pragma db index("object_ci5_i") member(c5) member(i5)
  };
}

// Test container indexes.
//
#pragma db namespace table("t3_")
namespace test3
{
  #pragma db value
  struct id
  {
    int x;
    int y;
  };

  #pragma db value
  struct comp
  {
    int x;
    std::vector<int> v;
  };

  #pragma db object
  struct object
  {
    #pragma db id
    id id_;

    std::vector<int> v;
    #pragma db index unique member(v.id)
    #pragma db index("object_v_index_index") member(v.index)

    comp c;
    #pragma db index("object_c_v_id_index") member(c.v.id)
    #pragma db index unique member(c.v.index)
  };
}

#endif // TEST_HXX