Created database versioning system d1.0

Also added an ANALYZE statement to the end of the datafile generation
process. This generates information that allows sqlite to sometimes come
up with a better query plan, and in many cases can significant speed up
queries. This constitutes a minor database update, but because this is
the first version that uses the database versioning system, older
versions are essentially incompatible.

refs #2

1 files changed, 44 insertions, 0 deletions

@@ -3,6 +3,7 @@
 
 #include <string>
 #include <exception>
+#include <stdexcept>
 #include <list>
 #include <set>
 #include "notion.h"
@@ -45,6 +46,18 @@ namespace verbly {
 
     ~database();
 
+    // Information
+
+    int getMajorVersion() const
+    {
+      return major_;
+    }
+
+    int getMinorVersion() const
+    {
+      return minor_;
+    }
+
     // Queries
 
     query<notion> notions(filter where, order sortOrder = {}, int limit = 1) const;
@@ -69,6 +82,37 @@ namespace verbly {
 
     sqlite3* ppdb_ = nullptr;
 
+    int major_;
+    int minor_;
+
+  };
+
+  class database_version_mismatch : public std::logic_error {
+  public:
+
+    database_version_mismatch(int right, int wrong) :
+      std::logic_error(generateMessage(right, wrong)),
+      right_(right),
+      wrong_(wrong)
+    {
+    }
+
+    int getRightVersion() const noexcept
+    {
+      return right_;
+    }
+
+    int getWrongVersion() const noexcept
+    {
+      return wrong_;
+    }
+
+  private:
+
+    static std::string generateMessage(int right, int wrong);
+
+    int right_;
+    int wrong_;
   };
 
 };