aboutsummaryrefslogtreecommitdiff
path: root/pgsql/custom/test.hxx
blob: ab6de49cfb3b5b650a25466067bb2d227034e7bc (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
// file      : pgsql/custom/test.hxx
// copyright : Copyright (c) 2009-2013 Code Synthesis Tools CC
// license   : GNU GPL v2; see accompanying LICENSE file

#ifndef TEST_HXX
#define TEST_HXX

#include <string>
#include <vector>

#include <odb/core.hxx>

// Map POINT PostgreSQL type to the point C++ struct. The other half
// of this mapping is in traits.hxx (value_traits<point, id_string>).
//
#pragma db map type("POINT") as("TEXT") to("(?)::POINT") from("(?)::TEXT")

#pragma db value type("POINT")
struct point
{
  point () {}
  point (double x_, double y_): x (x_), y (y_) {}

  double x;
  double y;
};

inline bool
operator== (const point& a, const point& b)
{
  return a.x == b.x && a.y == b.y;
}

// Map NUMERIC PostgreSQL type to std::string (or any other type that
// provides the value_traits<?, id_string> specialization).
//
#pragma db map type("NUMERIC *(\\(.+\\))?") \
               as("TEXT")                   \
               to("(?)::NUMERIC$1")         \
               from("(?)::TEXT")

// Map INTEGER[] PostgreSQL type to std::vector<int>. The other half of
// this mapping is in traits.hxx (value_traits<std::vector<int>, id_string>).
//
#pragma db map type("INTEGER *\\[(\\d*)\\]") \
               as("TEXT")                    \
               to("(?)::INTEGER[$1]")        \
               from("(?)::TEXT")

#pragma db object
struct object
{
  object () {}
  object (unsigned long id_) : id (id_) {}

  #pragma db id
  unsigned long id;

  point p;
  std::vector<point> pv;

  #pragma db type("NUMERIC(6, 4)")
  std::string n1;

  #pragma db type("NUMERIC(6)")
  std::string n2;

  #pragma db type("NUMERIC")
  std::string n3;

  #pragma db type("INTEGER [123]")
  std::vector<int> iv;

  bool
  operator== (const object& y) const
  {
    return id == y.id &&
           p == y.p   &&
           pv == y.pv &&
           n1 == y.n1 &&
           n2 == y.n2 &&
           n3 == y.n3 &&
           iv == y.iv;
  }
};

#endif // TEST_HXX