// file : mapping/traits-sqlite.hxx // author : Boris Kolpackov <boris@codesynthesis.com> // copyright : not copyrighted - public domain #ifndef TRAITS_SQLITE_HXX #define TRAITS_SQLITE_HXX // // SQLite implementation. // #include <cstring> #include <sstream> #include <odb/sqlite/traits.hxx> #include "person.hxx" // date namespace odb { namespace sqlite { template <> class value_traits<bool, id_text> { public: typedef bool value_type; typedef bool query_type; typedef details::buffer image_type; static void set_value (bool& v, const details::buffer& b, std::size_t n, bool is_null) { v = (!is_null && n == 4 && std::strncmp ("true", b.data (), n) == 0); } static void set_image (details::buffer& b, std::size_t& n, bool& is_null, bool v) { is_null = false; n = v ? 4 : 5; if (n > b.capacity ()) b.capacity (n); std::memcpy (b.data (), (v ? "true" : "false"), n); } }; // In SQLite there is no built-in DATE type. Rather, this type is // mapped to TEXT in the YYYY-MM-DD format. The below implementation // doesn't do any error checking for brevity. // template <> class value_traits<date, id_text> { public: typedef date value_type; typedef date query_type; typedef details::buffer image_type; static void set_value (date& v, const details::buffer& b, std::size_t n, bool is_null) { using namespace std; if (!is_null) { istringstream is (string (b.data (), n)); unsigned int y, m, d; is >> y; is.ignore (1); is >> m; is.ignore (1); is >> d; v = date (y, m, d); } else v = date (0, 0, 0); } static void set_image (details::buffer& b, std::size_t& n, bool& is_null, const date& v) { using namespace std; ostringstream os; os.fill ('0'); os.width (4); os << v.year () << '-'; os.width (2); os << v.month () << '-'; os.width (2); os << v.day (); const string& s (os.str ()); is_null = false; n = s.size (); if (n > b.capacity ()) b.capacity (n); memcpy (b.data (), s.c_str (), n); } }; } } #endif // TRAITS_SQLITE_HXX