Mercurial > hg > syntilista

comparison src/main.cpp @ 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
comparison
equal deleted inserted replaced
112:2524434a7193 113:907f2ddf6801
216 QSqlQuery query; 216 QSqlQuery query;
217 if (!db.tables().contains("people")) 217 if (!db.tables().contains("people"))
218 { 218 {
219 query.exec(QStringLiteral( 219 query.exec(QStringLiteral(
220 "CREATE TABLE people (id INTEGER PRIMARY KEY, " 220 "CREATE TABLE people (id INTEGER PRIMARY KEY, "
221 "first_name VARCHAR(128) NOT NULL, " 221 "first_name VARCHAR(%1) NOT NULL, "
222 "last_name VARCHAR(128) NOT NULL, " 222 "last_name VARCHAR(%2) NOT NULL, "
223 "extra_info VARCHAR(2048), " 223 "extra_info VARCHAR(%3), "
224 "added DATETIME NOT NULL, " 224 "added DATETIME NOT NULL, "
225 "updated DATETIME NOT NULL)")); 225 "updated DATETIME NOT NULL)").
226 arg(SQL_MAX_FIRST_NAME).
227 arg(SQL_MAX_LAST_NAME).
228 arg(SQL_MAX_EXTRA_INFO));
226 229
227 slCheckAndReportSQLError("CREATE TABLE people", query.lastError()); 230 slCheckAndReportSQLError("CREATE TABLE people", query.lastError());
228 } 231 }
229 232
230 if (!db.tables().contains("transactions")) 233 if (!db.tables().contains("transactions"))
852 model_Transactions = new TransactionSQLModel(); 855 model_Transactions = new TransactionSQLModel();
853 ui->tableview_Transactions->setModel(model_Transactions); 856 ui->tableview_Transactions->setModel(model_Transactions);
854 ui->tableview_Transactions->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_Transactions)); 857 ui->tableview_Transactions->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_Transactions));
855 ui->tableview_Transactions->verticalHeader()->setVisible(false); 858 ui->tableview_Transactions->verticalHeader()->setVisible(false);
856 ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); 859 ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
860
861 ui->edit_FirstName->setMaxLength(SQL_MAX_FIRST_NAME);
862 ui->edit_LastName->setMaxLength(SQL_MAX_LAST_NAME);
857 863
858 validateForm(); 864 validateForm();
859 } 865 }
860 866
861 867