Mercurial > hg > syntilista

changeset 113:907f2ddf6801

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use #defines for SQL table field lengths.
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 05 Jul 2017 09:52:10 +0300
parents 2524434a7193
children a5c8741b8662
files src/main.cpp src/main.h
diffstat 2 files changed, 15 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/src/main.cpp	Tue Jul 04 12:43:43 2017 +0300
+++ b/src/main.cpp	Wed Jul 05 09:52:10 2017 +0300
@@ -218,11 +218,14 @@
     {
         query.exec(QStringLiteral(
             "CREATE TABLE people (id INTEGER PRIMARY KEY, "
-            "first_name VARCHAR(128) NOT NULL, "
-            "last_name VARCHAR(128) NOT NULL, "
-            "extra_info VARCHAR(2048), "
+            "first_name VARCHAR(%1) NOT NULL, "
+            "last_name VARCHAR(%2) NOT NULL, "
+            "extra_info VARCHAR(%3), "
             "added DATETIME NOT NULL, "
-            "updated DATETIME NOT NULL)"));
+            "updated DATETIME NOT NULL)").
+            arg(SQL_MAX_FIRST_NAME).
+            arg(SQL_MAX_LAST_NAME).
+            arg(SQL_MAX_EXTRA_INFO));
 
         slCheckAndReportSQLError("CREATE TABLE people", query.lastError());
     }
@@ -855,6 +858,9 @@
     ui->tableview_Transactions->verticalHeader()->setVisible(false);
     ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
 
+    ui->edit_FirstName->setMaxLength(SQL_MAX_FIRST_NAME);
+    ui->edit_LastName->setMaxLength(SQL_MAX_LAST_NAME);
+
     validateForm();
 }
 
--- a/src/main.h	Tue Jul 04 12:43:43 2017 +0300
+++ b/src/main.h	Wed Jul 05 09:52:10 2017 +0300
@@ -25,6 +25,11 @@
 #define APP_SQLITE_FILE   "syntilista.sqlite3"      // SQLite3 database file name (without path)
 
 
+#define SQL_MAX_FIRST_NAME 128
+#define SQL_MAX_LAST_NAME  128
+#define SQL_MAX_EXTRA_INFO 2048
+
+
 //
 // Custom SQL models
 //