aboutsummaryrefslogtreecommitdiff
path: root/common/query/basics/test.hxx
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2013-01-24 15:10:22 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2013-01-24 15:10:22 +0200
commit89de275db2b77d0abf9fa1ec066ef11e262c88af (patch)
tree06cb2272c5e791946dc58421ed3f2d03b7c8122e /common/query/basics/test.hxx
parent539c92147e8d58c49f350c4070051a6ddf6b2354 (diff)
Add support for mapping char[N] to CHAR/VARCHAR database types
Also improve query support for arrays (decaying).
Diffstat (limited to 'common/query/basics/test.hxx')
-rw-r--r--common/query/basics/test.hxx84
1 files changed, 84 insertions, 0 deletions
diff --git a/common/query/basics/test.hxx b/common/query/basics/test.hxx
new file mode 100644
index 0000000..f572d75
--- /dev/null
+++ b/common/query/basics/test.hxx
@@ -0,0 +1,84 @@
+// file : common/query/basics/test.hxx
+// copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC
+// license : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef TEST_HXX
+#define TEST_HXX
+
+#include <string>
+#include <vector>
+#include <memory>
+#include <iostream>
+
+#include <odb/core.hxx>
+#include <odb/nullable.hxx>
+
+#ifdef ODB_COMPILER
+# if defined(ODB_DATABASE_PGSQL)
+# define BLOB_TYPE "BYTEA"
+# elif defined(ODB_DATABASE_MSSQL)
+# define BLOB_TYPE "VARBINARY(max)"
+# else
+# define BLOB_TYPE "BLOB"
+# endif
+#endif
+
+typedef std::vector<char> buffer;
+typedef odb::nullable<buffer> nullable_buffer;
+
+#pragma db object
+struct person
+{
+ person (unsigned long id,
+ const std::string& fn,
+ const std::string& ln,
+ unsigned short age,
+ bool married,
+ const nullable_buffer& public_key = nullable_buffer ())
+ : id_ (id),
+ first_name_ (fn),
+ last_name_ (ln),
+ age_ (age),
+ married_ (married),
+ public_key_ (public_key)
+ {
+ }
+
+ person ()
+ {
+ }
+
+ #pragma db id
+ unsigned long id_;
+
+ #pragma db column ("first")
+ std::string first_name_;
+
+ #pragma db column ("middle") null
+ std::auto_ptr<std::string> middle_name_;
+
+ #pragma db column ("last")
+ std::string last_name_;
+
+ unsigned short age_;
+ bool married_;
+
+ #pragma db column ("key") type(BLOB_TYPE) null
+ nullable_buffer public_key_;
+};
+
+inline std::ostream&
+operator<< (std::ostream& os, const person& p)
+{
+ os << p.first_name_;
+
+ if (p.middle_name_.get () != 0)
+ os << ' ' << *p.middle_name_;
+
+ os << ' ' << p.last_name_ << ' ' << p.age_ <<
+ (p.married_ ? " married" : " single");
+
+ return os;
+}
+
+#endif // TEST_HXX