From 8bf752fc2354af4e98a43e208d1eb18c8a71e48b Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Mon, 5 Sep 2011 10:36:33 +0200 Subject: Support for views; native part --- common/view/test.hxx | 114 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 114 insertions(+) create mode 100644 common/view/test.hxx (limited to 'common/view/test.hxx') diff --git a/common/view/test.hxx b/common/view/test.hxx new file mode 100644 index 0000000..9ceed60 --- /dev/null +++ b/common/view/test.hxx @@ -0,0 +1,114 @@ +// file : common/view/test.hxx +// author : Boris Kolpackov +// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +// license : GNU GPL v2; see accompanying LICENSE file + +#ifndef TEST_HXX +#define TEST_HXX + +#include +#include +#include // std::size_t +#include + +#include + +#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 -- cgit v1.1