EditTableDialog: Add '=' in fron of functions in default value

When editing an existing table with a function used inside a default value of a field add a '=' character before the default expression string to match our own input format for these kind of default values. See issue sqlitebrowser#166.
jasonbu · May 18, 2015 · 5578056 · 5578056
1 parent a342194
commit 5578056
Showing 1 changed file with 9 additions and 1 deletion.
diff --git a/src/EditTableDialog.cpp b/src/EditTableDialog.cpp
@@ -105,7 +105,15 @@ void EditTableDialog::populateFields()
         tbitem->setCheckState(kPrimaryKey, f->primaryKey() ? Qt::Checked : Qt::Unchecked);
         tbitem->setCheckState(kAutoIncrement, f->autoIncrement() ? Qt::Checked : Qt::Unchecked);
         tbitem->setCheckState(kUnique, f->unique() ? Qt::Checked : Qt::Unchecked);
-        tbitem->setText(kDefault, f->defaultValue());
+
+        // For the default value check if it is surrounded by parantheses and if that's the case
+        // add a '=' character before the entire string to match the input format we're expecting
+        // from the user when using functions in the default value field.
+        if(f->defaultValue().startsWith('(') && f->defaultValue().endsWith(')'))
+            tbitem->setText(kDefault, "=" + f->defaultValue());
+        else
+            tbitem->setText(kDefault, f->defaultValue());
+
         tbitem->setText(kCheck, f->check());
         tbitem->setText(kForeignKey, f->foreignKey());
         ui->treeWidget->addTopLevelItem(tbitem);