Draft implementation for INSERT

1 files changed, 107 insertions, 0 deletions

diff --git a/bulk/driver.cxx b/bulk/driver.cxx
new file mode 100644
index 0000000..8632905
--- /dev/null
+++ b/bulk/driver.cxx
@@ -0,0 +1,107 @@
+// file      : hello/driver.cxx
+// copyright : not copyrighted - public domain
+
+#include <memory>   // std::auto_ptr
+#include <iostream>
+
+#include <odb/database.hxx>
+#include <odb/transaction.hxx>
+
+#include "database.hxx" // create_database
+
+#include "person.hxx"
+#include "person-odb.hxx"
+
+using namespace std;
+using namespace odb::core;
+
+int
+main (int argc, char* argv[])
+{
+  try
+  {
+    auto_ptr<database> db (create_database (argc, argv));
+
+    //person p[3];
+    std::vector<person> p (5, person ());
+
+    p[0].id = 1;
+    p[0].num = 1;
+    p[0].str = "aaa";
+
+    p[1].id = 2;
+    p[1].num = 2;
+    p[1].str = "bbb";
+
+    p[2].id = 3;
+    p[2].num = 3;
+    p[2].str = "ccc";
+
+    p[3].id = 4;
+    p[3].num = 4;
+    p[3].str = "ccc";
+
+    p[4].id = 5;
+    p[4].num = 5;
+    p[4].str = "ccc";
+
+    std::vector<person*> pp (5);
+    pp[0] = &p[0];
+    pp[1] = &p[1];
+    pp[2] = &p[2];
+    pp[3] = &p[3];
+    pp[4] = &p[4];
+
+    {
+      transaction t (db->begin ());
+
+      t.tracer (stderr_tracer);
+
+      //db->persist (p, p + 3);
+      //db->persist (p.begin (), p.end ());
+
+      try
+      {
+        db->persist (pp.begin (), pp.end ());
+      }
+      catch (const odb::multiple_exceptions& e)
+      {
+        if (!e.fatal ())
+          cerr << e.what () << endl;
+        else
+          throw;
+      }
+
+      cerr << pp[0]->id << endl
+           << pp[1]->id << endl
+           << pp[2]->id << endl
+           << pp[3]->id << endl
+           << pp[4]->id << endl;
+
+      t.commit ();
+    }
+
+    {
+      transaction t (db->begin ());
+
+      auto_ptr<person> p1 (db->find<person> (1));
+      auto_ptr<person> p2 (db->find<person> (2));
+      auto_ptr<person> p3 (db->find<person> (3));
+      auto_ptr<person> p4 (db->find<person> (4));
+      auto_ptr<person> p5 (db->find<person> (5));
+
+      if (p1.get ()) cerr << p1->id << " " << p1->num << " " << p1->str << endl;
+      if (p2.get ()) cerr << p2->id << " " << p2->num << " " << p2->str << endl;
+      if (p3.get ()) cerr << p3->id << " " << p3->num << " " << p3->str << endl;
+      if (p4.get ()) cerr << p4->id << " " << p4->num << " " << p4->str << endl;
+      if (p5.get ()) cerr << p5->id << " " << p5->num << " " << p5->str << endl;
+
+      t.commit ();
+    }
+  }
+  catch (const odb::exception& e)
+  {
+    cerr << e.what () << endl;
+    return 1;
+  }
+}