// file : sqlite/custom/driver.cxx // copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC // license : GNU GPL v2; see accompanying LICENSE file // Test custom database type mapping in SQLite. // #include <memory> // std::auto_ptr #include <cassert> #include <iostream> #include <odb/sqlite/database.hxx> #include <odb/sqlite/transaction.hxx> #include <common/common.hxx> #include "test.hxx" #include "test-odb.hxx" using namespace std; namespace sqlite = odb::sqlite; using namespace sqlite; int main (int argc, char* argv[]) { try { auto_ptr<database> db (create_specific_database<database> (argc, argv)); object o (1); o.nv.push_back ("123"); // INTEGER o.nv.push_back ("1.23"); // REAL o.nv.push_back ("abc"); // TEXT // Persist. // { transaction t (db->begin ()); db->persist (o); t.commit (); } // Load. // { transaction t (db->begin ()); auto_ptr<object> o1 (db->load<object> (1)); t.commit (); assert (o == *o1); } // Update. // o.nv[1] += "4"; { transaction t (db->begin ()); db->update (o); t.commit (); } { transaction t (db->begin ()); auto_ptr<object> o1 (db->load<object> (1)); t.commit (); assert (o == *o1); } } catch (const odb::exception& e) { cerr << e.what () << endl; return 1; } }