blob: 6f44a7757152fa12884319e79619abdb6fd02661 (
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
|
// file : mssql/types/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>
#if !defined(MSSQL_SERVER_VERSION) || MSSQL_SERVER_VERSION >= 1000
// Map GEOMETRY SQL Server type to the point C++ struct. The other half
// of this mapping is in traits.hxx (value_traits<point, id_string>).
// Note that GEOMETRY is not available in SQL Server 2005.
//
#pragma db map type("GEOMETRY") \
as("VARCHAR(256)") \
to("GEOMETRY::STGeomFromText((?), 0)") \
from("(?).STAsText()")
#pragma db value type("GEOMETRY")
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;
}
#endif // SQL Server > 2005
// Map XML SQL Server type to std::string (or any other type that provides
// the value_traits<?, id_long_string> specialization). Note also that
// another alternative would be to interface with the XML data type using
// VARBINARY or NVARCHAR. Here we use implicit string to/from XML conversion,
// however, CAST/CONVERT can be used instead for greater control over
// whitespace handling, etc.
//
#pragma db map type("XML *(\\(.+\\))?") as("VARCHAR(max)")
#pragma db object
struct object
{
object () {}
object (unsigned long id_) : id (id_) {}
#pragma db id
unsigned long id;
#if !defined(MSSQL_SERVER_VERSION) || MSSQL_SERVER_VERSION >= 1000
point p;
std::vector<point> pv;
#endif
#pragma db type("XML")
std::string xml;
bool
operator== (const object& y) const
{
return id == y.id
#if !defined(MSSQL_SERVER_VERSION) || MSSQL_SERVER_VERSION >= 1000
&& p == y.p
&& pv == y.pv
#endif
&& xml == y.xml;
}
};
#endif // TEST_HXX
|
