aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2012-01-13 12:07:50 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2012-01-13 12:07:50 +0200
commitd96e40dc9bee67c5e821da86c27648485291e9f0 (patch)
treeb69d2c8386cb1f4504d1e7a60e9673d2c4b9ed8c
parent0d11910ab413e7e6ed4ca0b8c4d07c713a4db407 (diff)
Boost profile implementation for SQL Server
-rw-r--r--odb/boost/date-time/gregorian-mssql.options13
-rw-r--r--odb/boost/date-time/mssql/gregorian-mapping.hxx17
-rw-r--r--odb/boost/date-time/mssql/gregorian-traits.hxx70
-rw-r--r--odb/boost/date-time/mssql/posix-time-mapping.hxx23
-rw-r--r--odb/boost/date-time/mssql/posix-time-traits.hxx194
-rw-r--r--odb/boost/date-time/posix-time-mssql.options13
6 files changed, 330 insertions, 0 deletions
diff --git a/odb/boost/date-time/gregorian-mssql.options b/odb/boost/date-time/gregorian-mssql.options
new file mode 100644
index 0000000..35f4be3
--- /dev/null
+++ b/odb/boost/date-time/gregorian-mssql.options
@@ -0,0 +1,13 @@
+# file : odb/boost/date-time/gregorian-mssql.options
+# author : Boris Kolpackov <boris@codesynthesis.com>
+# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+# license : GNU GPL v2; see accompanying LICENSE file
+
+--profile boost/version
+
+# Include the default mapping in prologue instead of epilogue to
+# allow the user to override the default mapping.
+#
+--odb-prologue '#include <odb/boost/date-time/mssql/gregorian-mapping.hxx>'
+
+--hxx-prologue '#include <odb/boost/date-time/mssql/gregorian-traits.hxx>'
diff --git a/odb/boost/date-time/mssql/gregorian-mapping.hxx b/odb/boost/date-time/mssql/gregorian-mapping.hxx
new file mode 100644
index 0000000..f5757ce
--- /dev/null
+++ b/odb/boost/date-time/mssql/gregorian-mapping.hxx
@@ -0,0 +1,17 @@
+// file : odb/boost/date-time/mssql/gregorian-mapping.hxx
+// author : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_MAPPING_HXX
+#define ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_MAPPING_HXX
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+// By default map boost::gregorian::date to SQL Server DATE (available
+// only since SQL Server 2008). We use the NULL value to represent
+// not_a_date_time.
+//
+#pragma db value(boost::gregorian::date) type("DATE") null
+
+#endif // ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_MAPPING_HXX
diff --git a/odb/boost/date-time/mssql/gregorian-traits.hxx b/odb/boost/date-time/mssql/gregorian-traits.hxx
new file mode 100644
index 0000000..87767b4
--- /dev/null
+++ b/odb/boost/date-time/mssql/gregorian-traits.hxx
@@ -0,0 +1,70 @@
+// file : odb/boost/date-time/mssql/gregorian-traits.hxx
+// author : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+#include <odb/core.hxx>
+#include <odb/mssql/traits.hxx>
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+ namespace mssql
+ {
+ template <>
+ class value_traits< ::boost::gregorian::date, id_date>
+ {
+ public:
+ typedef ::boost::gregorian::date value_type;
+ typedef value_type query_type;
+ typedef date image_type;
+
+ static void
+ set_value (value_type& v, const date& i, bool is_null)
+ {
+ if (is_null)
+ v = value_type (::boost::date_time::not_a_date_time);
+ else
+ v = value_type (static_cast<value_type::year_type> (i.year),
+ static_cast<value_type::month_type> (i.month),
+ static_cast<value_type::day_type> (i.day));
+ }
+
+ static void
+ set_image (date& i, bool& is_null, const value_type& v)
+ {
+ if (v.is_special ())
+ {
+ if (v.is_not_a_date ())
+ is_null = true;
+ else
+ throw odb::boost::date_time::special_value ();
+ }
+ else
+ {
+ is_null = false;
+ i.year = static_cast<SQLSMALLINT> (v.year ());
+ i.month = static_cast<SQLUSMALLINT> (v.month ());
+ i.day = static_cast<SQLUSMALLINT> (v.day ());
+ }
+ }
+ };
+
+ template <>
+ struct default_type_traits< ::boost::gregorian::date>
+ {
+ static const database_type_id db_type_id = id_date;
+ };
+ }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_BOOST_DATE_TIME_MSSQL_GREGORIAN_TRAITS_HXX
diff --git a/odb/boost/date-time/mssql/posix-time-mapping.hxx b/odb/boost/date-time/mssql/posix-time-mapping.hxx
new file mode 100644
index 0000000..1bbdd51
--- /dev/null
+++ b/odb/boost/date-time/mssql/posix-time-mapping.hxx
@@ -0,0 +1,23 @@
+// file : odb/boost/date-time/mssql/posix-time-mapping.hxx
+// author : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_MAPPING_HXX
+#define ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_MAPPING_HXX
+
+#include <boost/date_time/posix_time/posix_time_types.hpp>
+
+// By default map boost::posix_time::ptime to SQL Server DATETIME2
+// (available only since SQL Server 2008). We use the NULL value to
+// represent not_a_date_time.
+//
+#pragma db value(boost::posix_time::ptime) type("DATETIME2") null
+
+// By default map boost::posix_time::time_duration to SQL Server TIME
+// (available only since SQL Server 2008). We use the NULL value to
+// represent not_a_date_time.
+//
+#pragma db value(boost::posix_time::time_duration) type("TIME") null
+
+#endif // ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_MAPPING_HXX
diff --git a/odb/boost/date-time/mssql/posix-time-traits.hxx b/odb/boost/date-time/mssql/posix-time-traits.hxx
new file mode 100644
index 0000000..66e89bd
--- /dev/null
+++ b/odb/boost/date-time/mssql/posix-time-traits.hxx
@@ -0,0 +1,194 @@
+// file : odb/boost/date-time/mssql/posix-time-traits.hxx
+// author : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <boost/date_time/posix_time/posix_time_types.hpp>
+
+#include <odb/core.hxx>
+#include <odb/mssql/traits.hxx>
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+ namespace mssql
+ {
+ template <>
+ class value_traits< ::boost::posix_time::ptime, id_datetime>
+ {
+ public:
+ typedef ::boost::posix_time::ptime ptime;
+ typedef ::boost::posix_time::time_duration time_duration;
+ typedef ::boost::gregorian::date date;
+ typedef ptime value_type;
+ typedef ptime query_type;
+ typedef datetime image_type;
+
+ static void
+ set_value (ptime& v, const datetime& i, bool is_null)
+ {
+ if (is_null)
+ v = ptime (::boost::date_time::not_a_date_time);
+ else
+ {
+ unsigned long long fract_s (i.fraction);
+ fract_s = fract_s * time_duration::ticks_per_second () /
+ 1000000000ULL;
+
+ v = ptime (
+ date (static_cast<date::year_type> (i.year),
+ static_cast<date::month_type> (i.month),
+ static_cast<date::day_type> (i.day)),
+ time_duration (
+ static_cast<time_duration::hour_type> (i.hour),
+ static_cast<time_duration::min_type> (i.minute),
+ static_cast<time_duration::sec_type> (i.second),
+ static_cast<time_duration::fractional_seconds_type> (fract_s)));
+ }
+ }
+
+ static void
+ set_image (datetime& i, unsigned short s, bool& is_null, const ptime& v)
+ {
+ if (v.is_special ())
+ {
+ if (v.is_not_a_date_time ())
+ is_null = true;
+ else
+ throw odb::boost::date_time::special_value ();
+ }
+ else
+ {
+ const date& d (v.date ());
+ const time_duration& t (v.time_of_day ());
+
+ is_null = false;
+ i.year = static_cast<SQLSMALLINT> (d.year ());
+ i.month = static_cast<SQLUSMALLINT> (d.month ());
+ i.day = static_cast<SQLUSMALLINT> (d.day ());
+ i.hour = static_cast<SQLUSMALLINT> (t.hours ());
+ i.minute = static_cast<SQLUSMALLINT> (t.minutes ());
+
+ // Scale value 8 indicates we are dealing with SMALLDATETIME
+ // which has the minutes precision.
+ //
+ if (s != 8)
+ {
+ i.second = static_cast<SQLUSMALLINT> (t.seconds ());
+
+ unsigned long long ns (t.fractional_seconds ());
+ ns = ns * 1000000000ULL / time_duration::ticks_per_second ();
+
+ const unsigned int divider[8] =
+ {
+ 1000000000,
+ 100000000,
+ 10000000,
+ 1000000,
+ 100000,
+ 10000,
+ 1000,
+ 100
+ };
+
+ i.fraction = static_cast<SQLUINTEGER> (ns - ns % divider[s]);
+ }
+ else
+ {
+ i.second = 0;
+ i.fraction = 0;
+ }
+ }
+ }
+ };
+
+ template <>
+ class value_traits< ::boost::posix_time::time_duration, id_time>
+ {
+ public:
+ typedef ::boost::posix_time::time_duration time_duration;
+ typedef time_duration value_type;
+ typedef time_duration query_type;
+ typedef time image_type;
+
+ static void
+ set_value (time_duration& v, const time& i, bool is_null)
+ {
+ if (is_null)
+ v = time_duration (::boost::date_time::not_a_date_time);
+ else
+ {
+ unsigned long long fract_s (i.fraction);
+ fract_s = fract_s * time_duration::ticks_per_second () /
+ 1000000000ULL;
+
+ v = time_duration (
+ static_cast<time_duration::hour_type> (i.hour),
+ static_cast<time_duration::min_type> (i.minute),
+ static_cast<time_duration::sec_type> (i.second),
+ static_cast<time_duration::fractional_seconds_type> (fract_s));
+ }
+ }
+
+ static void
+ set_image (time& i,
+ unsigned short s,
+ bool& is_null,
+ const time_duration& v)
+ {
+ if (v.is_special ())
+ {
+ if (v.is_not_a_date_time ())
+ is_null = true;
+ else
+ throw odb::boost::date_time::special_value ();
+ }
+ else if (v.is_negative () || v.hours () > 23)
+ throw odb::boost::date_time::value_out_of_range ();
+ else
+ {
+ is_null = false;
+ i.hour = static_cast<SQLUSMALLINT> (v.hours ());
+ i.minute = static_cast<SQLUSMALLINT> (v.minutes ());
+ i.second = static_cast<SQLUSMALLINT> (v.seconds ());
+
+ unsigned long long ns (v.fractional_seconds ());
+ ns = ns * 1000000000ULL / time_duration::ticks_per_second ();
+
+ const unsigned int divider[8] =
+ {
+ 1000000000,
+ 100000000,
+ 10000000,
+ 1000000,
+ 100000,
+ 10000,
+ 1000,
+ 100
+ };
+
+ i.fraction = static_cast<SQLUINTEGER> (ns - ns % divider[s]);
+ }
+ }
+ };
+
+ template <>
+ struct default_type_traits< ::boost::posix_time::ptime>
+ {
+ static const database_type_id db_type_id = id_datetime;
+ };
+
+ template <>
+ struct default_type_traits< ::boost::posix_time::time_duration>
+ {
+ static const database_type_id db_type_id = id_time;
+ };
+ }
+}
+
+#endif // ODB_BOOST_DATE_TIME_MSSQL_POSIX_TIME_TRAITS_HXX
diff --git a/odb/boost/date-time/posix-time-mssql.options b/odb/boost/date-time/posix-time-mssql.options
new file mode 100644
index 0000000..e9821c8
--- /dev/null
+++ b/odb/boost/date-time/posix-time-mssql.options
@@ -0,0 +1,13 @@
+# file : odb/boost/date-time/posix-time-mssql.options
+# author : Constantin Michael <constantin@codesynthesis.com>
+# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+# license : GNU GPL v2; see accompanying LICENSE file
+
+--profile boost/version
+
+# Include the default mapping in prologue instead of epilogue to
+# allow the user to override the default mapping.
+#
+--odb-prologue '#include <odb/boost/date-time/mssql/posix-time-mapping.hxx>'
+
+--hxx-prologue '#include <odb/boost/date-time/mssql/posix-time-traits.hxx>'