From 2f17222fd6b2f3cfa251e57daf67ee58d25d6e43 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Thu, 23 Sep 2010 09:32:31 +0200 Subject: Add the mapping example It shows how to map between C++ value types and SQL types --- mapping/driver.cxx | 62 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 mapping/driver.cxx (limited to 'mapping/driver.cxx') diff --git a/mapping/driver.cxx b/mapping/driver.cxx new file mode 100644 index 0000000..fd878dc --- /dev/null +++ b/mapping/driver.cxx @@ -0,0 +1,62 @@ +// file : mapping/driver.cxx +// author : Boris Kolpackov +// copyright : not copyrighted - public domain + +#include // std::auto_ptr +#include + +#include +#include + +#include "database.hxx" // create_database + +#include "person.hxx" +#include "person-odb.hxx" + +using namespace std; +using namespace odb; + +int +main (int argc, char* argv[]) +{ + try + { + auto_ptr db (create_database (argc, argv)); + + { + person john ("John", "Doe", date (1978, 10, 13), true); + person jane ("Jane", "Doe", date (1975, 11, 23), false); + person joe ("Joe", "Dirt", date (1973, 12, 28), true); + + transaction t (db->begin_transaction ()); + + db->persist (john); + db->persist (jane); + db->persist (joe); + + t.commit (); + } + + { + typedef odb::query query; + typedef odb::result result; + + transaction t (db->begin_transaction ()); + + result r (db->query (query::married && + query::born == date (1978, 10, 13))); + + for (result::iterator i (r.begin ()); i != r.end (); ++i) + { + cout << i->first () << " " << i->last () << endl; + } + + t.commit (); + } + } + catch (const odb::exception& e) + { + cerr << e.what () << endl; + return 1; + } +} -- cgit v1.1