Added length field to form table

This commit contains a database update.

3 files changed, 11 insertions, 2 deletions

@@ -14,7 +14,8 @@ namespace verbly {
       id_(nextId_++),
       text_(text),
       complexity_(std::count(std::begin(text), std::end(text), ' ') + 1),
-      proper_(std::any_of(std::begin(text), std::end(text), std::isupper))
+      proper_(std::any_of(std::begin(text), std::end(text), std::isupper)),
+      length_(text.length())
     {
     }
 
@@ -32,6 +33,7 @@ namespace verbly {
         fields.emplace_back("form", arg.getText());
         fields.emplace_back("complexity", arg.getComplexity());
         fields.emplace_back("proper", arg.isProper());
+        fields.emplace_back("length", arg.getLength());
 
         db.insertIntoTable("forms", std::move(fields));
       }
@@ -43,6 +43,11 @@ namespace verbly {
         return proper_;
       }
 
+      int getLength() const
+      {
+        return length_;
+      }
+
       std::set<const pronunciation*> getPronunciations() const
       {
         return pronunciations_;
@@ -56,6 +61,7 @@ namespace verbly {
       const std::string text_;
       const int complexity_;
       const bool proper_;
+      const int length_;
 
       std::set<const pronunciation*> pronunciations_;
 
@@ -155,7 +155,8 @@ CREATE TABLE `forms` (
   `form_id` INTEGER PRIMARY KEY,
   `form` VARCHAR(32) NOT NULL,
   `complexity` SMALLINT NOT NULL,
-  `proper` SMALLINT NOT NULL
+  `proper` SMALLINT NOT NULL,
+  `length` SMALLINT NOT NULL
 );
 
 CREATE UNIQUE INDEX `form_by_string` ON `forms`(`form`);