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).

2 files changed, 182 insertions, 0 deletions

diff --git a/odb/mysql/database.hxx b/odb/mysql/database.hxx
index af4fcfe..8d11e72 100644
--- a/odb/mysql/database.hxx
+++ b/odb/mysql/database.hxx
@@ -375,6 +375,68 @@ namespace odb
       result<T>
       query (const odb::query_base&, bool cache = true);
 
+      // 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 mysql::query_base&);
+
+      template <typename T>
+      bool
+      query_one (const mysql::query_base&, T& object);
+
+      template <typename T>
+      T
+      query_value (const mysql::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/mysql/database.ixx b/odb/mysql/database.ixx
index 475e7e1..09fc641 100644
--- a/odb/mysql/database.ixx
+++ b/odb/mysql/database.ixx
@@ -434,6 +434,126 @@ namespace odb
     }
 
     template <typename T>
+    inline typename object_traits<T>::pointer_type database::
+    query_one ()
+    {
+      return query_one<T> (mysql::query_base ());
+    }
+
+    template <typename T>
+    inline bool database::
+    query_one (T& o)
+    {
+      return query_one<T> (mysql::query_base (), o);
+    }
+
+    template <typename T>
+    inline T database::
+    query_value ()
+    {
+      return query_value<T> (mysql::query_base ());
+    }
+
+    template <typename T>
+    inline typename object_traits<T>::pointer_type database::
+    query_one (const char* q)
+    {
+      return query_one<T> (mysql::query_base (q));
+    }
+
+    template <typename T>
+    inline bool database::
+    query_one (const char* q, T& o)
+    {
+      return query_one<T> (mysql::query_base (q), o);
+    }
+
+    template <typename T>
+    inline T database::
+    query_value (const char* q)
+    {
+      return query_value<T> (mysql::query_base (q));
+    }
+
+    template <typename T>
+    inline typename object_traits<T>::pointer_type database::
+    query_one (const std::string& q)
+    {
+      return query_one<T> (mysql::query_base (q));
+    }
+
+    template <typename T>
+    inline bool database::
+    query_one (const std::string& q, T& o)
+    {
+      return query_one<T> (mysql::query_base (q), o);
+    }
+
+    template <typename T>
+    inline T database::
+    query_value (const std::string& q)
+    {
+      return query_value<T> (mysql::query_base (q));
+    }
+
+    template <typename T>
+    inline typename object_traits<T>::pointer_type database::
+    query_one (const mysql::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_mysql> (q);
+    }
+
+    template <typename T>
+    inline bool database::
+    query_one (const mysql::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_mysql> (q, o);
+    }
+
+    template <typename T>
+    inline T database::
+    query_value (const mysql::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_mysql> (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> (mysql::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> (mysql::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> (mysql::query_base (q));
+    }
+
+    template <typename T>
     inline prepared_query<T> database::
     prepare_query (const char* n, const char* q)
     {