aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Shepanski <michael@codesynthesis.com>2014-11-04 16:10:03 +1100
committerBoris Kolpackov <boris@codesynthesis.com>2014-11-10 16:51:45 +0200
commit05ff680189f689d5bf82cd514e9d650c59aaf3da (patch)
tree9a64337b5867011b900dc7b0547a99c78ddf9f98
parentc1b5f35457db2cccdebc9bef93126758476a15c1 (diff)
Implement {query,execute}_{one,value}() shortcut functions
Useful in situations where the query is know to return at most one element (*_one) or exactly one element (*_value).
-rw-r--r--odb/mssql/database.hxx62
-rw-r--r--odb/mssql/database.ixx120
2 files changed, 182 insertions, 0 deletions
diff --git a/odb/mssql/database.hxx b/odb/mssql/database.hxx
index b949892..4ac85d2 100644
--- a/odb/mssql/database.hxx
+++ b/odb/mssql/database.hxx
@@ -348,6 +348,68 @@ namespace odb
result<T>
query (const odb::query_base&);
+ // Query one API.
+ //
+ template <typename T>
+ typename object_traits<T>::pointer_type
+ query_one ();
+
+ template <typename T>
+ bool
+ query_one (T& object);
+
+ template <typename T>
+ T
+ query_value ();
+
+ template <typename T>
+ typename object_traits<T>::pointer_type
+ query_one (const char*);
+
+ template <typename T>
+ bool
+ query_one (const char*, T& object);
+
+ template <typename T>
+ T
+ query_value (const char*);
+
+ template <typename T>
+ typename object_traits<T>::pointer_type
+ query_one (const std::string&);
+
+ template <typename T>
+ bool
+ query_one (const std::string&, T& object);
+
+ template <typename T>
+ T
+ query_value (const std::string&);
+
+ template <typename T>
+ typename object_traits<T>::pointer_type
+ query_one (const mssql::query_base&);
+
+ template <typename T>
+ bool
+ query_one (const mssql::query_base&, T& object);
+
+ template <typename T>
+ T
+ query_value (const mssql::query_base&);
+
+ template <typename T>
+ typename object_traits<T>::pointer_type
+ query_one (const odb::query_base&);
+
+ template <typename T>
+ bool
+ query_one (const odb::query_base&, T& object);
+
+ template <typename T>
+ T
+ query_value (const odb::query_base&);
+
// Query preparation.
//
template <typename T>
diff --git a/odb/mssql/database.ixx b/odb/mssql/database.ixx
index cd79eef..93919f6 100644
--- a/odb/mssql/database.ixx
+++ b/odb/mssql/database.ixx
@@ -429,6 +429,126 @@ namespace odb
}
template <typename T>
+ inline typename object_traits<T>::pointer_type database::
+ query_one ()
+ {
+ return query_one<T> (mssql::query_base ());
+ }
+
+ template <typename T>
+ inline bool database::
+ query_one (T& o)
+ {
+ return query_one<T> (mssql::query_base (), o);
+ }
+
+ template <typename T>
+ inline T database::
+ query_value ()
+ {
+ return query_value<T> (mssql::query_base ());
+ }
+
+ template <typename T>
+ inline typename object_traits<T>::pointer_type database::
+ query_one (const char* q)
+ {
+ return query_one<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
+ inline bool database::
+ query_one (const char* q, T& o)
+ {
+ return query_one<T> (mssql::query_base (q), o);
+ }
+
+ template <typename T>
+ inline T database::
+ query_value (const char* q)
+ {
+ return query_value<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
+ inline typename object_traits<T>::pointer_type database::
+ query_one (const std::string& q)
+ {
+ return query_one<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
+ inline bool database::
+ query_one (const std::string& q, T& o)
+ {
+ return query_one<T> (mssql::query_base (q), o);
+ }
+
+ template <typename T>
+ inline T database::
+ query_value (const std::string& q)
+ {
+ return query_value<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
+ inline typename object_traits<T>::pointer_type database::
+ query_one (const mssql::query_base& q)
+ {
+ // T is always object_type. We also don't need to check for transaction
+ // here; object_traits::query () does this.
+ //
+ return query_one_<T, id_mssql> (q);
+ }
+
+ template <typename T>
+ inline bool database::
+ query_one (const mssql::query_base& q, T& o)
+ {
+ // T is always object_type. We also don't need to check for transaction
+ // here; object_traits::query () does this.
+ //
+ return query_one_<T, id_mssql> (q, o);
+ }
+
+ template <typename T>
+ inline T database::
+ query_value (const mssql::query_base& q)
+ {
+ // T is always object_type. We also don't need to check for transaction
+ // here; object_traits::query () does this.
+ //
+ return query_value_<T, id_mssql> (q);
+ }
+
+ template <typename T>
+ inline typename object_traits<T>::pointer_type database::
+ query_one (const odb::query_base& q)
+ {
+ // Translate to native query.
+ //
+ return query_one<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
+ inline bool database::
+ query_one (const odb::query_base& q, T& o)
+ {
+ // Translate to native query.
+ //
+ return query_one<T> (mssql::query_base (q), o);
+ }
+
+ template <typename T>
+ inline T database::
+ query_value (const odb::query_base& q)
+ {
+ // Translate to native query.
+ //
+ return query_value<T> (mssql::query_base (q));
+ }
+
+ template <typename T>
inline prepared_query<T> database::
prepare_query (const char* n, const char* q)
{