From d96e40dc9bee67c5e821da86c27648485291e9f0 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Fri, 13 Jan 2012 12:07:50 +0200 Subject: Boost profile implementation for SQL Server --- odb/boost/date-time/gregorian-mssql.options | 13 ++ odb/boost/date-time/mssql/gregorian-mapping.hxx | 17 ++ odb/boost/date-time/mssql/gregorian-traits.hxx | 70 ++++++++ odb/boost/date-time/mssql/posix-time-mapping.hxx | 23 +++ odb/boost/date-time/mssql/posix-time-traits.hxx | 194 +++++++++++++++++++++++ odb/boost/date-time/posix-time-mssql.options | 13 ++ 6 files changed, 330 insertions(+) create mode 100644 odb/boost/date-time/gregorian-mssql.options create mode 100644 odb/boost/date-time/mssql/gregorian-mapping.hxx create mode 100644 odb/boost/date-time/mssql/gregorian-traits.hxx create mode 100644 odb/boost/date-time/mssql/posix-time-mapping.hxx create mode 100644 odb/boost/date-time/mssql/posix-time-traits.hxx create mode 100644 odb/boost/date-time/posix-time-mssql.options 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 +# 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 ' + +--hxx-prologue '#include ' 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 +// 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 + +// 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 +// 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 + +#include + +#include +#include +#include + +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 (i.year), + static_cast (i.month), + static_cast (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 (v.year ()); + i.month = static_cast (v.month ()); + i.day = static_cast (v.day ()); + } + } + }; + + template <> + struct default_type_traits< ::boost::gregorian::date> + { + static const database_type_id db_type_id = id_date; + }; + } +} + +#include + +#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 +// 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 + +// 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 +// 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 + +#include + +#include +#include +#include + +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 (i.year), + static_cast (i.month), + static_cast (i.day)), + time_duration ( + static_cast (i.hour), + static_cast (i.minute), + static_cast (i.second), + static_cast (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 (d.year ()); + i.month = static_cast (d.month ()); + i.day = static_cast (d.day ()); + i.hour = static_cast (t.hours ()); + i.minute = static_cast (t.minutes ()); + + // Scale value 8 indicates we are dealing with SMALLDATETIME + // which has the minutes precision. + // + if (s != 8) + { + i.second = static_cast (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 (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 (i.hour), + static_cast (i.minute), + static_cast (i.second), + static_cast (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 (v.hours ()); + i.minute = static_cast (v.minutes ()); + i.second = static_cast (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 (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 +# 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 ' + +--hxx-prologue '#include ' -- cgit v1.1