diff options
| author | Christian Ehrlicher <ch.ehrlicher@gmx.de> | 2024-12-17 19:54:55 +0100 |
|---|---|---|
| committer | Christian Ehrlicher <ch.ehrlicher@gmx.de> | 2024-12-20 03:46:13 +0100 |
| commit | 1bd883dbc15c4016f78d421afac2ac9f31ec4874 (patch) | |
| tree | 80fcf18817977f368eb53b0329a6e3df0ea6d14c /tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp | |
| parent | 5b07e3de3fe5335d9338c65ca40cfe656a389167 (diff) | |
QSqlQueryModel: add new function to refresh the model data
This function re-executes the query used by QSqlQueryModel and refreshes
the data from the database. The query must not use bound values as these
values are not preserved.
[ChangeLog][QtSql][QSqlQueryModel] Added refresh() to refresh the model
data from the database.
Pick-to: 6.9
Task-number: QTBUG-123603
Change-Id: I3f1d779e07b88565abe825c31cfc4d7d1b2312c4
Reviewed-by: Volker Hilsheimer <volker.hilsheimer@qt.io>
Diffstat (limited to 'tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp')
| -rw-r--r-- | tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp b/tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp index 81aed273e18..2b68b1397bf 100644 --- a/tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp +++ b/tests/auto/sql/models/qsqlquerymodel/tst_qsqlquerymodel.cpp @@ -59,10 +59,10 @@ private slots: void task_180617(); void task_180617_data() { generic_data(); } void task_QTBUG_4963_setHeaderDataWithProxyModel(); - void refreshQuery_data() { generic_data(); } - void refreshQuery(); - void refreshQueryWithBoundValues_data() { generic_data(); } - void refreshQueryWithBoundValues(); + void refresh_data() { generic_data(); } + void refresh(); + void refreshWithBoundValues_data() { generic_data(); } + void refreshWithBoundValues(); private: void generic_data(const QString &engine = QString()); void dropTestTables(const QSqlDatabase &db); @@ -663,7 +663,7 @@ void tst_QSqlQueryModel::task_QTBUG_4963_setHeaderDataWithProxyModel() // And it should not crash. } -void tst_QSqlQueryModel::refreshQuery() +void tst_QSqlQueryModel::refresh() { QFETCH(QString, dbName); QSqlDatabase db = QSqlDatabase::database(dbName); @@ -677,7 +677,7 @@ void tst_QSqlQueryModel::refreshQuery() QSqlQuery(db).exec("UPDATE " + qTableName("test", __FILE__, QSqlDatabase::database(dbName)) + " SET name = 'updated_harry' WHERE id = 1"); - model.refreshQuery(db); + model.refresh(); QCOMPARE(model.rowCount(), 2); QCOMPARE(model.data(model.index(0, 0)).toInt(), 1); QCOMPARE(model.data(model.index(0, 1)).toString(), QString("updated_harry")); @@ -688,7 +688,7 @@ void tst_QSqlQueryModel::refreshQuery() + " SET name = 'harry' WHERE id = 1"); } -void tst_QSqlQueryModel::refreshQueryWithBoundValues() +void tst_QSqlQueryModel::refreshWithBoundValues() { QFETCH(QString, dbName); QSqlDatabase db = QSqlDatabase::database(dbName); @@ -707,7 +707,7 @@ void tst_QSqlQueryModel::refreshQueryWithBoundValues() QSqlQuery(db).exec("UPDATE " + qTableName("test", __FILE__, QSqlDatabase::database(dbName)) + " SET name = 'updated_harry' WHERE id = 1"); - model.refreshQuery(db); + model.refresh(); QCOMPARE(model.rowCount(), 0); QCOMPARE_NE(model.data(model.index(0, 0)).toString(), QString("updated_harry")); QCOMPARE(model.data(model.index(0, 0)).toString(), QString("")); |