From a7e2b5e983ce12317bbc26d041a9a2a082840726 Mon Sep 17 00:00:00 2001 From: Constantin Michael Date: Mon, 7 Nov 2011 15:21:17 +0200 Subject: Implement Boost profile for Oracle --- odb/boost/date-time/gregorian-oracle.options | 9 ++ odb/boost/date-time/oracle/gregorian-mapping.hxx | 16 ++ odb/boost/date-time/oracle/gregorian-traits.hxx | 85 +++++++++++ odb/boost/date-time/oracle/posix-time-mapping.hxx | 22 +++ odb/boost/date-time/oracle/posix-time-traits.hxx | 174 ++++++++++++++++++++++ odb/boost/date-time/posix-time-oracle.options | 9 ++ 6 files changed, 315 insertions(+) create mode 100644 odb/boost/date-time/gregorian-oracle.options create mode 100644 odb/boost/date-time/oracle/gregorian-mapping.hxx create mode 100644 odb/boost/date-time/oracle/gregorian-traits.hxx create mode 100644 odb/boost/date-time/oracle/posix-time-mapping.hxx create mode 100644 odb/boost/date-time/oracle/posix-time-traits.hxx create mode 100644 odb/boost/date-time/posix-time-oracle.options (limited to 'odb') 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 +# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +# license : GNU GPL v2; see accompanying LICENSE file + +--profile boost/version + +--odb-epilogue '#include ' +--hxx-prologue '#include ' 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 +// 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 + +// 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 +// 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 + +#include + +#include + +#include +#include + +#include + +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 (y), + static_cast (m), + static_cast (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 (v.year ()), + static_cast (v.month ()), + static_cast (v.day ()), + 0, + 0, + 0); + } + } + }; + + template <> + struct default_type_traits< ::boost::gregorian::date> + { + static const database_type_id db_type_id = id_date; + }; + } +} + +#include + +#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 +// 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 + +// 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 +// 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 + +#include + +#include + +#include +#include // ub1, sb2, ub4 +#include // odb::oracle::datetime, + // odb::oracle::interval_ds + +#include + +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 (y), + static_cast (m), + static_cast (d)), + time_duration ( + static_cast (h), + static_cast (min), + static_cast (s), + static_cast (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 (d.year ()), + static_cast (d.month ()), + static_cast (d.day ()), + static_cast (t.hours ()), + static_cast (t.minutes ()), + static_cast (t.seconds ()), + static_cast (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 ( + static_cast (d) * 24 + h), + static_cast (m), + static_cast (s), + static_cast (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 (v.hours ()), + static_cast (v.minutes ()), + static_cast (v.seconds ()), + static_cast (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 +# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +# license : GNU GPL v2; see accompanying LICENSE file + +--profile boost/version + +--odb-epilogue '#include ' +--hxx-prologue '#include ' -- cgit v1.1