// file : common/schema/embedded/order/driver.cxx // copyright : Copyright (c) 2009-2013 Code Synthesis Tools CC // license : GNU GPL v2; see accompanying LICENSE file // Test statement execution order in embedded schemas. // #include <memory> // std::auto_ptr #include <cassert> #include <iostream> #include <odb/database.hxx> #include <odb/transaction.hxx> #include <odb/schema-catalog.hxx> #include <common/common.hxx> #include "test1.hxx" #include "test2.hxx" #include "test1-odb.hxx" #include "test2-odb.hxx" using namespace std; using namespace odb::core; int main (int argc, char* argv[]) { try { auto_ptr<database> db (create_database (argc, argv, false)); odb::database_id db_id (db->id ()); // Create the database schema. // { connection_ptr c (db->connection ()); // Temporarily disable foreign key constraints for MySQL and SQLite. // For MySQL we can actually create the tables in any order. It is // dropping them that's the problem (there is no IF EXISTS). // if (db_id == odb::id_mysql) c->execute ("SET FOREIGN_KEY_CHECKS=0"); else if (db_id == odb::id_sqlite) c->execute ("PRAGMA foreign_keys=OFF"); transaction t (c->begin ()); schema_catalog::create_schema (*db); t.commit (); if (db_id == odb::id_mysql) c->execute ("SET FOREIGN_KEY_CHECKS=1"); else if (db_id == odb::id_sqlite) c->execute ("PRAGMA foreign_keys=ON"); } } catch (const odb::exception& e) { cerr << e.what () << endl; return 1; } }