models/qsqltablemodel.cpp

Source codeSwitch to Preprocessed file
LineSource CodeCoverage
1/**************************************************************************** -
2** -
3** Copyright (C) 2013 Digia Plc and/or its subsidiary(-ies). -
4** Contact: http://www.qt-project.org/legal -
5** -
6** This file is part of the QtSql module of the Qt Toolkit. -
7** -
8** $QT_BEGIN_LICENSE:LGPL$ -
9** Commercial License Usage -
10** Licensees holding valid commercial Qt licenses may use this file in -
11** accordance with the commercial license agreement provided with the -
12** Software or, alternatively, in accordance with the terms contained in -
13** a written agreement between you and Digia. For licensing terms and -
14** conditions see http://qt.digia.com/licensing. For further information -
15** use the contact form at http://qt.digia.com/contact-us. -
16** -
17** GNU Lesser General Public License Usage -
18** Alternatively, this file may be used under the terms of the GNU Lesser -
19** General Public License version 2.1 as published by the Free Software -
20** Foundation and appearing in the file LICENSE.LGPL included in the -
21** packaging of this file. Please review the following information to -
22** ensure the GNU Lesser General Public License version 2.1 requirements -
23** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. -
24** -
25** In addition, as a special exception, Digia gives you certain additional -
26** rights. These rights are described in the Digia Qt LGPL Exception -
27** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. -
28** -
29** GNU General Public License Usage -
30** Alternatively, this file may be used under the terms of the GNU -
31** General Public License version 3.0 as published by the Free Software -
32** Foundation and appearing in the file LICENSE.GPL included in the -
33** packaging of this file. Please review the following information to -
34** ensure the GNU General Public License version 3.0 requirements will be -
35** met: http://www.gnu.org/copyleft/gpl.html. -
36** -
37** -
38** $QT_END_LICENSE$ -
39** -
40****************************************************************************/ -
41 -
42#include "qsqltablemodel.h" -
43 -
44#include "qsqldriver.h" -
45#include "qsqlerror.h" -
46#include "qsqlfield.h" -
47#include "qsqlindex.h" -
48#include "qsqlquery.h" -
49#include "qsqlrecord.h" -
50#include "qsqlresult.h" -
51 -
52#include "qsqltablemodel_p.h" -
53 -
54#include <qdebug.h> -
55 -
56QT_BEGIN_NAMESPACE -
57 -
58typedef QSqlTableModelSql Sql; -
59 -
60/*! \internal -
61 Populates our record with values. -
62*/ -
63QSqlRecord QSqlTableModelPrivate::record(const QVector<QVariant> &values) const -
64{ -
65 QSqlRecord r = rec;
never executed (the execution status of this line is deduced): QSqlRecord r = rec;
-
66 for (int i = 0; i < r.count() && i < values.count(); ++i)
never evaluated: i < r.count()
never evaluated: i < values.count()
0
67 r.setValue(i, values.at(i));
never executed: r.setValue(i, values.at(i));
0
68 return r;
never executed: return r;
0
69} -
70 -
71int QSqlTableModelPrivate::nameToIndex(const QString &name) const -
72{ -
73 return rec.indexOf(strippedFieldName(name));
executed: return rec.indexOf(strippedFieldName(name));
Execution Count:116
116
74} -
75 -
76QString QSqlTableModelPrivate::strippedFieldName(const QString &name) const -
77{ -
78 QString fieldname = name;
executed (the execution status of this line is deduced): QString fieldname = name;
-
79 if (db.driver()->isIdentifierEscaped(fieldname, QSqlDriver::FieldName))
evaluated: db.driver()->isIdentifierEscaped(fieldname, QSqlDriver::FieldName)
TRUEFALSE
yes
Evaluation Count:4
yes
Evaluation Count:129
4-129
80 fieldname = db.driver()->stripDelimiters(fieldname, QSqlDriver::FieldName);
executed: fieldname = db.driver()->stripDelimiters(fieldname, QSqlDriver::FieldName);
Execution Count:4
4
81 return fieldname;
executed: return fieldname;
Execution Count:133
133
82} -
83 -
84int QSqlTableModelPrivate::insertCount(int maxRow) const -
85{ -
86 int cnt = 0;
executed (the execution status of this line is deduced): int cnt = 0;
-
87 CacheMap::ConstIterator i = cache.constBegin();
executed (the execution status of this line is deduced): CacheMap::ConstIterator i = cache.constBegin();
-
88 const CacheMap::ConstIterator e = cache.constEnd();
executed (the execution status of this line is deduced): const CacheMap::ConstIterator e = cache.constEnd();
-
89 for ( ; i != e && (maxRow < 0 || i.key() <= maxRow); ++i)
evaluated: i != e
TRUEFALSE
yes
Evaluation Count:2172
yes
Evaluation Count:12804
evaluated: maxRow < 0
TRUEFALSE
yes
Evaluation Count:1714
yes
Evaluation Count:458
evaluated: i.key() <= maxRow
TRUEFALSE
yes
Evaluation Count:380
yes
Evaluation Count:78
78-12804
90 if (i.value().insert())
evaluated: i.value().insert()
TRUEFALSE
yes
Evaluation Count:1278
yes
Evaluation Count:816
816-1278
91 ++cnt;
executed: ++cnt;
Execution Count:1278
1278
92 -
93 return cnt;
executed: return cnt;
Execution Count:12882
12882
94} -
95 -
96void QSqlTableModelPrivate::initRecordAndPrimaryIndex() -
97{ -
98 rec = db.record(tableName);
executed (the execution status of this line is deduced): rec = db.record(tableName);
-
99 primaryIndex = db.primaryIndex(tableName);
executed (the execution status of this line is deduced): primaryIndex = db.primaryIndex(tableName);
-
100 initColOffsets(rec.count());
executed (the execution status of this line is deduced): initColOffsets(rec.count());
-
101}
executed: }
Execution Count:185
185
102 -
103void QSqlTableModelPrivate::clear() -
104{ -
105 sortColumn = -1;
executed (the execution status of this line is deduced): sortColumn = -1;
-
106 sortOrder = Qt::AscendingOrder;
executed (the execution status of this line is deduced): sortOrder = Qt::AscendingOrder;
-
107 tableName.clear();
executed (the execution status of this line is deduced): tableName.clear();
-
108 editQuery.clear();
executed (the execution status of this line is deduced): editQuery.clear();
-
109 cache.clear();
executed (the execution status of this line is deduced): cache.clear();
-
110 primaryIndex.clear();
executed (the execution status of this line is deduced): primaryIndex.clear();
-
111 rec.clear();
executed (the execution status of this line is deduced): rec.clear();
-
112 filter.clear();
executed (the execution status of this line is deduced): filter.clear();
-
113}
executed: }
Execution Count:190
190
114 -
115void QSqlTableModelPrivate::clearCache() -
116{ -
117 cache.clear();
executed (the execution status of this line is deduced): cache.clear();
-
118}
executed: }
Execution Count:315
315
119 -
120void QSqlTableModelPrivate::revertCachedRow(int row) -
121{ -
122 Q_Q(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModel * const q = q_func();
-
123 ModifiedRow r = cache.value(row);
executed (the execution status of this line is deduced): ModifiedRow r = cache.value(row);
-
124 -
125 switch (r.op()) { -
126 case QSqlTableModelPrivate::None: -
127 Q_ASSERT_X(false, "QSqlTableModelPrivate::revertCachedRow()", "Invalid entry in cache map");
never executed (the execution status of this line is deduced): qt_noop();
-
128 return;
never executed: return;
0
129 case QSqlTableModelPrivate::Update: -
130 case QSqlTableModelPrivate::Delete: -
131 if (!r.submitted()) {
evaluated: !r.submitted()
TRUEFALSE
yes
Evaluation Count:17
yes
Evaluation Count:3
3-17
132 cache[row].revert();
executed (the execution status of this line is deduced): cache[row].revert();
-
133 emit q->dataChanged(q->createIndex(row, 0),
executed (the execution status of this line is deduced): q->dataChanged(q->createIndex(row, 0),
-
134 q->createIndex(row, q->columnCount() - 1));
executed (the execution status of this line is deduced): q->createIndex(row, q->columnCount() - 1));
-
135 }
executed: }
Execution Count:17
17
136 break;
executed: break;
Execution Count:20
20
137 case QSqlTableModelPrivate::Insert: { -
138 QMap<int, QSqlTableModelPrivate::ModifiedRow>::Iterator it = cache.find(row);
executed (the execution status of this line is deduced): QMap<int, QSqlTableModelPrivate::ModifiedRow>::Iterator it = cache.find(row);
-
139 if (it == cache.end())
partially evaluated: it == cache.end()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:32
0-32
140 return;
never executed: return;
0
141 q->beginRemoveRows(QModelIndex(), row, row);
executed (the execution status of this line is deduced): q->beginRemoveRows(QModelIndex(), row, row);
-
142 it = cache.erase(it);
executed (the execution status of this line is deduced): it = cache.erase(it);
-
143 while (it != cache.end()) {
evaluated: it != cache.end()
TRUEFALSE
yes
Evaluation Count:5
yes
Evaluation Count:32
5-32
144 int oldKey = it.key();
executed (the execution status of this line is deduced): int oldKey = it.key();
-
145 const QSqlTableModelPrivate::ModifiedRow oldValue = it.value();
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow oldValue = it.value();
-
146 cache.erase(it);
executed (the execution status of this line is deduced): cache.erase(it);
-
147 it = cache.insert(oldKey - 1, oldValue);
executed (the execution status of this line is deduced): it = cache.insert(oldKey - 1, oldValue);
-
148 ++it;
executed (the execution status of this line is deduced): ++it;
-
149 }
executed: }
Execution Count:5
5
150 q->endRemoveRows();
executed (the execution status of this line is deduced): q->endRemoveRows();
-
151 break; }
executed: break;
Execution Count:32
32
152 } -
153}
executed: }
Execution Count:52
52
154 -
155bool QSqlTableModelPrivate::exec(const QString &stmt, bool prepStatement, -
156 const QSqlRecord &rec, const QSqlRecord &whereValues) -
157{ -
158 if (stmt.isEmpty())
partially evaluated: stmt.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:123
0-123
159 return false;
never executed: return false;
0
160 -
161 // lazy initialization of editQuery -
162 if (editQuery.driver() != db.driver())
evaluated: editQuery.driver() != db.driver()
TRUEFALSE
yes
Evaluation Count:51
yes
Evaluation Count:72
51-72
163 editQuery = QSqlQuery(db);
executed: editQuery = QSqlQuery(db);
Execution Count:51
51
164 -
165 // workaround for In-Process databases - remove all read locks -
166 // from the table to make sure the editQuery succeeds -
167 if (db.driver()->hasFeature(QSqlDriver::SimpleLocking))
partially evaluated: db.driver()->hasFeature(QSqlDriver::SimpleLocking)
TRUEFALSE
yes
Evaluation Count:123
no
Evaluation Count:0
0-123
168 const_cast<QSqlResult *>(query.result())->detachFromResultSet();
executed: const_cast<QSqlResult *>(query.result())->detachFromResultSet();
Execution Count:123
123
169 -
170 if (prepStatement) {
partially evaluated: prepStatement
TRUEFALSE
yes
Evaluation Count:123
no
Evaluation Count:0
0-123
171 if (editQuery.lastQuery() != stmt) {
evaluated: editQuery.lastQuery() != stmt
TRUEFALSE
yes
Evaluation Count:79
yes
Evaluation Count:44
44-79
172 if (!editQuery.prepare(stmt)) {
partially evaluated: !editQuery.prepare(stmt)
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:79
0-79
173 error = editQuery.lastError();
never executed (the execution status of this line is deduced): error = editQuery.lastError();
-
174 return false;
never executed: return false;
0
175 } -
176 }
executed: }
Execution Count:79
79
177 int i;
executed (the execution status of this line is deduced): int i;
-
178 for (i = 0; i < rec.count(); ++i)
evaluated: i < rec.count()
TRUEFALSE
yes
Evaluation Count:298
yes
Evaluation Count:123
123-298
179 if (rec.isGenerated(i))
evaluated: rec.isGenerated(i)
TRUEFALSE
yes
Evaluation Count:192
yes
Evaluation Count:106
106-192
180 editQuery.addBindValue(rec.value(i));
executed: editQuery.addBindValue(rec.value(i));
Execution Count:192
192
181 for (i = 0; i < whereValues.count(); ++i)
evaluated: i < whereValues.count()
TRUEFALSE
yes
Evaluation Count:156
yes
Evaluation Count:123
123-156
182 if (whereValues.isGenerated(i) && !whereValues.isNull(i))
partially evaluated: whereValues.isGenerated(i)
TRUEFALSE
yes
Evaluation Count:156
no
Evaluation Count:0
evaluated: !whereValues.isNull(i)
TRUEFALSE
yes
Evaluation Count:150
yes
Evaluation Count:6
0-156
183 editQuery.addBindValue(whereValues.value(i));
executed: editQuery.addBindValue(whereValues.value(i));
Execution Count:150
150
184 -
185 if (!editQuery.exec()) {
evaluated: !editQuery.exec()
TRUEFALSE
yes
Evaluation Count:6
yes
Evaluation Count:117
6-117
186 error = editQuery.lastError();
executed (the execution status of this line is deduced): error = editQuery.lastError();
-
187 return false;
executed: return false;
Execution Count:6
6
188 } -
189 } else {
executed: }
Execution Count:117
117
190 if (!editQuery.exec(stmt)) {
never evaluated: !editQuery.exec(stmt)
0
191 error = editQuery.lastError();
never executed (the execution status of this line is deduced): error = editQuery.lastError();
-
192 return false;
never executed: return false;
0
193 } -
194 }
never executed: }
0
195 return true;
executed: return true;
Execution Count:117
117
196} -
197 -
198QSqlRecord QSqlTableModelPrivate::primaryValues(const QSqlRecord &rec, const QSqlRecord &pIndex) -
199{ -
200 QSqlRecord pValues(pIndex);
executed (the execution status of this line is deduced): QSqlRecord pValues(pIndex);
-
201 -
202 for (int i = pValues.count() - 1; i >= 0; --i)
evaluated: i >= 0
TRUEFALSE
yes
Evaluation Count:278
yes
Evaluation Count:133
133-278
203 pValues.setValue(i, rec.value(pValues.fieldName(i)));
executed: pValues.setValue(i, rec.value(pValues.fieldName(i)));
Execution Count:278
278
204 -
205 return pValues;
executed: return pValues;
Execution Count:133
133
206} -
207 -
208QSqlRecord QSqlTableModelPrivate::primaryValues(int row) const -
209{ -
210 Q_Q(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModel * const q = q_func();
-
211 -
212 const QSqlRecord &pIndex = primaryIndex.isEmpty() ? rec : primaryIndex;
evaluated: primaryIndex.isEmpty()
TRUEFALSE
yes
Evaluation Count:73
yes
Evaluation Count:60
60-73
213 -
214 ModifiedRow mr = cache.value(row);
executed (the execution status of this line is deduced): ModifiedRow mr = cache.value(row);
-
215 if (mr.op() != None)
evaluated: mr.op() != None
TRUEFALSE
yes
Evaluation Count:131
yes
Evaluation Count:2
2-131
216 return mr.primaryValues(pIndex);
executed: return mr.primaryValues(pIndex);
Execution Count:131
131
217 else -
218 return primaryValues(q->QSqlQueryModel::record(row), pIndex);
executed: return primaryValues(q->QSqlQueryModel::record(row), pIndex);
Execution Count:2
2
219} -
220 -
221/*! -
222 \class QSqlTableModel -
223 \brief The QSqlTableModel class provides an editable data model -
224 for a single database table. -
225 -
226 \ingroup database -
227 \inmodule QtSql -
228 -
229 QSqlTableModel is a high-level interface for reading and writing -
230 database records from a single table. It is build on top of the -
231 lower-level QSqlQuery and can be used to provide data to view -
232 classes such as QTableView. For example: -
233 -
234 \snippet sqldatabase/sqldatabase.cpp 24 -
235 -
236 We set the SQL table's name and the edit strategy, then we set up -
237 the labels displayed in the view header. The edit strategy -
238 dictates when the changes done by the user in the view are -
239 actually applied to the database. The possible values are \l -
240 OnFieldChange, \l OnRowChange, and \l OnManualSubmit. -
241 -
242 QSqlTableModel can also be used to access a database -
243 programmatically, without binding it to a view: -
244 -
245 \snippet sqldatabase/sqldatabase.cpp 21 -
246 -
247 The code snippet above extracts the \c salary field from record 4 in -
248 the result set of the query \c{SELECT * from employee}. -
249 -
250 It is possible to set filters using setFilter(), or modify the -
251 sort order using setSort(). At the end, you must call select() to -
252 populate the model with data. -
253 -
254 The \l{tablemodel} example illustrates how to use -
255 QSqlTableModel as the data source for a QTableView. -
256 -
257 QSqlTableModel provides no direct support for foreign keys. Use -
258 the QSqlRelationalTableModel and QSqlRelationalDelegate if you -
259 want to resolve foreign keys. -
260 -
261 \sa QSqlRelationalTableModel, QSqlQuery, {Model/View Programming}, -
262 {Table Model Example}, {Cached Table Example} -
263*/ -
264 -
265/*! -
266 \fn QSqlTableModel::beforeDelete(int row) -
267 -
268 This signal is emitted by deleteRowFromTable() before the \a row -
269 is deleted from the currently active database table. -
270*/ -
271 -
272/*! -
273 \fn void QSqlTableModel::primeInsert(int row, QSqlRecord &record) -
274 -
275 This signal is emitted by insertRows(), when an insertion is -
276 initiated in the given \a row of the currently active database -
277 table. The \a record parameter can be written to (since it is a -
278 reference), for example to populate some fields with default -
279 values and set the generated flags of the fields. Do not try to -
280 edit the record via other means such as setData() or setRecord() -
281 while handling this signal. -
282*/ -
283 -
284/*! -
285 \fn QSqlTableModel::beforeInsert(QSqlRecord &record) -
286 -
287 This signal is emitted by insertRowIntoTable() before a new row is -
288 inserted into the currently active database table. The values that -
289 are about to be inserted are stored in \a record and can be -
290 modified before they will be inserted. -
291*/ -
292 -
293/*! -
294 \fn QSqlTableModel::beforeUpdate(int row, QSqlRecord &record) -
295 -
296 This signal is emitted by updateRowInTable() before the \a row is -
297 updated in the currently active database table with the values -
298 from \a record. -
299 -
300 Note that only values that are marked as generated will be updated. -
301 The generated flag can be set with \l QSqlRecord::setGenerated() -
302 and checked with \l QSqlRecord::isGenerated(). -
303 -
304 \sa QSqlRecord::isGenerated() -
305*/ -
306 -
307/*! -
308 Creates an empty QSqlTableModel and sets the parent to \a parent -
309 and the database connection to \a db. If \a db is not valid, the -
310 default database connection will be used. -
311 -
312 The default edit strategy is \l OnRowChange. -
313*/ -
314QSqlTableModel::QSqlTableModel(QObject *parent, QSqlDatabase db) -
315 : QSqlQueryModel(*new QSqlTableModelPrivate, parent) -
316{ -
317 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
318 d->db = db.isValid() ? db : QSqlDatabase::database();
evaluated: db.isValid()
TRUEFALSE
yes
Evaluation Count:92
yes
Evaluation Count:51
51-92
319}
executed: }
Execution Count:143
143
320 -
321/*! \internal -
322*/ -
323QSqlTableModel::QSqlTableModel(QSqlTableModelPrivate &dd, QObject *parent, QSqlDatabase db) -
324 : QSqlQueryModel(dd, parent) -
325{ -
326 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
327 d->db = db.isValid() ? db : QSqlDatabase::database();
partially evaluated: db.isValid()
TRUEFALSE
yes
Evaluation Count:31
no
Evaluation Count:0
0-31
328}
executed: }
Execution Count:31
31
329 -
330/*! -
331 Destroys the object and frees any allocated resources. -
332*/ -
333QSqlTableModel::~QSqlTableModel() -
334{ -
335} -
336 -
337/*! -
338 Sets the database table on which the model operates to \a -
339 tableName. Does not select data from the table, but fetches its -
340 field information. -
341 -
342 To populate the model with the table's data, call select(). -
343 -
344 Error information can be retrieved with \l lastError(). -
345 -
346 \sa select(), setFilter(), lastError() -
347*/ -
348void QSqlTableModel::setTable(const QString &tableName) -
349{ -
350 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
351 clear();
executed (the execution status of this line is deduced): clear();
-
352 d->tableName = tableName;
executed (the execution status of this line is deduced): d->tableName = tableName;
-
353 d->initRecordAndPrimaryIndex();
executed (the execution status of this line is deduced): d->initRecordAndPrimaryIndex();
-
354 -
355 if (d->rec.count() == 0)
evaluated: d->rec.count() == 0
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:182
1-182
356 d->error = QSqlError(QLatin1String("Unable to find table ") + d->tableName, QString(),
executed: d->error = QSqlError(QLatin1String("Unable to find table ") + d->tableName, QString(), QSqlError::StatementError);
Execution Count:1
1
357 QSqlError::StatementError);
executed: d->error = QSqlError(QLatin1String("Unable to find table ") + d->tableName, QString(), QSqlError::StatementError);
Execution Count:1
1
358 -
359 // Remember the auto index column if there is one now. -
360 // The record that will be obtained from the query after select lacks this feature. -
361 d->autoColumn.clear();
executed (the execution status of this line is deduced): d->autoColumn.clear();
-
362 for (int c = 0; c < d->rec.count(); ++c) {
evaluated: c < d->rec.count()
TRUEFALSE
yes
Evaluation Count:450
yes
Evaluation Count:178
178-450
363 if (d->rec.field(c).isAutoValue()) {
evaluated: d->rec.field(c).isAutoValue()
TRUEFALSE
yes
Evaluation Count:5
yes
Evaluation Count:445
5-445
364 d->autoColumn = d->rec.fieldName(c);
executed (the execution status of this line is deduced): d->autoColumn = d->rec.fieldName(c);
-
365 break;
executed: break;
Execution Count:5
5
366 } -
367 }
executed: }
Execution Count:445
445
368}
executed: }
Execution Count:183
183
369 -
370/*! -
371 Returns the name of the currently selected table. -
372*/ -
373QString QSqlTableModel::tableName() const -
374{ -
375 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
376 return d->tableName;
executed: return d->tableName;
Execution Count:475
475
377} -
378 -
379/*! -
380 Populates the model with data from the table that was set via setTable(), using the -
381 specified filter and sort condition, and returns true if successful; otherwise -
382 returns false. -
383 -
384 \note Calling select() will revert any unsubmitted changes and remove any inserted columns. -
385 -
386 \sa setTable(), setFilter(), selectStatement() -
387*/ -
388bool QSqlTableModel::select() -
389{ -
390 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
391 const QString query = selectStatement();
executed (the execution status of this line is deduced): const QString query = selectStatement();
-
392 if (query.isEmpty())
evaluated: query.isEmpty()
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:315
1-315
393 return false;
executed: return false;
Execution Count:1
1
394 -
395 beginResetModel();
executed (the execution status of this line is deduced): beginResetModel();
-
396 -
397 d->clearCache();
executed (the execution status of this line is deduced): d->clearCache();
-
398 -
399 QSqlQuery qu(query, d->db);
executed (the execution status of this line is deduced): QSqlQuery qu(query, d->db);
-
400 setQuery(qu);
executed (the execution status of this line is deduced): setQuery(qu);
-
401 -
402 if (!qu.isActive() || lastError().isValid()) {
evaluated: !qu.isActive()
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:313
partially evaluated: lastError().isValid()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:313
0-313
403 // something went wrong - revert to non-select state -
404 d->initRecordAndPrimaryIndex();
executed (the execution status of this line is deduced): d->initRecordAndPrimaryIndex();
-
405 endResetModel();
executed (the execution status of this line is deduced): endResetModel();
-
406 return false;
executed: return false;
Execution Count:2
2
407 } -
408 endResetModel();
executed (the execution status of this line is deduced): endResetModel();
-
409 return true;
executed: return true;
Execution Count:313
313
410} -
411 -
412/*! -
413 \since 5.0 -
414 -
415 Refreshes \a row in the model with values from the database table row matching -
416 on primary key values. Without a primary key, all column values must match. If -
417 no matching row is found, the model will show an empty row. -
418 -
419 Returns true if successful; otherwise returns false. -
420 -
421 \sa select() -
422*/ -
423bool QSqlTableModel::selectRow(int row) -
424{ -
425 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
426 -
427 if (row < 0 || row >= rowCount())
partially evaluated: row < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:62
partially evaluated: row >= rowCount()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:62
0-62
428 return false;
never executed: return false;
0
429 -
430 const int table_sort_col = d->sortColumn;
executed (the execution status of this line is deduced): const int table_sort_col = d->sortColumn;
-
431 d->sortColumn = -1;
executed (the execution status of this line is deduced): d->sortColumn = -1;
-
432 const QString table_filter = d->filter;
executed (the execution status of this line is deduced): const QString table_filter = d->filter;
-
433 d->filter = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
executed (the execution status of this line is deduced): d->filter = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
-
434 d->tableName,
executed (the execution status of this line is deduced): d->tableName,
-
435 d->primaryValues(row),
executed (the execution status of this line is deduced): d->primaryValues(row),
-
436 false);
executed (the execution status of this line is deduced): false);
-
437 static const QString wh = Sql::where() + Sql::sp(); -
438 if (d->filter.startsWith(wh, Qt::CaseInsensitive))
partially evaluated: d->filter.startsWith(wh, Qt::CaseInsensitive)
TRUEFALSE
yes
Evaluation Count:62
no
Evaluation Count:0
0-62
439 d->filter.remove(0, wh.length());
executed: d->filter.remove(0, wh.length());
Execution Count:62
62
440 -
441 QString stmt;
executed (the execution status of this line is deduced): QString stmt;
-
442 -
443 if (!d->filter.isEmpty())
partially evaluated: !d->filter.isEmpty()
TRUEFALSE
yes
Evaluation Count:62
no
Evaluation Count:0
0-62
444 stmt = selectStatement();
executed: stmt = selectStatement();
Execution Count:62
62
445 -
446 d->sortColumn = table_sort_col;
executed (the execution status of this line is deduced): d->sortColumn = table_sort_col;
-
447 d->filter = table_filter;
executed (the execution status of this line is deduced): d->filter = table_filter;
-
448 -
449 if (stmt.isEmpty())
partially evaluated: stmt.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:62
0-62
450 return false;
never executed: return false;
0
451 -
452 bool exists;
executed (the execution status of this line is deduced): bool exists;
-
453 QSqlRecord newValues;
executed (the execution status of this line is deduced): QSqlRecord newValues;
-
454 -
455 { -
456 QSqlQuery q(d->db);
executed (the execution status of this line is deduced): QSqlQuery q(d->db);
-
457 q.setForwardOnly(true);
executed (the execution status of this line is deduced): q.setForwardOnly(true);
-
458 if (!q.exec(stmt))
partially evaluated: !q.exec(stmt)
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:62
0-62
459 return false;
never executed: return false;
0
460 -
461 exists = q.next();
executed (the execution status of this line is deduced): exists = q.next();
-
462 newValues = q.record();
executed (the execution status of this line is deduced): newValues = q.record();
-
463 } -
464 -
465 bool needsAddingToCache = !exists || d->cache.contains(row);
evaluated: !exists
TRUEFALSE
yes
Evaluation Count:9
yes
Evaluation Count:53
evaluated: d->cache.contains(row)
TRUEFALSE
yes
Evaluation Count:51
yes
Evaluation Count:2
2-53
466 -
467 if (!needsAddingToCache) {
evaluated: !needsAddingToCache
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:60
2-60
468 const QSqlRecord curValues = record(row);
executed (the execution status of this line is deduced): const QSqlRecord curValues = record(row);
-
469 needsAddingToCache = curValues.count() != newValues.count();
executed (the execution status of this line is deduced): needsAddingToCache = curValues.count() != newValues.count();
-
470 if (!needsAddingToCache) {
partially evaluated: !needsAddingToCache
TRUEFALSE
yes
Evaluation Count:2
no
Evaluation Count:0
0-2
471 // Look for changed values. Primary key fields are customarily first -
472 // and probably change less often than other fields, so start at the end. -
473 for (int f = curValues.count() - 1; f >= 0; --f) {
partially evaluated: f >= 0
TRUEFALSE
yes
Evaluation Count:2
no
Evaluation Count:0
0-2
474 if (curValues.value(f) != newValues.value(f))
evaluated: curValues.value(f) != newValues.value(f)
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:1
1
475 needsAddingToCache = true;
executed: needsAddingToCache = true;
Execution Count:1
1
476 break;
executed: break;
Execution Count:2
2
477 } -
478 }
executed: }
Execution Count:2
2
479 }
executed: }
Execution Count:2
2
480 -
481 if (needsAddingToCache) {
evaluated: needsAddingToCache
TRUEFALSE
yes
Evaluation Count:61
yes
Evaluation Count:1
1-61
482 d->cache[row].refresh(exists, newValues);
executed (the execution status of this line is deduced): d->cache[row].refresh(exists, newValues);
-
483 emit headerDataChanged(Qt::Vertical, row, row);
executed (the execution status of this line is deduced): headerDataChanged(Qt::Vertical, row, row);
-
484 emit dataChanged(createIndex(row, 0), createIndex(row, columnCount() - 1));
executed (the execution status of this line is deduced): dataChanged(createIndex(row, 0), createIndex(row, columnCount() - 1));
-
485 }
executed: }
Execution Count:61
61
486 -
487 return true;
executed: return true;
Execution Count:62
62
488} -
489 -
490/*! -
491 \reimp -
492*/ -
493QVariant QSqlTableModel::data(const QModelIndex &index, int role) const -
494{ -
495 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
496 if (!index.isValid() || (role != Qt::DisplayRole && role != Qt::EditRole))
evaluated: !index.isValid()
TRUEFALSE
yes
Evaluation Count:318
yes
Evaluation Count:2596
evaluated: role != Qt::DisplayRole
TRUEFALSE
yes
Evaluation Count:868
yes
Evaluation Count:1728
evaluated: role != Qt::EditRole
TRUEFALSE
yes
Evaluation Count:9
yes
Evaluation Count:859
9-2596
497 return QVariant();
executed: return QVariant();
Execution Count:327
327
498 -
499 const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(index.row());
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(index.row());
-
500 if (mrow.op() != QSqlTableModelPrivate::None)
evaluated: mrow.op() != QSqlTableModelPrivate::None
TRUEFALSE
yes
Evaluation Count:392
yes
Evaluation Count:2195
392-2195
501 return mrow.rec().value(index.column());
executed: return mrow.rec().value(index.column());
Execution Count:392
392
502 -
503 return QSqlQueryModel::data(index, role);
executed: return QSqlQueryModel::data(index, role);
Execution Count:2195
2195
504} -
505 -
506/*! -
507 \reimp -
508*/ -
509QVariant QSqlTableModel::headerData(int section, Qt::Orientation orientation, int role) const -
510{ -
511 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
512 if (orientation == Qt::Vertical && role == Qt::DisplayRole) {
partially evaluated: orientation == Qt::Vertical
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:4
never evaluated: role == Qt::DisplayRole
0-4
513 const QSqlTableModelPrivate::Op op = d->cache.value(section).op();
never executed (the execution status of this line is deduced): const QSqlTableModelPrivate::Op op = d->cache.value(section).op();
-
514 if (op == QSqlTableModelPrivate::Insert)
never evaluated: op == QSqlTableModelPrivate::Insert
0
515 return QLatin1String("*");
never executed: return QLatin1String("*");
0
516 else if (op == QSqlTableModelPrivate::Delete)
never evaluated: op == QSqlTableModelPrivate::Delete
0
517 return QLatin1String("!");
never executed: return QLatin1String("!");
0
518 } -
519 return QSqlQueryModel::headerData(section, orientation, role);
executed: return QSqlQueryModel::headerData(section, orientation, role);
Execution Count:4
4
520} -
521 -
522/*! -
523 \overload -
524 \since 5.0 -
525 -
526 Returns true if the model contains modified values that have not been -
527 committed to the datase, otherwise false. -
528*/ -
529bool QSqlTableModel::isDirty() const -
530{ -
531 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
532 QSqlTableModelPrivate::CacheMap::ConstIterator i = d->cache.constBegin();
executed (the execution status of this line is deduced): QSqlTableModelPrivate::CacheMap::ConstIterator i = d->cache.constBegin();
-
533 const QSqlTableModelPrivate::CacheMap::ConstIterator e = d->cache.constEnd();
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::CacheMap::ConstIterator e = d->cache.constEnd();
-
534 for (; i != e; i++)
evaluated: i != e
TRUEFALSE
yes
Evaluation Count:74
yes
Evaluation Count:144
74-144
535 if (!i.value().submitted())
evaluated: !i.value().submitted()
TRUEFALSE
yes
Evaluation Count:36
yes
Evaluation Count:38
36-38
536 return true;
executed: return true;
Execution Count:36
36
537 return false;
executed: return false;
Execution Count:144
144
538} -
539 -
540/*! -
541 Returns true if the value at the index \a index is dirty, otherwise false. -
542 Dirty values are values that were modified in the model -
543 but not yet written into the database. -
544 -
545 If \a index is invalid or points to a non-existing row, false is returned. -
546*/ -
547bool QSqlTableModel::isDirty(const QModelIndex &index) const -
548{ -
549 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
550 if (!index.isValid())
partially evaluated: !index.isValid()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:79
0-79
551 return false;
never executed: return false;
0
552 -
553 const QSqlTableModelPrivate::ModifiedRow row = d->cache.value(index.row());
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow row = d->cache.value(index.row());
-
554 if (row.submitted())
evaluated: row.submitted()
TRUEFALSE
yes
Evaluation Count:57
yes
Evaluation Count:22
22-57
555 return false;
executed: return false;
Execution Count:57
57
556 -
557 return row.op() == QSqlTableModelPrivate::Insert
executed: return row.op() == QSqlTableModelPrivate::Insert || row.op() == QSqlTableModelPrivate::Delete || (row.op() == QSqlTableModelPrivate::Update && row.rec().isGenerated(index.column()));
Execution Count:22
22
558 || row.op() == QSqlTableModelPrivate::Delete
executed: return row.op() == QSqlTableModelPrivate::Insert || row.op() == QSqlTableModelPrivate::Delete || (row.op() == QSqlTableModelPrivate::Update && row.rec().isGenerated(index.column()));
Execution Count:22
22
559 || (row.op() == QSqlTableModelPrivate::Update
executed: return row.op() == QSqlTableModelPrivate::Insert || row.op() == QSqlTableModelPrivate::Delete || (row.op() == QSqlTableModelPrivate::Update && row.rec().isGenerated(index.column()));
Execution Count:22
22
560 && row.rec().isGenerated(index.column()));
executed: return row.op() == QSqlTableModelPrivate::Insert || row.op() == QSqlTableModelPrivate::Delete || (row.op() == QSqlTableModelPrivate::Update && row.rec().isGenerated(index.column()));
Execution Count:22
22
561} -
562 -
563/*! -
564 Sets the data for the item \a index for the role \a role to \a -
565 value. -
566 -
567 For edit strategy OnFieldChange, an index may receive a change -
568 only if no other index has a cached change. Changes are -
569 submitted immediately. However, rows that have not yet been -
570 inserted in the database may be freely changed and are not -
571 submitted automatically. Submitted changes are not reverted upon -
572 failure. -
573 -
574 For OnRowChange, an index may receive a change only if no other -
575 row has a cached change. Changes are not submitted automatically. -
576 -
577 Returns true if \a value is equal to the current value. However, -
578 the value will not be submitted to the database. -
579 -
580 Returns true if the value could be set or false on error, for -
581 example if \a index is out of bounds. -
582 -
583 \sa editStrategy(), data(), submit(), submitAll(), revertRow() -
584*/ -
585bool QSqlTableModel::setData(const QModelIndex &index, const QVariant &value, int role) -
586{ -
587 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
588 if (d->busyInsertingRows)
partially evaluated: d->busyInsertingRows
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:270
0-270
589 return false;
never executed: return false;
0
590 -
591 if (role != Qt::EditRole)
evaluated: role != Qt::EditRole
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:268
2-268
592 return QSqlQueryModel::setData(index, value, role);
executed: return QSqlQueryModel::setData(index, value, role);
Execution Count:2
2
593 -
594 if (!index.isValid() || index.column() >= d->rec.count() || index.row() >= rowCount())
evaluated: !index.isValid()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:265
partially evaluated: index.column() >= d->rec.count()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:265
partially evaluated: index.row() >= rowCount()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:265
0-265
595 return false;
executed: return false;
Execution Count:3
3
596 -
597 if (!(flags(index) & Qt::ItemIsEditable))
evaluated: !(flags(index) & Qt::ItemIsEditable)
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:262
3-262
598 return false;
executed: return false;
Execution Count:3
3
599 -
600 const QVariant oldValue = QSqlTableModel::data(index, role);
executed (the execution status of this line is deduced): const QVariant oldValue = QSqlTableModel::data(index, role);
-
601 if (value == oldValue
evaluated: value == oldValue
TRUEFALSE
yes
Evaluation Count:33
yes
Evaluation Count:229
33-229
602 && value.isNull() == oldValue.isNull()
evaluated: value.isNull() == oldValue.isNull()
TRUEFALSE
yes
Evaluation Count:30
yes
Evaluation Count:3
3-30
603 && d->cache.value(index.row()).op() != QSqlTableModelPrivate::Insert)
evaluated: d->cache.value(index.row()).op() != QSqlTableModelPrivate::Insert
TRUEFALSE
yes
Evaluation Count:23
yes
Evaluation Count:7
7-23
604 return true;
executed: return true;
Execution Count:23
23
605 -
606 QSqlTableModelPrivate::ModifiedRow &row = d->cache[index.row()];
executed (the execution status of this line is deduced): QSqlTableModelPrivate::ModifiedRow &row = d->cache[index.row()];
-
607 -
608 if (row.op() == QSqlTableModelPrivate::None)
evaluated: row.op() == QSqlTableModelPrivate::None
TRUEFALSE
yes
Evaluation Count:47
yes
Evaluation Count:192
47-192
609 row = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update,
executed: row = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update, QSqlQueryModel::record(index.row()));
Execution Count:47
47
610 QSqlQueryModel::record(index.row()));
executed: row = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update, QSqlQueryModel::record(index.row()));
Execution Count:47
47
611 -
612 row.setValue(index.column(), value);
executed (the execution status of this line is deduced): row.setValue(index.column(), value);
-
613 emit dataChanged(index, index);
executed (the execution status of this line is deduced): dataChanged(index, index);
-
614 -
615 if (d->strategy == OnFieldChange && row.op() != QSqlTableModelPrivate::Insert)
evaluated: d->strategy == OnFieldChange
TRUEFALSE
yes
Evaluation Count:15
yes
Evaluation Count:224
evaluated: row.op() != QSqlTableModelPrivate::Insert
TRUEFALSE
yes
Evaluation Count:8
yes
Evaluation Count:7
7-224
616 return submit();
executed: return submit();
Execution Count:8
8
617 -
618 return true;
executed: return true;
Execution Count:231
231
619} -
620 -
621/*! -
622 This function simply calls QSqlQueryModel::setQuery(\a query). -
623 You should normally not call it on a QSqlTableModel. Instead, use -
624 setTable(), setSort(), setFilter(), etc., to set up the query. -
625 -
626 \sa selectStatement() -
627*/ -
628void QSqlTableModel::setQuery(const QSqlQuery &query) -
629{ -
630 QSqlQueryModel::setQuery(query);
executed (the execution status of this line is deduced): QSqlQueryModel::setQuery(query);
-
631}
executed: }
Execution Count:315
315
632 -
633/*! -
634 Updates the given \a row in the currently active database table -
635 with the specified \a values. Returns true if successful; otherwise -
636 returns false. -
637 -
638 This is a low-level method that operates directly on the database -
639 and should not be called directly. Use setData() to update values. -
640 The model will decide depending on its edit strategy when to modify -
641 the database. -
642 -
643 Note that only values that have the generated-flag set are updated. -
644 The generated-flag can be set with QSqlRecord::setGenerated() and -
645 tested with QSqlRecord::isGenerated(). -
646 -
647 \sa QSqlRecord::isGenerated(), setData() -
648*/ -
649bool QSqlTableModel::updateRowInTable(int row, const QSqlRecord &values) -
650{ -
651 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
652 QSqlRecord rec(values);
executed (the execution status of this line is deduced): QSqlRecord rec(values);
-
653 emit beforeUpdate(row, rec);
executed (the execution status of this line is deduced): beforeUpdate(row, rec);
-
654 -
655 const QSqlRecord whereValues = d->primaryValues(row);
executed (the execution status of this line is deduced): const QSqlRecord whereValues = d->primaryValues(row);
-
656 const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
executed (the execution status of this line is deduced): const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
-
657 const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::UpdateStatement, d->tableName,
executed (the execution status of this line is deduced): const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::UpdateStatement, d->tableName,
-
658 rec, prepStatement);
executed (the execution status of this line is deduced): rec, prepStatement);
-
659 const QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement, d->tableName,
executed (the execution status of this line is deduced): const QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement, d->tableName,
-
660 whereValues, prepStatement);
executed (the execution status of this line is deduced): whereValues, prepStatement);
-
661 -
662 if (stmt.isEmpty() || where.isEmpty() || row < 0 || row >= rowCount()) {
partially evaluated: stmt.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:49
partially evaluated: where.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:49
partially evaluated: row < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:49
partially evaluated: row >= rowCount()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:49
0-49
663 d->error = QSqlError(QLatin1String("No Fields to update"), QString(),
never executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("No Fields to update"), QString(),
-
664 QSqlError::StatementError);
never executed (the execution status of this line is deduced): QSqlError::StatementError);
-
665 return false;
never executed: return false;
0
666 } -
667 -
668 return d->exec(Sql::concat(stmt, where), prepStatement, rec, whereValues);
executed: return d->exec(Sql::concat(stmt, where), prepStatement, rec, whereValues);
Execution Count:49
49
669} -
670 -
671 -
672/*! -
673 Inserts the values \a values into the currently active database table. -
674 -
675 This is a low-level method that operates directly on the database -
676 and should not be called directly. Use insertRow() and setData() -
677 to insert values. The model will decide depending on its edit strategy -
678 when to modify the database. -
679 -
680 Returns true if the values could be inserted, otherwise false. -
681 Error information can be retrieved with \l lastError(). -
682 -
683 \sa lastError(), insertRow(), insertRows() -
684*/ -
685bool QSqlTableModel::insertRowIntoTable(const QSqlRecord &values) -
686{ -
687 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
688 QSqlRecord rec = values;
executed (the execution status of this line is deduced): QSqlRecord rec = values;
-
689 emit beforeInsert(rec);
executed (the execution status of this line is deduced): beforeInsert(rec);
-
690 -
691 const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
executed (the execution status of this line is deduced): const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
-
692 const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::InsertStatement, d->tableName,
executed (the execution status of this line is deduced): const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::InsertStatement, d->tableName,
-
693 rec, prepStatement);
executed (the execution status of this line is deduced): rec, prepStatement);
-
694 -
695 if (stmt.isEmpty()) {
evaluated: stmt.isEmpty()
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:52
1-52
696 d->error = QSqlError(QLatin1String("No Fields to update"), QString(),
executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("No Fields to update"), QString(),
-
697 QSqlError::StatementError);
executed (the execution status of this line is deduced): QSqlError::StatementError);
-
698 return false;
executed: return false;
Execution Count:1
1
699 } -
700 -
701 return d->exec(stmt, prepStatement, rec, QSqlRecord() /* no where values */);
executed: return d->exec(stmt, prepStatement, rec, QSqlRecord() );
Execution Count:52
52
702} -
703 -
704/*! -
705 Deletes the given \a row from the currently active database table. -
706 -
707 This is a low-level method that operates directly on the database -
708 and should not be called directly. Use removeRow() or removeRows() -
709 to delete values. The model will decide depending on its edit strategy -
710 when to modify the database. -
711 -
712 Returns true if the row was deleted; otherwise returns false. -
713 -
714 \sa removeRow(), removeRows() -
715*/ -
716bool QSqlTableModel::deleteRowFromTable(int row) -
717{ -
718 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
719 emit beforeDelete(row);
executed (the execution status of this line is deduced): beforeDelete(row);
-
720 -
721 const QSqlRecord whereValues = d->primaryValues(row);
executed (the execution status of this line is deduced): const QSqlRecord whereValues = d->primaryValues(row);
-
722 const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
executed (the execution status of this line is deduced): const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
-
723 const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::DeleteStatement,
executed (the execution status of this line is deduced): const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::DeleteStatement,
-
724 d->tableName,
executed (the execution status of this line is deduced): d->tableName,
-
725 QSqlRecord(),
executed (the execution status of this line is deduced): QSqlRecord(),
-
726 prepStatement);
executed (the execution status of this line is deduced): prepStatement);
-
727 const QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
executed (the execution status of this line is deduced): const QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
-
728 d->tableName,
executed (the execution status of this line is deduced): d->tableName,
-
729 whereValues,
executed (the execution status of this line is deduced): whereValues,
-
730 prepStatement);
executed (the execution status of this line is deduced): prepStatement);
-
731 -
732 if (stmt.isEmpty() || where.isEmpty()) {
partially evaluated: stmt.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:22
partially evaluated: where.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:22
0-22
733 d->error = QSqlError(QLatin1String("Unable to delete row"), QString(),
never executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("Unable to delete row"), QString(),
-
734 QSqlError::StatementError);
never executed (the execution status of this line is deduced): QSqlError::StatementError);
-
735 return false;
never executed: return false;
0
736 } -
737 -
738 return d->exec(Sql::concat(stmt, where), prepStatement, QSqlRecord() /* no new values */, whereValues);
executed: return d->exec(Sql::concat(stmt, where), prepStatement, QSqlRecord() , whereValues);
Execution Count:22
22
739} -
740 -
741/*! -
742 Submits all pending changes and returns true on success. -
743 Returns false on error, detailed error information can be -
744 obtained with lastError(). -
745 -
746 In OnManualSubmit, on success the model will be repopulated. -
747 Any views presenting it will lose their selections. -
748 -
749 Note: In OnManualSubmit mode, already submitted changes won't -
750 be cleared from the cache when submitAll() fails. This allows -
751 transactions to be rolled back and resubmitted without -
752 losing data. -
753 -
754 \sa revertAll(), lastError() -
755*/ -
756bool QSqlTableModel::submitAll() -
757{ -
758 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
759 -
760 bool success = true;
executed (the execution status of this line is deduced): bool success = true;
-
761 -
762 foreach (int row, d->cache.keys()) {
executed (the execution status of this line is deduced): for (QForeachContainer<__typeof__(d->cache.keys())> _container_(d->cache.keys()); !_container_.brk && _container_.i != _container_.e; __extension__ ({ ++_container_.brk; ++_container_.i; })) for (int row = *_container_.i;; __extension__ ({--_container_.brk; break;})) {
-
763 // be sure cache *still* contains the row since overriden selectRow() could have called select() -
764 QSqlTableModelPrivate::CacheMap::iterator it = d->cache.find(row);
executed (the execution status of this line is deduced): QSqlTableModelPrivate::CacheMap::iterator it = d->cache.find(row);
-
765 if (it == d->cache.end())
partially evaluated: it == d->cache.end()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:160
0-160
766 continue;
never executed: continue;
0
767 -
768 QSqlTableModelPrivate::ModifiedRow &mrow = it.value();
executed (the execution status of this line is deduced): QSqlTableModelPrivate::ModifiedRow &mrow = it.value();
-
769 if (mrow.submitted())
evaluated: mrow.submitted()
TRUEFALSE
yes
Evaluation Count:36
yes
Evaluation Count:124
36-124
770 continue;
executed: continue;
Execution Count:36
36
771 -
772 switch (mrow.op()) { -
773 case QSqlTableModelPrivate::Insert: -
774 success = insertRowIntoTable(mrow.rec());
executed (the execution status of this line is deduced): success = insertRowIntoTable(mrow.rec());
-
775 break;
executed: break;
Execution Count:53
53
776 case QSqlTableModelPrivate::Update: -
777 success = updateRowInTable(row, mrow.rec());
executed (the execution status of this line is deduced): success = updateRowInTable(row, mrow.rec());
-
778 break;
executed: break;
Execution Count:49
49
779 case QSqlTableModelPrivate::Delete: -
780 success = deleteRowFromTable(row);
executed (the execution status of this line is deduced): success = deleteRowFromTable(row);
-
781 break;
executed: break;
Execution Count:22
22
782 case QSqlTableModelPrivate::None: -
783 Q_ASSERT_X(false, "QSqlTableModel::submitAll()", "Invalid cache operation");
never executed (the execution status of this line is deduced): qt_noop();
-
784 break;
never executed: break;
0
785 } -
786 -
787 if (success) {
evaluated: success
TRUEFALSE
yes
Evaluation Count:117
yes
Evaluation Count:7
7-117
788 if (d->strategy != OnManualSubmit && mrow.op() == QSqlTableModelPrivate::Insert) {
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:60
yes
Evaluation Count:57
evaluated: mrow.op() == QSqlTableModelPrivate::Insert
TRUEFALSE
yes
Evaluation Count:23
yes
Evaluation Count:37
23-60
789 int c = mrow.rec().indexOf(d->autoColumn);
executed (the execution status of this line is deduced): int c = mrow.rec().indexOf(d->autoColumn);
-
790 if (c != -1 && !mrow.rec().isGenerated(c))
evaluated: c != -1
TRUEFALSE
yes
Evaluation Count:6
yes
Evaluation Count:17
partially evaluated: !mrow.rec().isGenerated(c)
TRUEFALSE
yes
Evaluation Count:6
no
Evaluation Count:0
0-17
791 mrow.setValue(c, d->editQuery.lastInsertId());
executed: mrow.setValue(c, d->editQuery.lastInsertId());
Execution Count:6
6
792 }
executed: }
Execution Count:23
23
793 mrow.setSubmitted();
executed (the execution status of this line is deduced): mrow.setSubmitted();
-
794 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:60
yes
Evaluation Count:57
57-60
795 success = selectRow(row);
executed: success = selectRow(row);
Execution Count:60
60
796 }
executed: }
Execution Count:117
117
797 -
798 if (!success)
evaluated: !success
TRUEFALSE
yes
Evaluation Count:7
yes
Evaluation Count:117
7-117
799 break;
executed: break;
Execution Count:7
7
800 }
executed: }
Execution Count:117
117
801 -
802 if (success) {
evaluated: success
TRUEFALSE
yes
Evaluation Count:118
yes
Evaluation Count:7
7-118
803 if (d->strategy == OnManualSubmit)
evaluated: d->strategy == OnManualSubmit
TRUEFALSE
yes
Evaluation Count:36
yes
Evaluation Count:82
36-82
804 success = select();
executed: success = select();
Execution Count:36
36
805 }
executed: }
Execution Count:118
118
806 -
807 return success;
executed: return success;
Execution Count:125
125
808} -
809 -
810/*! -
811 This reimplemented slot is called by the item delegates when the -
812 user stopped editing the current row. -
813 -
814 Submits the currently edited row if the model's strategy is set -
815 to OnRowChange or OnFieldChange. Does nothing for the OnManualSubmit -
816 strategy. -
817 -
818 Use submitAll() to submit all pending changes for the -
819 OnManualSubmit strategy. -
820 -
821 Returns true on success; otherwise returns false. Use lastError() -
822 to query detailed error information. -
823 -
824 Does not automatically repopulate the model. Submitted rows are -
825 refreshed from the database on success. -
826 -
827 \sa revert(), revertRow(), submitAll(), revertAll(), lastError() -
828*/ -
829bool QSqlTableModel::submit() -
830{ -
831 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
832 if (d->strategy == OnRowChange || d->strategy == OnFieldChange)
evaluated: d->strategy == OnRowChange
TRUEFALSE
yes
Evaluation Count:32
yes
Evaluation Count:25
evaluated: d->strategy == OnFieldChange
TRUEFALSE
yes
Evaluation Count:24
yes
Evaluation Count:1
1-32
833 return submitAll();
executed: return submitAll();
Execution Count:56
56
834 return true;
executed: return true;
Execution Count:1
1
835} -
836 -
837/*! -
838 This reimplemented slot is called by the item delegates when the -
839 user canceled editing the current row. -
840 -
841 Reverts the changes if the model's strategy is set to -
842 OnRowChange or OnFieldChange. Does nothing for the OnManualSubmit -
843 strategy. -
844 -
845 Use revertAll() to revert all pending changes for the -
846 OnManualSubmit strategy or revertRow() to revert a specific row. -
847 -
848 \sa submit(), submitAll(), revertRow(), revertAll() -
849*/ -
850void QSqlTableModel::revert() -
851{ -
852 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
853 if (d->strategy == OnRowChange || d->strategy == OnFieldChange)
evaluated: d->strategy == OnRowChange
TRUEFALSE
yes
Evaluation Count:4
yes
Evaluation Count:9
evaluated: d->strategy == OnFieldChange
TRUEFALSE
yes
Evaluation Count:4
yes
Evaluation Count:5
4-9
854 revertAll();
executed: revertAll();
Execution Count:8
8
855}
executed: }
Execution Count:13
13
856 -
857/*! -
858 \enum QSqlTableModel::EditStrategy -
859 -
860 This enum type describes which strategy to choose when editing values in the database. -
861 -
862 \value OnFieldChange All changes to the model will be applied immediately to the database. -
863 \value OnRowChange Changes to a row will be applied when the user selects a different row. -
864 \value OnManualSubmit All changes will be cached in the model until either submitAll() -
865 or revertAll() is called. -
866 -
867 Note: To prevent inserting only partly initialized rows into the database, -
868 \c OnFieldChange will behave like \c OnRowChange for newly inserted rows. -
869 -
870 \sa setEditStrategy() -
871*/ -
872 -
873 -
874/*! -
875 Sets the strategy for editing values in the database to \a -
876 strategy. -
877 -
878 This will revert any pending changes. -
879 -
880 \sa editStrategy(), revertAll() -
881*/ -
882void QSqlTableModel::setEditStrategy(EditStrategy strategy) -
883{ -
884 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
885 revertAll();
executed (the execution status of this line is deduced): revertAll();
-
886 d->strategy = strategy;
executed (the execution status of this line is deduced): d->strategy = strategy;
-
887}
executed: }
Execution Count:108
108
888 -
889/*! -
890 Returns the current edit strategy. -
891 -
892 \sa setEditStrategy() -
893*/ -
894QSqlTableModel::EditStrategy QSqlTableModel::editStrategy() const -
895{ -
896 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
897 return d->strategy;
executed: return d->strategy;
Execution Count:13
13
898} -
899 -
900/*! -
901 Reverts all pending changes. -
902 -
903 \sa revert(), revertRow(), submitAll() -
904*/ -
905void QSqlTableModel::revertAll() -
906{ -
907 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
908 -
909 const QList<int> rows(d->cache.keys());
executed (the execution status of this line is deduced): const QList<int> rows(d->cache.keys());
-
910 for (int i = rows.size() - 1; i >= 0; --i)
evaluated: i >= 0
TRUEFALSE
yes
Evaluation Count:35
yes
Evaluation Count:134
35-134
911 revertRow(rows.value(i));
executed: revertRow(rows.value(i));
Execution Count:35
35
912}
executed: }
Execution Count:134
134
913 -
914/*! -
915 Reverts all changes for the specified \a row. -
916 -
917 \sa revert(), revertAll(), submit(), submitAll() -
918*/ -
919void QSqlTableModel::revertRow(int row) -
920{ -
921 if (row < 0)
partially evaluated: row < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:52
0-52
922 return;
never executed: return;
0
923 -
924 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
925 d->revertCachedRow(row);
executed (the execution status of this line is deduced): d->revertCachedRow(row);
-
926}
executed: }
Execution Count:52
52
927 -
928/*! -
929 Returns the primary key for the current table, or an empty -
930 QSqlIndex if the table is not set or has no primary key. -
931 -
932 \sa setTable(), setPrimaryKey(), QSqlDatabase::primaryIndex() -
933*/ -
934QSqlIndex QSqlTableModel::primaryKey() const -
935{ -
936 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
937 return d->primaryIndex;
executed: return d->primaryIndex;
Execution Count:1
1
938} -
939 -
940/*! -
941 Protected method that allows subclasses to set the primary key to -
942 \a key. -
943 -
944 Normally, the primary index is set automatically whenever you -
945 call setTable(). -
946 -
947 \sa primaryKey(), QSqlDatabase::primaryIndex() -
948*/ -
949void QSqlTableModel::setPrimaryKey(const QSqlIndex &key) -
950{ -
951 Q_D(QSqlTableModel);
never executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
952 d->primaryIndex = key;
never executed (the execution status of this line is deduced): d->primaryIndex = key;
-
953}
never executed: }
0
954 -
955/*! -
956 Returns a pointer to the used QSqlDatabase or 0 if no database was set. -
957*/ -
958QSqlDatabase QSqlTableModel::database() const -
959{ -
960 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
961 return d->db;
executed: return d->db;
Execution Count:447
447
962} -
963 -
964/*! -
965 Sorts the data by \a column with the sort order \a order. -
966 This will immediately select data, use setSort() -
967 to set a sort order without populating the model with data. -
968 -
969 \sa setSort(), select(), orderByClause() -
970*/ -
971void QSqlTableModel::sort(int column, Qt::SortOrder order) -
972{ -
973 setSort(column, order);
executed (the execution status of this line is deduced): setSort(column, order);
-
974 select();
executed (the execution status of this line is deduced): select();
-
975}
executed: }
Execution Count:12
12
976 -
977/*! -
978 Sets the sort order for \a column to \a order. This does not -
979 affect the current data, to refresh the data using the new -
980 sort order, call select(). -
981 -
982 \sa select(), orderByClause() -
983*/ -
984void QSqlTableModel::setSort(int column, Qt::SortOrder order) -
985{ -
986 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
987 d->sortColumn = column;
executed (the execution status of this line is deduced): d->sortColumn = column;
-
988 d->sortOrder = order;
executed (the execution status of this line is deduced): d->sortOrder = order;
-
989}
executed: }
Execution Count:72
72
990 -
991/*! -
992 Returns an SQL \c{ORDER BY} clause based on the currently set -
993 sort order. -
994 -
995 \sa setSort(), selectStatement() -
996*/ -
997QString QSqlTableModel::orderByClause() const -
998{ -
999 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1000 QSqlField f = d->rec.field(d->sortColumn);
executed (the execution status of this line is deduced): QSqlField f = d->rec.field(d->sortColumn);
-
1001 if (!f.isValid())
evaluated: !f.isValid()
TRUEFALSE
yes
Evaluation Count:235
yes
Evaluation Count:138
138-235
1002 return QString();
executed: return QString();
Execution Count:235
235
1003 -
1004 //we can safely escape the field because it would have been obtained from the database -
1005 //and have the correct case -
1006 QString field = d->db.driver()->escapeIdentifier(f.name(), QSqlDriver::FieldName);
executed (the execution status of this line is deduced): QString field = d->db.driver()->escapeIdentifier(f.name(), QSqlDriver::FieldName);
-
1007 field.prepend(QLatin1Char('.')).prepend(d->tableName);
executed (the execution status of this line is deduced): field.prepend(QLatin1Char('.')).prepend(d->tableName);
-
1008 field = d->sortOrder == Qt::AscendingOrder ? Sql::asc(field) : Sql::desc(field);
evaluated: d->sortOrder == Qt::AscendingOrder
TRUEFALSE
yes
Evaluation Count:133
yes
Evaluation Count:5
5-133
1009 return Sql::orderBy(field);
executed: return Sql::orderBy(field);
Execution Count:138
138
1010} -
1011 -
1012/*! -
1013 Returns the index of the field \a fieldName, or -1 if no corresponding field -
1014 exists in the model. -
1015*/ -
1016int QSqlTableModel::fieldIndex(const QString &fieldName) const -
1017{ -
1018 Q_D(const QSqlTableModel);
never executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1019 return d->rec.indexOf(fieldName);
never executed: return d->rec.indexOf(fieldName);
0
1020} -
1021 -
1022/*! -
1023 Returns the SQL \c SELECT statement used internally to populate -
1024 the model. The statement includes the filter and the \c{ORDER BY} -
1025 clause. -
1026 -
1027 \sa filter(), orderByClause() -
1028*/ -
1029QString QSqlTableModel::selectStatement() const -
1030{ -
1031 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1032 if (d->tableName.isEmpty()) {
partially evaluated: d->tableName.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:294
0-294
1033 d->error = QSqlError(QLatin1String("No table name given"), QString(),
never executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("No table name given"), QString(),
-
1034 QSqlError::StatementError);
never executed (the execution status of this line is deduced): QSqlError::StatementError);
-
1035 return QString();
never executed: return QString();
0
1036 } -
1037 if (d->rec.isEmpty()) {
evaluated: d->rec.isEmpty()
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:293
1-293
1038 d->error = QSqlError(QLatin1String("Unable to find table ") + d->tableName, QString(),
executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("Unable to find table ") + d->tableName, QString(),
-
1039 QSqlError::StatementError);
executed (the execution status of this line is deduced): QSqlError::StatementError);
-
1040 return QString();
executed: return QString();
Execution Count:1
1
1041 } -
1042 -
1043 const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::SelectStatement,
executed (the execution status of this line is deduced): const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::SelectStatement,
-
1044 d->tableName,
executed (the execution status of this line is deduced): d->tableName,
-
1045 d->rec,
executed (the execution status of this line is deduced): d->rec,
-
1046 false);
executed (the execution status of this line is deduced): false);
-
1047 if (stmt.isEmpty()) {
partially evaluated: stmt.isEmpty()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:293
0-293
1048 d->error = QSqlError(QLatin1String("Unable to select fields from table ") + d->tableName,
never executed (the execution status of this line is deduced): d->error = QSqlError(QLatin1String("Unable to select fields from table ") + d->tableName,
-
1049 QString(), QSqlError::StatementError);
never executed (the execution status of this line is deduced): QString(), QSqlError::StatementError);
-
1050 return stmt;
never executed: return stmt;
0
1051 } -
1052 return Sql::concat(Sql::concat(stmt, Sql::where(d->filter)), orderByClause());
executed: return Sql::concat(Sql::concat(stmt, Sql::where(d->filter)), orderByClause());
Execution Count:293
293
1053} -
1054 -
1055/*! -
1056 Removes \a count columns from the \a parent model, starting at -
1057 index \a column. -
1058 -
1059 Returns if the columns were successfully removed; otherwise -
1060 returns false. -
1061 -
1062 \sa removeRows() -
1063*/ -
1064bool QSqlTableModel::removeColumns(int column, int count, const QModelIndex &parent) -
1065{ -
1066 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1067 if (parent.isValid() || column < 0 || column + count > d->rec.count())
partially evaluated: parent.isValid()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:5
partially evaluated: column < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:5
partially evaluated: column + count > d->rec.count()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:5
0-5
1068 return false;
never executed: return false;
0
1069 for (int i = 0; i < count; ++i)
evaluated: i < count
TRUEFALSE
yes
Evaluation Count:7
yes
Evaluation Count:5
5-7
1070 d->rec.remove(column);
executed: d->rec.remove(column);
Execution Count:7
7
1071 if (d->query.isActive())
partially evaluated: d->query.isActive()
TRUEFALSE
yes
Evaluation Count:5
no
Evaluation Count:0
0-5
1072 return select();
executed: return select();
Execution Count:5
5
1073 return true;
never executed: return true;
0
1074} -
1075 -
1076/*! -
1077 Removes \a count rows starting at \a row. Since this model -
1078 does not support hierarchical structures, \a parent must be -
1079 an invalid model index. -
1080 -
1081 When the edit strategy is OnManualSubmit, deletion of rows from -
1082 the database is delayed until submitAll() is called. -
1083 -
1084 For OnFieldChange and OnRowChange, only one row may be deleted -
1085 at a time and only if no other row has a cached change. Deletions -
1086 are submitted immediately to the database. The model retains a -
1087 blank row for successfully deleted row until refreshed with select(). -
1088 -
1089 After failed deletion, the operation is not reverted in the model. -
1090 The application may resubmit or revert. -
1091 -
1092 Inserted but not yet successfully submitted rows in the range to be -
1093 removed are immediately removed from the model. -
1094 -
1095 Before a row is deleted from the database, the beforeDelete() -
1096 signal is emitted. -
1097 -
1098 If row < 0 or row + count > rowCount(), no action is taken and -
1099 false is returned. Returns true if all rows could be removed; -
1100 otherwise returns false. Detailed database error information -
1101 can be retrieved using lastError(). -
1102 -
1103 \sa removeColumns(), insertRows() -
1104*/ -
1105bool QSqlTableModel::removeRows(int row, int count, const QModelIndex &parent) -
1106{ -
1107 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1108 if (parent.isValid() || row < 0 || count <= 0)
evaluated: parent.isValid()
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:41
evaluated: row < 0
TRUEFALSE
yes
Evaluation Count:4
yes
Evaluation Count:37
evaluated: count <= 0
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:35
2-41
1109 return false;
executed: return false;
Execution Count:8
8
1110 else if (row + count > rowCount())
evaluated: row + count > rowCount()
TRUEFALSE
yes
Evaluation Count:2
yes
Evaluation Count:33
2-33
1111 return false;
executed: return false;
Execution Count:2
2
1112 else if (!count)
partially evaluated: !count
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:33
0-33
1113 return true;
never executed: return true;
0
1114 -
1115 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:17
yes
Evaluation Count:16
16-17
1116 if (count > 1 || (d->cache.value(row).submitted() && isDirty()))
evaluated: count > 1
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:16
evaluated: d->cache.value(row).submitted()
TRUEFALSE
yes
Evaluation Count:14
yes
Evaluation Count:2
evaluated: isDirty()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:11
1-16
1117 return false;
executed: return false;
Execution Count:4
4
1118 -
1119 // Iterate backwards so we don't have to worry about removed rows causing -
1120 // higher cache entries to shift downwards. -
1121 for (int idx = row + count - 1; idx >= row; --idx) {
evaluated: idx >= row
TRUEFALSE
yes
Evaluation Count:37
yes
Evaluation Count:29
29-37
1122 QSqlTableModelPrivate::ModifiedRow& mrow = d->cache[idx];
executed (the execution status of this line is deduced): QSqlTableModelPrivate::ModifiedRow& mrow = d->cache[idx];
-
1123 if (mrow.op() == QSqlTableModelPrivate::Insert) {
evaluated: mrow.op() == QSqlTableModelPrivate::Insert
TRUEFALSE
yes
Evaluation Count:13
yes
Evaluation Count:24
13-24
1124 revertRow(idx);
executed (the execution status of this line is deduced): revertRow(idx);
-
1125 } else {
executed: }
Execution Count:13
13
1126 if (mrow.op() == QSqlTableModelPrivate::None)
evaluated: mrow.op() == QSqlTableModelPrivate::None
TRUEFALSE
yes
Evaluation Count:22
yes
Evaluation Count:2
2-22
1127 mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Delete,
executed: mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Delete, QSqlQueryModel::record(idx));
Execution Count:22
22
1128 QSqlQueryModel::record(idx));
executed: mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Delete, QSqlQueryModel::record(idx));
Execution Count:22
22
1129 else -
1130 mrow.setOp(QSqlTableModelPrivate::Delete);
executed: mrow.setOp(QSqlTableModelPrivate::Delete);
Execution Count:2
2
1131 if (d->strategy == OnManualSubmit)
evaluated: d->strategy == OnManualSubmit
TRUEFALSE
yes
Evaluation Count:13
yes
Evaluation Count:11
11-13
1132 emit headerDataChanged(Qt::Vertical, idx, idx);
executed: headerDataChanged(Qt::Vertical, idx, idx);
Execution Count:13
13
1133 }
executed: }
Execution Count:24
24
1134 } -
1135 -
1136 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:13
yes
Evaluation Count:16
13-16
1137 return submit();
executed: return submit();
Execution Count:13
13
1138 -
1139 return true;
executed: return true;
Execution Count:16
16
1140} -
1141 -
1142/*! -
1143 Inserts \a count empty rows at position \a row. Note that \a -
1144 parent must be invalid, since this model does not support -
1145 parent-child relations. -
1146 -
1147 For edit strategies OnFieldChange and OnRowChange, only one row -
1148 may be inserted at a time and the model may not contain other -
1149 cached changes. -
1150 -
1151 The primeInsert() signal will be emitted for each new row. -
1152 Connect to it if you want to initialize the new row with default -
1153 values. -
1154 -
1155 Does not submit rows, regardless of edit strategy. -
1156 -
1157 Returns false if the parameters are out of bounds or the row cannot be -
1158 inserted; otherwise returns true. -
1159 -
1160 \sa primeInsert(), insertRecord() -
1161*/ -
1162bool QSqlTableModel::insertRows(int row, int count, const QModelIndex &parent) -
1163{ -
1164 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1165 if (row < 0 || count <= 0 || row > rowCount() || parent.isValid())
partially evaluated: row < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:76
partially evaluated: count <= 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:76
partially evaluated: row > rowCount()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:76
partially evaluated: parent.isValid()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:76
0-76
1166 return false;
never executed: return false;
0
1167 -
1168 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:34
yes
Evaluation Count:42
34-42
1169 if (count != 1 || isDirty())
partially evaluated: count != 1
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:34
evaluated: isDirty()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:31
0-34
1170 return false;
executed: return false;
Execution Count:3
3
1171 -
1172 d->busyInsertingRows = true;
executed (the execution status of this line is deduced): d->busyInsertingRows = true;
-
1173 beginInsertRows(parent, row, row + count - 1);
executed (the execution status of this line is deduced): beginInsertRows(parent, row, row + count - 1);
-
1174 -
1175 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:31
yes
Evaluation Count:42
31-42
1176 d->cache.empty();
executed: d->cache.empty();
Execution Count:31
31
1177 -
1178 if (!d->cache.isEmpty()) {
evaluated: !d->cache.isEmpty()
TRUEFALSE
yes
Evaluation Count:24
yes
Evaluation Count:49
24-49
1179 QMap<int, QSqlTableModelPrivate::ModifiedRow>::Iterator it = d->cache.end();
executed (the execution status of this line is deduced): QMap<int, QSqlTableModelPrivate::ModifiedRow>::Iterator it = d->cache.end();
-
1180 while (it != d->cache.begin() && (--it).key() >= row) {
evaluated: it != d->cache.begin()
TRUEFALSE
yes
Evaluation Count:28
yes
Evaluation Count:7
evaluated: (--it).key() >= row
TRUEFALSE
yes
Evaluation Count:11
yes
Evaluation Count:17
7-28
1181 int oldKey = it.key();
executed (the execution status of this line is deduced): int oldKey = it.key();
-
1182 const QSqlTableModelPrivate::ModifiedRow oldValue = it.value();
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow oldValue = it.value();
-
1183 d->cache.erase(it);
executed (the execution status of this line is deduced): d->cache.erase(it);
-
1184 it = d->cache.insert(oldKey + count, oldValue);
executed (the execution status of this line is deduced): it = d->cache.insert(oldKey + count, oldValue);
-
1185 }
executed: }
Execution Count:11
11
1186 }
executed: }
Execution Count:24
24
1187 -
1188 for (int i = 0; i < count; ++i) {
evaluated: i < count
TRUEFALSE
yes
Evaluation Count:91
yes
Evaluation Count:73
73-91
1189 d->cache[row + i] = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Insert,
executed (the execution status of this line is deduced): d->cache[row + i] = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Insert,
-
1190 d->rec);
executed (the execution status of this line is deduced): d->rec);
-
1191 emit primeInsert(row + i, d->cache[row + i].recRef());
executed (the execution status of this line is deduced): primeInsert(row + i, d->cache[row + i].recRef());
-
1192 }
executed: }
Execution Count:91
91
1193 -
1194 endInsertRows();
executed (the execution status of this line is deduced): endInsertRows();
-
1195 d->busyInsertingRows = false;
executed (the execution status of this line is deduced): d->busyInsertingRows = false;
-
1196 return true;
executed: return true;
Execution Count:73
73
1197} -
1198 -
1199/*! -
1200 Inserts the \a record at position \a row. If \a row is negative, -
1201 the record will be appended to the end. Calls insertRows() and -
1202 setRecord() internally. -
1203 -
1204 Returns true if the record could be inserted, otherwise false. -
1205 -
1206 Changes are submitted immediately for OnFieldChange and -
1207 OnRowChange. Failure does not leave a new row in the model. -
1208 -
1209 \sa insertRows(), removeRows(), setRecord() -
1210*/ -
1211bool QSqlTableModel::insertRecord(int row, const QSqlRecord &record) -
1212{ -
1213 if (row < 0)
evaluated: row < 0
TRUEFALSE
yes
Evaluation Count:7
yes
Evaluation Count:22
7-22
1214 row = rowCount();
executed: row = rowCount();
Execution Count:7
7
1215 if (!insertRow(row, QModelIndex()))
partially evaluated: !insertRow(row, QModelIndex())
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:29
0-29
1216 return false;
never executed: return false;
0
1217 if (!setRecord(row, record)) {
partially evaluated: !setRecord(row, record)
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:29
0-29
1218 revertRow(row);
never executed (the execution status of this line is deduced): revertRow(row);
-
1219 return false;
never executed: return false;
0
1220 } -
1221 return true;
executed: return true;
Execution Count:29
29
1222} -
1223 -
1224/*! \reimp -
1225*/ -
1226int QSqlTableModel::rowCount(const QModelIndex &parent) const -
1227{ -
1228 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1229 -
1230 if (parent.isValid())
evaluated: parent.isValid()
TRUEFALSE
yes
Evaluation Count:1028
yes
Evaluation Count:10705
1028-10705
1231 return 0;
executed: return 0;
Execution Count:1028
1028
1232 -
1233 return QSqlQueryModel::rowCount() + d->insertCount();
executed: return QSqlQueryModel::rowCount() + d->insertCount();
Execution Count:10705
10705
1234} -
1235 -
1236/*! -
1237 Returns the index of the value in the database result set for the -
1238 given \a item in the model. -
1239 -
1240 The return value is identical to \a item if no columns or rows -
1241 have been inserted, removed, or moved around. -
1242 -
1243 Returns an invalid model index if \a item is out of bounds or if -
1244 \a item does not point to a value in the result set. -
1245 -
1246 \sa QSqlQueryModel::indexInQuery() -
1247*/ -
1248QModelIndex QSqlTableModel::indexInQuery(const QModelIndex &item) const -
1249{ -
1250 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1251 if (d->cache.value(item.row()).insert())
partially evaluated: d->cache.value(item.row()).insert()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:2177
0-2177
1252 return QModelIndex();
never executed: return QModelIndex();
0
1253 -
1254 const int rowOffset = d->insertCount(item.row());
executed (the execution status of this line is deduced): const int rowOffset = d->insertCount(item.row());
-
1255 return QSqlQueryModel::indexInQuery(createIndex(item.row() - rowOffset, item.column(), item.internalPointer()));
executed: return QSqlQueryModel::indexInQuery(createIndex(item.row() - rowOffset, item.column(), item.internalPointer()));
Execution Count:2177
2177
1256} -
1257 -
1258/*! -
1259 Returns the currently set filter. -
1260 -
1261 \sa setFilter(), select() -
1262*/ -
1263QString QSqlTableModel::filter() const -
1264{ -
1265 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1266 return d->filter;
executed: return d->filter;
Execution Count:86
86
1267} -
1268 -
1269/*! -
1270 Sets the current filter to \a filter. -
1271 -
1272 The filter is a SQL \c WHERE clause without the keyword \c WHERE -
1273 (for example, \c{name='Josephine')}. -
1274 -
1275 If the model is already populated with data from a database, -
1276 the model re-selects it with the new filter. Otherwise, the filter -
1277 will be applied the next time select() is called. -
1278 -
1279 \sa filter(), select(), selectStatement(), orderByClause() -
1280*/ -
1281void QSqlTableModel::setFilter(const QString &filter) -
1282{ -
1283 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1284 d->filter = filter;
executed (the execution status of this line is deduced): d->filter = filter;
-
1285 if (d->query.isActive())
evaluated: d->query.isActive()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:4
3-4
1286 select();
executed: select();
Execution Count:3
3
1287}
executed: }
Execution Count:7
7
1288 -
1289/*! \reimp -
1290*/ -
1291void QSqlTableModel::clear() -
1292{ -
1293 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1294 d->clear();
executed (the execution status of this line is deduced): d->clear();
-
1295 QSqlQueryModel::clear();
executed (the execution status of this line is deduced): QSqlQueryModel::clear();
-
1296}
executed: }
Execution Count:190
190
1297 -
1298/*! \reimp -
1299*/ -
1300Qt::ItemFlags QSqlTableModel::flags(const QModelIndex &index) const -
1301{ -
1302 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1303 if (index.internalPointer() || index.column() < 0 || index.column() >= d->rec.count()
partially evaluated: index.internalPointer()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:267
evaluated: index.column() < 0
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:266
partially evaluated: index.column() >= d->rec.count()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:266
0-267
1304 || index.row() < 0)
partially evaluated: index.row() < 0
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:266
0-266
1305 return 0;
executed: return 0;
Execution Count:1
1
1306 -
1307 bool editable = true;
executed (the execution status of this line is deduced): bool editable = true;
-
1308 -
1309 if (d->rec.field(index.column()).isReadOnly()) {
partially evaluated: d->rec.field(index.column()).isReadOnly()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:266
0-266
1310 editable = false;
never executed (the execution status of this line is deduced): editable = false;
-
1311 }
never executed: }
0
1312 else { -
1313 const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(index.row());
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(index.row());
-
1314 if (mrow.op() == QSqlTableModelPrivate::Delete) {
partially evaluated: mrow.op() == QSqlTableModelPrivate::Delete
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:266
0-266
1315 editable = false;
never executed (the execution status of this line is deduced): editable = false;
-
1316 }
never executed: }
0
1317 else if (d->strategy == OnFieldChange) {
evaluated: d->strategy == OnFieldChange
TRUEFALSE
yes
Evaluation Count:17
yes
Evaluation Count:249
17-249
1318 if (mrow.op() != QSqlTableModelPrivate::Insert)
evaluated: mrow.op() != QSqlTableModelPrivate::Insert
TRUEFALSE
yes
Evaluation Count:10
yes
Evaluation Count:7
7-10
1319 if (!isDirty(index) && isDirty())
partially evaluated: !isDirty(index)
TRUEFALSE
yes
Evaluation Count:10
no
Evaluation Count:0
evaluated: isDirty()
TRUEFALSE
yes
Evaluation Count:1
yes
Evaluation Count:9
0-10
1320 editable = false;
executed: editable = false;
Execution Count:1
1
1321 }
executed: }
Execution Count:17
17
1322 else if (d->strategy == OnRowChange) {
evaluated: d->strategy == OnRowChange
TRUEFALSE
yes
Evaluation Count:48
yes
Evaluation Count:201
48-201
1323 if (mrow.submitted() && isDirty())
evaluated: mrow.submitted()
TRUEFALSE
yes
Evaluation Count:29
yes
Evaluation Count:19
evaluated: isDirty()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:26
3-29
1324 editable = false;
executed: editable = false;
Execution Count:3
3
1325 }
executed: }
Execution Count:48
48
1326 } -
1327 -
1328 if (!editable)
evaluated: !editable
TRUEFALSE
yes
Evaluation Count:4
yes
Evaluation Count:262
4-262
1329 return QSqlQueryModel::flags(index);
executed: return QSqlQueryModel::flags(index);
Execution Count:4
4
1330 else -
1331 return QSqlQueryModel::flags(index) | Qt::ItemIsEditable;
executed: return QSqlQueryModel::flags(index) | Qt::ItemIsEditable;
Execution Count:262
262
1332} -
1333 -
1334QSqlRecord QSqlTableModel::record() const -
1335{ -
1336 return QSqlQueryModel::record();
executed: return QSqlQueryModel::record();
Execution Count:13
13
1337} -
1338 -
1339/*! -
1340\since 5.0 -
1341 Returns the record at \a row in the model. -
1342 -
1343 If \a row is the index of a valid row, the record -
1344 will be populated with values from that row. -
1345 -
1346 If the model is not initialized, an empty record will be -
1347 returned. -
1348 -
1349 \sa QSqlRecord::isEmpty() -
1350*/ -
1351QSqlRecord QSqlTableModel::record(int row) const -
1352{ -
1353 Q_D(const QSqlTableModel);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate * const d = d_func();
-
1354 -
1355 // the query gets the values from virtual data() -
1356 QSqlRecord rec = QSqlQueryModel::record(row);
executed (the execution status of this line is deduced): QSqlRecord rec = QSqlQueryModel::record(row);
-
1357 -
1358 // get generated flags from the cache -
1359 const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(row);
executed (the execution status of this line is deduced): const QSqlTableModelPrivate::ModifiedRow mrow = d->cache.value(row);
-
1360 if (mrow.op() != QSqlTableModelPrivate::None) {
evaluated: mrow.op() != QSqlTableModelPrivate::None
TRUEFALSE
yes
Evaluation Count:5
yes
Evaluation Count:160
5-160
1361 const QSqlRecord crec = mrow.rec();
executed (the execution status of this line is deduced): const QSqlRecord crec = mrow.rec();
-
1362 for (int i = 0, cnt = rec.count(); i < cnt; ++i)
evaluated: i < cnt
TRUEFALSE
yes
Evaluation Count:15
yes
Evaluation Count:5
5-15
1363 rec.setGenerated(i, crec.isGenerated(i));
executed: rec.setGenerated(i, crec.isGenerated(i));
Execution Count:15
15
1364 }
executed: }
Execution Count:5
5
1365 -
1366 return rec;
executed: return rec;
Execution Count:165
165
1367} -
1368 -
1369/*! -
1370 Applies \a values to the \a row in the model. The source and -
1371 target fields are mapped by field name, not by position in -
1372 the record. -
1373 -
1374 Note that the generated flags in \a values are preserved -
1375 and determine whether the corresponding fields are used when -
1376 changes are submitted to the database. The caller should -
1377 remember to set the generated flag to FALSE for fields -
1378 where the database is meant to supply the value, such as an -
1379 automatically incremented ID. -
1380 -
1381 For edit strategies OnFieldChange and OnRowChange, a row may -
1382 receive a change only if no other row has a cached change. -
1383 Changes are submitted immediately. Submitted changes are not -
1384 reverted upon failure. -
1385 -
1386 Returns true if all the values could be set; otherwise returns -
1387 false. -
1388 -
1389 \sa record(), editStrategy() -
1390*/ -
1391bool QSqlTableModel::setRecord(int row, const QSqlRecord &values) -
1392{ -
1393 Q_D(QSqlTableModel);
executed (the execution status of this line is deduced): QSqlTableModelPrivate * const d = d_func();
-
1394 Q_ASSERT_X(row >= 0, "QSqlTableModel::setRecord()", "Cannot set a record to a row less than 0");
executed (the execution status of this line is deduced): qt_noop();
-
1395 if (d->busyInsertingRows)
partially evaluated: d->busyInsertingRows
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:50
0-50
1396 return false;
never executed: return false;
0
1397 -
1398 if (row >= rowCount())
partially evaluated: row >= rowCount()
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:50
0-50
1399 return false;
never executed: return false;
0
1400 -
1401 if (d->cache.value(row).op() == QSqlTableModelPrivate::Delete)
partially evaluated: d->cache.value(row).op() == QSqlTableModelPrivate::Delete
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:50
0-50
1402 return false;
never executed: return false;
0
1403 -
1404 if (d->strategy != OnManualSubmit && d->cache.value(row).submitted() && isDirty())
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:24
yes
Evaluation Count:26
evaluated: d->cache.value(row).submitted()
TRUEFALSE
yes
Evaluation Count:10
yes
Evaluation Count:14
evaluated: isDirty()
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:7
3-26
1405 return false;
executed: return false;
Execution Count:3
3
1406 -
1407 // Check field names and remember mapping -
1408 typedef QMap<int, int> Map;
executed (the execution status of this line is deduced): typedef QMap<int, int> Map;
-
1409 Map map;
executed (the execution status of this line is deduced): Map map;
-
1410 for (int i = 0; i < values.count(); ++i) {
evaluated: i < values.count()
TRUEFALSE
yes
Evaluation Count:132
yes
Evaluation Count:47
47-132
1411 int idx = d->nameToIndex(values.fieldName(i));
executed (the execution status of this line is deduced): int idx = d->nameToIndex(values.fieldName(i));
-
1412 if (idx == -1)
partially evaluated: idx == -1
TRUEFALSE
no
Evaluation Count:0
yes
Evaluation Count:132
0-132
1413 return false;
never executed: return false;
0
1414 map[i] = idx;
executed (the execution status of this line is deduced): map[i] = idx;
-
1415 }
executed: }
Execution Count:132
132
1416 -
1417 QSqlTableModelPrivate::ModifiedRow &mrow = d->cache[row];
executed (the execution status of this line is deduced): QSqlTableModelPrivate::ModifiedRow &mrow = d->cache[row];
-
1418 if (mrow.op() == QSqlTableModelPrivate::None)
evaluated: mrow.op() == QSqlTableModelPrivate::None
TRUEFALSE
yes
Evaluation Count:13
yes
Evaluation Count:34
13-34
1419 mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update,
executed: mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update, QSqlQueryModel::record(row));
Execution Count:13
13
1420 QSqlQueryModel::record(row));
executed: mrow = QSqlTableModelPrivate::ModifiedRow(QSqlTableModelPrivate::Update, QSqlQueryModel::record(row));
Execution Count:13
13
1421 -
1422 Map::const_iterator i = map.constBegin();
executed (the execution status of this line is deduced): Map::const_iterator i = map.constBegin();
-
1423 const Map::const_iterator e = map.constEnd();
executed (the execution status of this line is deduced): const Map::const_iterator e = map.constEnd();
-
1424 for ( ; i != e; ++i) {
evaluated: i != e
TRUEFALSE
yes
Evaluation Count:132
yes
Evaluation Count:47
47-132
1425 // have to use virtual setData() here rather than mrow.setValue() -
1426 EditStrategy strategy = d->strategy;
executed (the execution status of this line is deduced): EditStrategy strategy = d->strategy;
-
1427 d->strategy = OnManualSubmit;
executed (the execution status of this line is deduced): d->strategy = OnManualSubmit;
-
1428 QModelIndex cIndex = createIndex(row, i.value());
executed (the execution status of this line is deduced): QModelIndex cIndex = createIndex(row, i.value());
-
1429 setData(cIndex, values.value(i.key()));
executed (the execution status of this line is deduced): setData(cIndex, values.value(i.key()));
-
1430 d->strategy = strategy;
executed (the execution status of this line is deduced): d->strategy = strategy;
-
1431 // setData() sets generated to TRUE, but source record should prevail. -
1432 if (!values.isGenerated(i.key()))
evaluated: !values.isGenerated(i.key())
TRUEFALSE
yes
Evaluation Count:3
yes
Evaluation Count:129
3-129
1433 mrow.recRef().setGenerated(i.value(), false);
executed: mrow.recRef().setGenerated(i.value(), false);
Execution Count:3
3
1434 }
executed: }
Execution Count:132
132
1435 -
1436 if (d->strategy != OnManualSubmit)
evaluated: d->strategy != OnManualSubmit
TRUEFALSE
yes
Evaluation Count:21
yes
Evaluation Count:26
21-26
1437 return submit();
executed: return submit();
Execution Count:21
21
1438 -
1439 return true;
executed: return true;
Execution Count:26
26
1440} -
1441 -
1442QT_END_NAMESPACE -
1443 -
Source codeSwitch to Preprocessed file
Generated by Squish Coco Non-Commercial