diff options
| author | Boris Kolpackov <boris@codesynthesis.com> | 2010-08-13 13:39:57 +0200 |
|---|---|---|
| committer | Boris Kolpackov <boris@codesynthesis.com> | 2010-08-13 13:39:57 +0200 |
| commit | bad675ea0e17b6eb18d75ddc403b81ff5f76ad25 (patch) | |
| tree | 388a59f0c92eb4f59e812d9e38e4c1a6c8d80471 /odb/mysql/query.txx | |
| parent | 107c3754b2eccd0f2a30121aab9b29c25f83e40c (diff) | |
Add support for language-embedded query
Diffstat (limited to 'odb/mysql/query.txx')
| -rw-r--r-- | odb/mysql/query.txx | 102 |
1 files changed, 90 insertions, 12 deletions
diff --git a/odb/mysql/query.txx b/odb/mysql/query.txx index 23d4ba7..dda0e72 100644 --- a/odb/mysql/query.txx +++ b/odb/mysql/query.txx @@ -7,22 +7,100 @@ namespace odb { namespace mysql { - template <typename T> - query& query:: - operator+= (val_bind<T> v) + // query + // + + template <image_id_type ID> + query:: + query (const query_column<bool, ID>& c) + : clause_ (c.name ()) + { + clause_ += " IS TRUE"; + } + + // query_column + // + template <typename T, image_id_type ID> + query query_column<T, ID>:: + in (const T& v1, const T& v2) const { - add ( - shared_ptr<query_param> ( - new (shared) query_param_impl<T, value_traits<T>::image_id> (v))); + query q (name_); + q += "IN ("; + q.append<T, ID> (val_bind<T> (v1)); + q += ","; + q.append<T, ID> (val_bind<T> (v2)); + q += ")"; + return q; } - template <typename T> - query& query:: - operator+= (ref_bind<T> r) + template <typename T, image_id_type ID> + query query_column<T, ID>:: + in (const T& v1, const T& v2, const T& v3) const { - add ( - shared_ptr<query_param> ( - new (shared) query_param_impl<T, value_traits<T>::image_id> (r))); + query q (name_); + q += "IN ("; + q.append<T, ID> (val_bind<T> (v1)); + q += ","; + q.append<T, ID> (val_bind<T> (v2)); + q += ","; + q.append<T, ID> (val_bind<T> (v3)); + q += ")"; + return q; + } + + template <typename T, image_id_type ID> + query query_column<T, ID>:: + in (const T& v1, const T& v2, const T& v3, const T& v4) const + { + query q (name_); + q += "IN ("; + q.append<T, ID> (val_bind<T> (v1)); + q += ","; + q.append<T, ID> (val_bind<T> (v2)); + q += ","; + q.append<T, ID> (val_bind<T> (v3)); + q += ","; + q.append<T, ID> (val_bind<T> (v4)); + q += ")"; + return q; + } + + template <typename T, image_id_type ID> + query query_column<T, ID>:: + in (const T& v1, const T& v2, const T& v3, const T& v4, const T& v5) const + { + query q (name_); + q += "IN ("; + q.append<T, ID> (val_bind<T> (v1)); + q += ","; + q.append<T, ID> (val_bind<T> (v2)); + q += ","; + q.append<T, ID> (val_bind<T> (v3)); + q += ","; + q.append<T, ID> (val_bind<T> (v4)); + q += ","; + q.append<T, ID> (val_bind<T> (v5)); + q += ")"; + return q; + } + + template <typename T, image_id_type ID> + template <typename I> + query query_column<T, ID>:: + in_range (I begin, I end) const + { + query q (name_); + q += "IN ("; + + for (I i (begin); i != end; ++i) + { + if (i != begin) + q += ","; + + q.append<T, ID> (val_bind<T> (*i)); + } + q += ")"; + return q; } } } |