diff options
author | Karen Arutyunov <karen@codesynthesis.com> | 2024-01-25 20:32:06 +0300 |
---|---|---|
committer | Karen Arutyunov <karen@codesynthesis.com> | 2024-01-25 20:32:06 +0300 |
commit | 0d49ea1fe08cf1eab41a00149393a291c65a59d7 (patch) | |
tree | 0391eb09309ca95282e200516937e64d89f3e1bb /odb-tests/qt/pgsql/date-time/driver.cxx | |
parent | fc3fb39c90ab7fe5fccbe3f3bc0eb2645157bb96 (diff) |
Turn odb-tests repository into package for muti-package repositoryodb-tests
Diffstat (limited to 'odb-tests/qt/pgsql/date-time/driver.cxx')
-rw-r--r-- | odb-tests/qt/pgsql/date-time/driver.cxx | 108 |
1 files changed, 108 insertions, 0 deletions
diff --git a/odb-tests/qt/pgsql/date-time/driver.cxx b/odb-tests/qt/pgsql/date-time/driver.cxx new file mode 100644 index 0000000..43a676d --- /dev/null +++ b/odb-tests/qt/pgsql/date-time/driver.cxx @@ -0,0 +1,108 @@ +// file : qt/pgsql/date-time/driver.cxx +// license : GNU GPL v2; see accompanying LICENSE file + +// Test Qt date/time type persistence. PostgreSQL version. +// + +#include <memory> // std::auto_ptr +#include <cassert> +#include <iostream> + +#include <QtCore/QDateTime> +#include <QtCore/QCoreApplication> + +#include <odb/pgsql/database.hxx> +#include <odb/pgsql/transaction.hxx> + +#include <common/common.hxx> + +#include "test.hxx" +#include "test-odb.hxx" + +using namespace std; +using namespace odb::core; + +bool +test_out_of_range_value (object&, database&); + +int +main (int argc, char* argv[]) +{ + QCoreApplication app (argc, argv); + + try + { + auto_ptr<database> db (create_database (argc, argv)); + + // Check persistence of null values. + // + { + object o; + + { + transaction t (db->begin ()); + db->persist (o); + t.commit (); + } + + { + transaction t (db->begin ()); + auto_ptr<object> ol (db->load<object> (o.id)); + t.commit (); + + assert (ol->is_null ()); + } + } + + // Check persistence of valid dates and times. + // + { + QDateTime ct (QDateTime::currentDateTime ()); + + object o; + o.date = ct.date (); + o.time = ct.time (); + o.date_time = ct; + + { + transaction t (db->begin ()); + db->persist (o); + t.commit (); + } + + { + transaction t (db->begin ()); + auto_ptr<object> ol (db->load<object> (o.id)); + t.commit (); + + assert (*ol == o); + } + } + + // Test a QDateTime value before PG epoch. + // + { + object o; + o.date_time = QDateTime (QDate (1969, 12, 31), QTime (23, 59, 59, 123)); + + { + transaction t (db->begin ()); + db->persist (o); + t.commit (); + } + + { + transaction t (db->begin ()); + auto_ptr<object> ol (db->load<object> (o.id)); + t.commit (); + + assert (*ol == o); + } + } + } + catch (const odb::exception& e) + { + cerr << e.what () << endl; + return 1; + } +} |