diff options
| -rw-r--r-- | odb/boost/date-time/gregorian-oracle.options | 9 | ||||
| -rw-r--r-- | odb/boost/date-time/oracle/gregorian-mapping.hxx | 16 | ||||
| -rw-r--r-- | odb/boost/date-time/oracle/gregorian-traits.hxx | 85 | ||||
| -rw-r--r-- | odb/boost/date-time/oracle/posix-time-mapping.hxx | 22 | ||||
| -rw-r--r-- | odb/boost/date-time/oracle/posix-time-traits.hxx | 174 | ||||
| -rw-r--r-- | odb/boost/date-time/posix-time-oracle.options | 9 |
6 files changed, 315 insertions, 0 deletions
diff --git a/odb/boost/date-time/gregorian-oracle.options b/odb/boost/date-time/gregorian-oracle.options new file mode 100644 index 0000000..4ae1dc9 --- /dev/null +++ b/odb/boost/date-time/gregorian-oracle.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/gregorian-oracle.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 + +--odb-epilogue '#include <odb/boost/date-time/oracle/gregorian-mapping.hxx>' +--hxx-prologue '#include <odb/boost/date-time/oracle/gregorian-traits.hxx>' diff --git a/odb/boost/date-time/oracle/gregorian-mapping.hxx b/odb/boost/date-time/oracle/gregorian-mapping.hxx new file mode 100644 index 0000000..aa2ea3b --- /dev/null +++ b/odb/boost/date-time/oracle/gregorian-mapping.hxx @@ -0,0 +1,16 @@ +// file : odb/boost/date-time/oracle/gregorian-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_ORACLE_GREGORIAN_MAPPING_HXX +#define ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_MAPPING_HXX + +#include <boost/date_time/gregorian/gregorian_types.hpp> + +// By default map boost::gregorian::date to Oracle DATE. 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_ORACLE_GREGORIAN_MAPPING_HXX diff --git a/odb/boost/date-time/oracle/gregorian-traits.hxx b/odb/boost/date-time/oracle/gregorian-traits.hxx new file mode 100644 index 0000000..6daf6cf --- /dev/null +++ b/odb/boost/date-time/oracle/gregorian-traits.hxx @@ -0,0 +1,85 @@ +// file : odb/boost/date-time/oracle/gregorian-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_ORACLE_GREGORIAN_TRAITS_HXX +#define ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_TRAITS_HXX + +#include <odb/pre.hxx> + +#include <boost/date_time/gregorian/gregorian_types.hpp> + +#include <odb/core.hxx> + +#include <odb/oracle/traits.hxx> +#include <odb/oracle/details/date.hxx> + +#include <odb/boost/date-time/exceptions.hxx> + +namespace odb +{ + namespace oracle + { + template <> + struct default_value_traits< ::boost::gregorian::date, id_date> + { + typedef ::boost::gregorian::date date; + typedef date value_type; + typedef date query_type; + typedef char* image_type; + + static void + set_value (date& v, const char* b, bool is_null) + { + if (is_null) + v = date (::boost::date_time::not_a_date_time); + else + { + short y (0); + unsigned char m (0), d (0), h (0), min (0), s (0); + + details::get_date (b, y, m, d, h, min, s); + + v = date (static_cast<date::year_type> (y), + static_cast<date::month_type> (m), + static_cast<date::day_type> (d)); + } + } + + static void + set_image (char* b, bool& is_null, const date& 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; + + details::set_date (b, + static_cast<short> (v.year ()), + static_cast<unsigned char> (v.month ()), + static_cast<unsigned char> (v.day ()), + 0, + 0, + 0); + } + } + }; + + 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_ORACLE_GREGORIAN_TRAITS_HXX diff --git a/odb/boost/date-time/oracle/posix-time-mapping.hxx b/odb/boost/date-time/oracle/posix-time-mapping.hxx new file mode 100644 index 0000000..2050ef5 --- /dev/null +++ b/odb/boost/date-time/oracle/posix-time-mapping.hxx @@ -0,0 +1,22 @@ +// file : odb/boost/date-time/oracle/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_ORACLE_POSIX_TIME_MAPPING_HXX +#define ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_MAPPING_HXX + +#include <boost/date_time/posix_time/posix_time_types.hpp> + +// By default map boost::posix_time::ptime to Oracle TIMESTAMP. We use the NULL +// value to represent not_a_date_time. +// +#pragma db value(boost::posix_time::ptime) type("TIMESTAMP") null + +// By default map boost::posix_time::time_duration to Oracle +// INTERVAL DAY TO SECOND. We use the NULL value to represent not_a_date_time. +// +#pragma db value(boost::posix_time::time_duration) \ + type("INTERVAL DAY TO SECOND") null + +#endif // ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_MAPPING_HXX diff --git a/odb/boost/date-time/oracle/posix-time-traits.hxx b/odb/boost/date-time/oracle/posix-time-traits.hxx new file mode 100644 index 0000000..e08945d --- /dev/null +++ b/odb/boost/date-time/oracle/posix-time-traits.hxx @@ -0,0 +1,174 @@ +// file : odb/boost/date-time/oracle/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_ORACLE_POSIX_TIME_TRAITS_HXX +#define ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_TRAITS_HXX + +#include <odb/pre.hxx> + +#include <boost/date_time/posix_time/posix_time_types.hpp> + +#include <odb/core.hxx> + +#include <odb/oracle/traits.hxx> +#include <odb/oracle/oracle-fwd.hxx> // ub1, sb2, ub4 +#include <odb/oracle/oracle-types.hxx> // odb::oracle::datetime, + // odb::oracle::interval_ds + +#include <odb/boost/date-time/exceptions.hxx> + +namespace odb +{ + namespace oracle + { + template <> + struct default_value_traits< ::boost::posix_time::ptime, id_timestamp> + { + 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 + { + sb2 y (0); + ub1 m (0), d (0), h (0), min (0), s (0); + ub4 ns; + + i.get (y, m, d, h, min, s, ns); + + unsigned long long fract_s (ns); + fract_s = fract_s * time_duration::ticks_per_second () / + 1000000000ULL; + + v = ptime ( + date (static_cast<date::year_type> (y), + static_cast<date::month_type> (m), + static_cast<date::day_type> (d)), + time_duration ( + static_cast<time_duration::hour_type> (h), + static_cast<time_duration::min_type> (min), + static_cast<time_duration::sec_type> (s), + static_cast<time_duration::fractional_seconds_type> (fract_s))); + } + } + + static void + set_image (datetime& i, 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 + { + is_null = false; + + const date& d (v.date ()); + const time_duration& t (v.time_of_day ()); + + unsigned long long ns (t.fractional_seconds ()); + ns = ns * 1000000000ULL / time_duration::ticks_per_second (); + + i.set (static_cast<sb2> (d.year ()), + static_cast<ub1> (d.month ()), + static_cast<ub1> (d.day ()), + static_cast<ub1> (t.hours ()), + static_cast<ub1> (t.minutes ()), + static_cast<ub1> (t.seconds ()), + static_cast<ub4> (ns)); + } + } + }; + + template <> + struct default_value_traits< ::boost::posix_time::time_duration, + id_interval_ds> + { + typedef ::boost::posix_time::time_duration time_duration; + + typedef time_duration value_type; + typedef time_duration query_type; + typedef interval_ds image_type; + + static void + set_value (time_duration& v, + const interval_ds& i, + bool is_null) + { + if (is_null) + v = time_duration (::boost::date_time::not_a_date_time); + else + { + sb4 d (0), h (0), m (0), s (0), ns (0); + i.get (d, h, m, s, ns); + + unsigned long long fract_s (ns); + fract_s = fract_s * time_duration::ticks_per_second () / + 1000000000ULL; + + v = time_duration ( + static_cast<time_duration::hour_type> ( + static_cast<unsigned long long> (d) * 24 + h), + static_cast<time_duration::min_type> (m), + static_cast<time_duration::sec_type> (s), + static_cast<time_duration::fractional_seconds_type> (fract_s)); + } + } + + static void + set_image (interval_ds& i, + 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 + { + is_null = false; + + unsigned long long ns (v.fractional_seconds ()); + ns = ns * 1000000000ULL / time_duration::ticks_per_second (); + + i.set (0, + static_cast<sb4> (v.hours ()), + static_cast<sb4> (v.minutes ()), + static_cast<sb4> (v.seconds ()), + static_cast<sb4> (ns)); + } + } + }; + + template <> + struct default_type_traits< ::boost::posix_time::ptime> + { + static const database_type_id db_type_id = id_timestamp; + }; + + template <> + struct default_type_traits< ::boost::posix_time::time_duration> + { + static const database_type_id db_type_id = id_interval_ds; + }; + } +} + +#endif // ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_TRAITS_HXX diff --git a/odb/boost/date-time/posix-time-oracle.options b/odb/boost/date-time/posix-time-oracle.options new file mode 100644 index 0000000..20baf53 --- /dev/null +++ b/odb/boost/date-time/posix-time-oracle.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/posix-time-oracle.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 + +--odb-epilogue '#include <odb/boost/date-time/oracle/posix-time-mapping.hxx>' +--hxx-prologue '#include <odb/boost/date-time/oracle/posix-time-traits.hxx>' |