Added length field to form table

This commit contains a database update.

2 files changed, 16 insertions, 2 deletions

@@ -10,12 +10,13 @@ namespace verbly {
 
   const object form::objectType = object::form;
 
-  const std::list<std::string> form::select = {"form_id", "form", "complexity", "proper"};
+  const std::list<std::string> form::select = {"form_id", "form", "complexity", "proper", "length"};
 
   const field form::id = field::integerField(object::form, "form_id");
   const field form::text = field::stringField(object::form, "form");
   const field form::complexity = field::integerField(object::form, "complexity");
   const field form::proper = field::booleanField(object::form, "proper");
+  const field form::length = field::integerField(object::form, "length");
 
   const field form::pronunciations = field::joinThrough(object::form, "form_id", object::pronunciation, "forms_pronunciations", "pronunciation_id");
 
@@ -30,6 +31,7 @@ namespace verbly {
     text_ = std::string(reinterpret_cast<const char*>(sqlite3_column_text(row, 1)));
     complexity_ = sqlite3_column_int(row, 2);
     proper_ = (sqlite3_column_int(row, 3) == 1);
+    length_ = sqlite3_column_int(row, 4);
   }
 
   const std::vector<pronunciation>& form::getPronunciations() const
@@ -73,6 +73,16 @@ namespace verbly {
       return proper_;
     }
 
+    int getLength() const
+    {
+      if (!valid_)
+      {
+        throw std::domain_error("Bad access to uninitialized form");
+      }
+
+      return length_;
+    }
+
     const std::vector<pronunciation>& getPronunciations() const;
 
     // Convenience
@@ -91,6 +101,7 @@ namespace verbly {
     static const field text;
     static const field complexity;
     static const field proper;
+    static const field length;
 
     operator filter() const
     {
@@ -123,8 +134,9 @@ namespace verbly {
 
     int id_;
     std::string text_;
-    int complexity_ ;
+    int complexity_;
     bool proper_;
+    int length_;
 
     const database* db_;