From f3f9389365a03603c6f9bcc4d502ff4049c72fe2 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Tue, 10 Jul 2012 15:17:12 +0200 Subject: Add support for custom database type mapping New pragma qualifier, map, and specifiers: as, to, from. New tests: /custom. --- odb/mssql/details/conversion.hxx | 59 ++++++++++++++++++++++++++++++++++++++ odb/mssql/query.cxx | 18 +++++++++++- odb/mssql/query.hxx | 61 +++++++++++++++++++++++++--------------- odb/mssql/query.ixx | 10 ++++--- odb/mssql/query.txx | 33 +++++++++++----------- 5 files changed, 138 insertions(+), 43 deletions(-) create mode 100644 odb/mssql/details/conversion.hxx diff --git a/odb/mssql/details/conversion.hxx b/odb/mssql/details/conversion.hxx new file mode 100644 index 0000000..4b419da --- /dev/null +++ b/odb/mssql/details/conversion.hxx @@ -0,0 +1,59 @@ +// file : odb/mssql/details/conversion.hxx +// copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC +// license : GNU GPL v2; see accompanying LICENSE file + +#ifndef ODB_MSSQL_DETAILS_CONVERSION_HXX +#define ODB_MSSQL_DETAILS_CONVERSION_HXX + +#include + +#include + +namespace odb +{ + // @@ Revise this. + // + namespace details {} + + namespace mssql + { + namespace details + { + using namespace odb::details; + + // Detect whether conversion is specified in type_traits. + // + template + meta::yes + conversion_p_test (typename type_traits::conversion*); + + template + meta::no + conversion_p_test (...); + + template + struct conversion_p + { + static const bool value = + sizeof (conversion_p_test (0)) == sizeof (meta::yes); + }; + + template ::value> + struct conversion; + + template + struct conversion + { + static const char* to () {return type_traits::conversion::to ();} + }; + + template + struct conversion + { + static const char* to () {return 0;} + }; + } + } +} + +#endif // ODB_MSSQL_DETAILS_CONVERSION_HXX diff --git a/odb/mssql/query.cxx b/odb/mssql/query.cxx index 368cd82..07dba0e 100644 --- a/odb/mssql/query.cxx +++ b/odb/mssql/query.cxx @@ -118,10 +118,13 @@ namespace odb } void query:: - add (details::shared_ptr p) + add (details::shared_ptr p, const char* conv) { clause_.push_back (clause_part (clause_part::param)); + if (conv != 0) + clause_.back ().part = conv; + parameters_.push_back (p); bind_.push_back (bind ()); binding_.bind = &bind_[0]; @@ -258,7 +261,20 @@ namespace odb if (last != ' ' && last != '(') r += ' '; + // Add the conversion expression, if any. + // + string::size_type p; + if (!i->part.empty ()) + { + p = i->part.find ("(?)"); + r.append (i->part, 0, p); + } + r += '?'; + + if (!i->part.empty ()) + r.append (i->part, p + 3, string::npos); + break; } case clause_part::native: diff --git a/odb/mssql/query.hxx b/odb/mssql/query.hxx index 5b5ea57..4844463 100644 --- a/odb/mssql/query.hxx +++ b/odb/mssql/query.hxx @@ -24,6 +24,7 @@ #include #include +#include namespace odb { @@ -121,7 +122,7 @@ namespace odb clause_part (bool p): kind (boolean), bool_part (p) {} kind_type kind; - std::string part; + std::string part; // If kind is param, then part is conversion expr. bool bool_part; }; @@ -164,7 +165,8 @@ namespace odb query (val_bind v) : binding_ (0, 0) { - append::db_type_id> (v); + append::db_type_id> ( + v, details::conversion::to ()); } template @@ -172,7 +174,8 @@ namespace odb query (ref_bind r) : binding_ (0, 0) { - append::db_type_id> (r); + append::db_type_id> ( + r, details::conversion::to ()); } template @@ -243,7 +246,8 @@ namespace odb query& operator+= (val_bind v) { - append::db_type_id> (v); + append::db_type_id> ( + v, details::conversion::to ()); return *this; } @@ -251,18 +255,19 @@ namespace odb query& operator+= (ref_bind r) { - append::db_type_id> (r); + append::db_type_id> ( + r, details::conversion::to ()); return *this; } public: template void - append (val_bind); + append (val_bind, const char* conv); template void - append (ref_bind); + append (ref_bind, const char* conv); void append (const std::string& native); @@ -272,7 +277,7 @@ namespace odb private: void - add (details::shared_ptr); + add (details::shared_ptr, const char* conv); private: typedef std::vector clause_type; @@ -413,13 +418,16 @@ namespace odb template struct query_column { - // Note that we keep shalow copies of the table and column names. + // Note that we keep shalow copies of the table, column, and conversion + // expression. The latter can be NULL. // query_column (const char* table, const char* column, + const char* conv, unsigned short prec = 0, unsigned short scale = 0xFFFF) - : table_ (table), column_ (column), prec_ (prec), scale_ (scale) + : table_ (table), column_ (column), conversion_ (conv), + prec_ (prec), scale_ (scale) { } @@ -435,6 +443,14 @@ namespace odb return column_; } + // Can be NULL. + // + const char* + conversion () const + { + return conversion_; + } + unsigned short prec () const { @@ -502,7 +518,7 @@ namespace odb query q (table_, column_); q += "="; - q.append (v); + q.append (v, conversion_); return q; } @@ -522,7 +538,7 @@ namespace odb query q (table_, column_); q += "="; - q.append (r); + q.append (r, conversion_); return q; } @@ -593,7 +609,7 @@ namespace odb query q (table_, column_); q += "!="; - q.append (v); + q.append (v, conversion_); return q; } @@ -613,7 +629,7 @@ namespace odb query q (table_, column_); q += "!="; - q.append (r); + q.append (r, conversion_); return q; } @@ -684,7 +700,7 @@ namespace odb query q (table_, column_); q += "<"; - q.append (v); + q.append (v, conversion_); return q; } @@ -704,7 +720,7 @@ namespace odb query q (table_, column_); q += "<"; - q.append (r); + q.append (r, conversion_); return q; } @@ -775,7 +791,7 @@ namespace odb query q (table_, column_); q += ">"; - q.append (v); + q.append (v, conversion_); return q; } @@ -795,7 +811,7 @@ namespace odb query q (table_, column_); q += ">"; - q.append (r); + q.append (r, conversion_); return q; } @@ -866,7 +882,7 @@ namespace odb query q (table_, column_); q += "<="; - q.append (v); + q.append (v, conversion_); return q; } @@ -886,7 +902,7 @@ namespace odb query q (table_, column_); q += "<="; - q.append (r); + q.append (r, conversion_); return q; } @@ -957,7 +973,7 @@ namespace odb query q (table_, column_); q += ">="; - q.append (v); + q.append (v, conversion_); return q; } @@ -977,7 +993,7 @@ namespace odb query q (table_, column_); q += ">="; - q.append (r); + q.append (r, conversion_); return q; } @@ -1121,6 +1137,7 @@ namespace odb private: const char* table_; const char* column_; + const char* conversion_; unsigned short prec_; unsigned short scale_; diff --git a/odb/mssql/query.ixx b/odb/mssql/query.ixx index e7f2399..0476b26 100644 --- a/odb/mssql/query.ixx +++ b/odb/mssql/query.ixx @@ -8,20 +8,22 @@ namespace odb { template inline void query:: - append (val_bind v) + append (val_bind v, const char* conv) { add ( details::shared_ptr ( - new (details::shared) query_param_impl (v))); + new (details::shared) query_param_impl (v)), + conv); } template inline void query:: - append (ref_bind r) + append (ref_bind r, const char* conv) { add ( details::shared_ptr ( - new (details::shared) query_param_impl (r))); + new (details::shared) query_param_impl (r)), + conv); } } } diff --git a/odb/mssql/query.txx b/odb/mssql/query.txx index a86c039..522059a 100644 --- a/odb/mssql/query.txx +++ b/odb/mssql/query.txx @@ -19,7 +19,8 @@ namespace odb // append (c.table (), c.column ()); append ("="); - append (val_bind (true, c.prec (), c.scale ())); + append (val_bind (true, c.prec (), c.scale ()), + c.conversion ()); } // query_column @@ -30,9 +31,9 @@ namespace odb { query q (table_, column_); q += "IN ("; - q.append (val_bind (v1, prec_, scale_)); + q.append (val_bind (v1, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v2, prec_, scale_)); + q.append (val_bind (v2, prec_, scale_), conversion_); q += ")"; return q; } @@ -43,11 +44,11 @@ namespace odb { query q (table_, column_); q += "IN ("; - q.append (val_bind (v1, prec_, scale_)); + q.append (val_bind (v1, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v2, prec_, scale_)); + q.append (val_bind (v2, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v3, prec_, scale_)); + q.append (val_bind (v3, prec_, scale_), conversion_); q += ")"; return q; } @@ -58,13 +59,13 @@ namespace odb { query q (table_, column_); q += "IN ("; - q.append (val_bind (v1, prec_, scale_)); + q.append (val_bind (v1, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v2, prec_, scale_)); + q.append (val_bind (v2, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v3, prec_, scale_)); + q.append (val_bind (v3, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v4, prec_, scale_)); + q.append (val_bind (v4, prec_, scale_), conversion_); q += ")"; return q; } @@ -75,15 +76,15 @@ namespace odb { query q (table_, column_); q += "IN ("; - q.append (val_bind (v1, prec_, scale_)); + q.append (val_bind (v1, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v2, prec_, scale_)); + q.append (val_bind (v2, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v3, prec_, scale_)); + q.append (val_bind (v3, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v4, prec_, scale_)); + q.append (val_bind (v4, prec_, scale_), conversion_); q += ","; - q.append (val_bind (v5, prec_, scale_)); + q.append (val_bind (v5, prec_, scale_), conversion_); q += ")"; return q; } @@ -101,7 +102,7 @@ namespace odb if (i != begin) q += ","; - q.append (val_bind (*i, prec_, scale_)); + q.append (val_bind (*i, prec_, scale_), conversion_); } q += ")"; return q; -- cgit v1.1