From 597939bc9e36808d4a65b449f085927f26383c15 Mon Sep 17 00:00:00 2001 From: Constantin Michael Date: Fri, 1 Apr 2011 18:08:51 +0200 Subject: Add SQLite support for Boost profile --- odb/boost/date-time/gregorian-mysql.options | 9 + odb/boost/date-time/gregorian-sqlite.options | 9 + odb/boost/date-time/gregorian.options | 9 - odb/boost/date-time/posix-time-mysql.options | 9 + odb/boost/date-time/posix-time-sqlite.options | 9 + odb/boost/date-time/posix-time.options | 9 - odb/boost/date-time/sqlite/gregorian-mapping.hxx | 16 ++ odb/boost/date-time/sqlite/gregorian-traits.hxx | 133 ++++++++++++ odb/boost/date-time/sqlite/posix-time-mapping.hxx | 21 ++ odb/boost/date-time/sqlite/posix-time-traits.hxx | 234 ++++++++++++++++++++++ 10 files changed, 440 insertions(+), 18 deletions(-) create mode 100644 odb/boost/date-time/gregorian-mysql.options create mode 100644 odb/boost/date-time/gregorian-sqlite.options delete mode 100644 odb/boost/date-time/gregorian.options create mode 100644 odb/boost/date-time/posix-time-mysql.options create mode 100644 odb/boost/date-time/posix-time-sqlite.options delete mode 100644 odb/boost/date-time/posix-time.options create mode 100644 odb/boost/date-time/sqlite/gregorian-mapping.hxx create mode 100644 odb/boost/date-time/sqlite/gregorian-traits.hxx create mode 100644 odb/boost/date-time/sqlite/posix-time-mapping.hxx create mode 100644 odb/boost/date-time/sqlite/posix-time-traits.hxx diff --git a/odb/boost/date-time/gregorian-mysql.options b/odb/boost/date-time/gregorian-mysql.options new file mode 100644 index 0000000..953f21a --- /dev/null +++ b/odb/boost/date-time/gregorian-mysql.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/gregorian-mysql.options +# author : Boris Kolpackov +# 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/gregorian-sqlite.options b/odb/boost/date-time/gregorian-sqlite.options new file mode 100644 index 0000000..8cd370d --- /dev/null +++ b/odb/boost/date-time/gregorian-sqlite.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/gregorian-sqlite.options +# author : Boris Kolpackov +# 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/gregorian.options b/odb/boost/date-time/gregorian.options deleted file mode 100644 index f320005..0000000 --- a/odb/boost/date-time/gregorian.options +++ /dev/null @@ -1,9 +0,0 @@ -# file : odb/boost/date-time/gregorian.options -# author : Boris Kolpackov -# 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/posix-time-mysql.options b/odb/boost/date-time/posix-time-mysql.options new file mode 100644 index 0000000..e87e11e --- /dev/null +++ b/odb/boost/date-time/posix-time-mysql.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/posix-time-mysql.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/posix-time-sqlite.options b/odb/boost/date-time/posix-time-sqlite.options new file mode 100644 index 0000000..918f6fc --- /dev/null +++ b/odb/boost/date-time/posix-time-sqlite.options @@ -0,0 +1,9 @@ +# file : odb/boost/date-time/posix-time-sqlite.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/posix-time.options b/odb/boost/date-time/posix-time.options deleted file mode 100644 index 2576ac5..0000000 --- a/odb/boost/date-time/posix-time.options +++ /dev/null @@ -1,9 +0,0 @@ -# file : odb/boost/date-time/posix-time.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/sqlite/gregorian-mapping.hxx b/odb/boost/date-time/sqlite/gregorian-mapping.hxx new file mode 100644 index 0000000..0a58a6c --- /dev/null +++ b/odb/boost/date-time/sqlite/gregorian-mapping.hxx @@ -0,0 +1,16 @@ +// file : odb/boost/date-time/sqlite/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_SQLITE_GREGORIAN_MAPPING_HXX +#define ODB_BOOST_DATE_TIME_SQLITE_GREGORIAN_MAPPING_HXX + +#include + +// By default map boost::gregorian::date to TEXT. We use the +// NULL value to represent not_a_date_time. +// +#pragma db value(boost::gregorian::date) type("TEXT") + +#endif // ODB_BOOST_DATE_TIME_SQLITE_GREGORIAN_MAPPING_HXX diff --git a/odb/boost/date-time/sqlite/gregorian-traits.hxx b/odb/boost/date-time/sqlite/gregorian-traits.hxx new file mode 100644 index 0000000..b9ffd4c --- /dev/null +++ b/odb/boost/date-time/sqlite/gregorian-traits.hxx @@ -0,0 +1,133 @@ +// file : odb/boost/date-time/sqlite/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_SQLITE_GREGORIAN_TRAITS_HXX +#define ODB_BOOST_DATE_TIME_SQLITE_GREGORIAN_TRAITS_HXX + +#include + +#include +#include // std::size_t +#include // std::memcpy +#include // std::time_t + +#include // date +#include // time_duration +#include // from_simple_string +#include // to_iso_extended_string +#include // from_time_t + +#include +#include +#include + +#include + +namespace odb +{ + namespace sqlite + { + template <> + class default_value_traits< + ::boost::gregorian::date, details::buffer, id_text> + { + public: + typedef ::boost::gregorian::date date; + typedef date value_type; + typedef date query_type; + typedef details::buffer image_type; + + static void + set_value (date& v, + const details::buffer& i, + std::size_t n, + bool is_null) + { + if (is_null) + v = date (::boost::date_time::not_a_date_time); + else + v = ::boost::gregorian::from_simple_string ( + std::string (i.data (), n)); + } + + static void + set_image (details::buffer& i, + std::size_t& n, + 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; + + const std::string& s ( + ::boost::gregorian::to_iso_extended_string (v)); + + n = s.size (); + + if (n > i.capacity ()) + i.capacity (n); + + std::memcpy (i.data (), s.data (), n); + } + } + }; + + template <> + class default_value_traits< + ::boost::gregorian::date, long long, id_integer> + { + public: + typedef ::boost::gregorian::date date; + typedef ::boost::posix_time::time_duration time_duration; + typedef ::boost::posix_time::ptime ptime; + typedef date value_type; + typedef date query_type; + typedef long long image_type; + + static void + set_value (date& v, long long i, bool is_null) + { + if (is_null) + v = date (::boost::date_time::not_a_date_time); + else + v = ::boost::posix_time::from_time_t ( + static_cast (i)).date (); + } + + static void + set_image (long long& i, 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; + + ptime epoch (date (1970, 1, 1), time_duration (0, 0, 0)); + i = static_cast ( + (ptime (v, time_duration (0, 0, 0)) - epoch).ticks () / + time_duration::ticks_per_second ()); + } + } + }; + } +} + +#include + +#endif // ODB_BOOST_DATE_TIME_SQLITE_GREGORIAN_TRAITS_HXX diff --git a/odb/boost/date-time/sqlite/posix-time-mapping.hxx b/odb/boost/date-time/sqlite/posix-time-mapping.hxx new file mode 100644 index 0000000..69a83df --- /dev/null +++ b/odb/boost/date-time/sqlite/posix-time-mapping.hxx @@ -0,0 +1,21 @@ +// file : odb/boost/date-time/sqlite/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_SQLITE_POSIX_TIME_MAPPING_HXX +#define ODB_BOOST_DATE_TIME_SQLITE_POSIX_TIME_MAPPING_HXX + +#include + +// By default map boost::posix_time::ptime to TEXT. We use +// the NULL value to represent not_a_date_time. +// +#pragma db value(boost::posix_time::ptime) type("TEXT") + +// By default map boost::posix_time::time_duration to TEXT. We +// use the NULL value to represent not_a_date_time. +// +#pragma db value(boost::posix_time::time_duration) type("TEXT") + +#endif // ODB_BOOST_DATE_TIME_SQLITE_POSIX_TIME_MAPPING_HXX diff --git a/odb/boost/date-time/sqlite/posix-time-traits.hxx b/odb/boost/date-time/sqlite/posix-time-traits.hxx new file mode 100644 index 0000000..039682b --- /dev/null +++ b/odb/boost/date-time/sqlite/posix-time-traits.hxx @@ -0,0 +1,234 @@ +// file : odb/boost/date-time/sqlite/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_SQLITE_POSIX_TIME_TRAITS_HXX +#define ODB_BOOST_DATE_TIME_SQLITE_POSIX_TIME_TRAITS_HXX + +#include + +#include +#include // std::size_t +#include // std::memcpy +#include // std::time_t + +#include +#include // time_from_string +#include // to_simple_string +#include // from_time_t + +#include +#include +#include + +#include + +namespace odb +{ + namespace sqlite + { + template <> + class default_value_traits< + ::boost::posix_time::ptime, details::buffer, id_text> + { + public: + typedef ::boost::posix_time::ptime ptime; + typedef ptime value_type; + typedef ptime query_type; + typedef details::buffer image_type; + + static void + set_value (ptime& v, + const details::buffer& i, + std::size_t n, + bool is_null) + { + if (is_null) + v = ptime (::boost::date_time::not_a_date_time); + else + v = ::boost::posix_time::time_from_string ( + std::string (i.data (), n)); + } + + static void + set_image (details::buffer& i, + std::size_t& n, + 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; + + std::string s (::boost::posix_time::to_iso_extended_string (v)); + + // Replace ',' in iso string with '.'. SQLite requires the + // latter for date/time functions. + // + std::size_t p = s.rfind (','); + if (p != std::string::npos) + s[p] = '.'; + + // Remove 'T' separator as Boost is unable to parse correctly. + // + p = s.find ('T'); + if (p != std::string::npos) + s[p] = ' '; + + n = s.size (); + if (n > i.capacity ()) + i.capacity (n); + + std::memcpy (i.data (), s.data (), n); + } + } + }; + + // Implementation of the mapping between boost::posix_time::ptime and + // SQLite INTEGER. The integer value represents UNIX time. + // + template <> + class default_value_traits< + ::boost::posix_time::ptime, long long, id_integer> + { + public: + typedef ::boost::gregorian::date date; + typedef ::boost::posix_time::ptime ptime; + typedef ::boost::posix_time::time_duration time_duration; + typedef ptime value_type; + typedef ptime query_type; + typedef long long image_type; + + static void + set_value (ptime& v, long long i, bool is_null) + { + if (is_null) + v = ptime (::boost::date_time::not_a_date_time); + else + v = ::boost::posix_time::from_time_t (static_cast (i)); + } + + static void + set_image (long long& 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; + + ptime epoch (date (1970, 1, 1), time_duration (0, 0, 0)); + i = static_cast ( + (v - epoch).ticks () / time_duration::ticks_per_second ()); + } + } + }; + + template <> + class default_value_traits< + ::boost::posix_time::time_duration, details::buffer, id_text> + { + public: + typedef ::boost::posix_time::time_duration time_duration; + typedef time_duration value_type; + typedef time_duration query_type; + typedef details::buffer image_type; + + static void + set_value (time_duration& v, + const details::buffer& i, + std::size_t n, + bool is_null) + { + if (is_null) + v = time_duration (::boost::date_time::not_a_date_time); + else + { + v = ::boost::posix_time::duration_from_string ( + std::string (i.data (), n)); + } + } + + static void + set_image (details::buffer& i, + std::size_t& n, + 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.total_seconds () < 0) + throw odb::boost::date_time::value_out_of_range (); + else + { + is_null = false; + + const std::string& s (::boost::posix_time::to_simple_string (v)); + + n = s.size (); + if (n > i.capacity ()) + i.capacity (n); + + std::memcpy (i.data (), s.data (), n); + } + } + }; + + template <> + class default_value_traits< + ::boost::posix_time::time_duration, long long, id_integer> + { + public: + typedef ::boost::posix_time::time_duration time_duration; + typedef time_duration value_type; + typedef time_duration query_type; + typedef details::buffer image_type; + + static void + set_value (time_duration& v, long long i, bool is_null) + { + if (is_null) + v = time_duration (::boost::date_time::not_a_date_time); + else + v = time_duration (0, 0, static_cast (i)); + } + + static void + set_image (long long& 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; + i = static_cast (v.total_seconds ()); + } + } + }; + } +} + +#endif // ODB_BOOST_DATE_TIME_SQLITE_POSIX_TIME_TRAITS_HXX -- cgit v1.1