Implement support for mixed auto/manual id assignment in SQLite

Now one can do:

#pragma db id auto
odb::nullable<int64_t> id;

And then set the id to NULL to get auto-assignment or to the actual value
to use a manual id.

1 files changed, 33 insertions, 0 deletions

diff --git a/sqlite/auto/test.hxx b/sqlite/auto/test.hxx
new file mode 100644
index 0000000..1ee8dbe
--- /dev/null
+++ b/sqlite/auto/test.hxx
@@ -0,0 +1,33 @@
+// file      : sqlite/auto/test.hxx
+// copyright : Copyright (c) 2009-2015 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef TEST_HXX
+#define TEST_HXX
+
+#include <odb/core.hxx>
+#include <odb/nullable.hxx>
+
+#include <string>
+
+#include <odb/core.hxx>
+
+#pragma db object
+struct object
+{
+  explicit
+  object (const std::string& str): str_ (str) {}
+  object (unsigned long id, const std::string& str): id_ (id), str_ (str) {}
+
+  #pragma db auto id
+  odb::nullable<unsigned long> id_;
+
+  std::string str_;
+
+private:
+  object () {}
+
+  friend class odb::access;
+};
+
+#endif // TEST_HXX