diff options
author | Edward Welbourne <edward.welbourne@qt.io> | 2017-08-03 12:12:26 +0200 |
---|---|---|
committer | Simon Hausmann <simon.hausmann@qt.io> | 2017-08-04 11:19:39 +0000 |
commit | fbe84a1a19f93bc99bcb9e9333642466cb984cad (patch) | |
tree | d22cb729118eb22ea1c0dc2c0f5830b84eea4774 /tests/auto/sql | |
parent | a9c111ed8c30a5a8fec3f02244f0d5a4bd08e931 (diff) |
Add a test that we can read SQL time-stamps
Based on a test-case from Israel Lins Albuquerque, that my planned
fixes to our parsing of ISODate date-times would break.
Change-Id: I5658df9c7daed59d43aa5574df25d4d9eac4677d
Reviewed-by: Israel Lins Albuquerque <israelins85@yahoo.com.br>
Reviewed-by: Thiago Macieira <thiago.macieira@intel.com>
Diffstat (limited to 'tests/auto/sql')
-rw-r--r-- | tests/auto/sql/kernel/qsqlquery/tst_qsqlquery.cpp | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/tests/auto/sql/kernel/qsqlquery/tst_qsqlquery.cpp b/tests/auto/sql/kernel/qsqlquery/tst_qsqlquery.cpp index 35f86772e2..92e4b580e7 100644 --- a/tests/auto/sql/kernel/qsqlquery/tst_qsqlquery.cpp +++ b/tests/auto/sql/kernel/qsqlquery/tst_qsqlquery.cpp @@ -170,6 +170,8 @@ private slots: void blobsPreparedQuery(); void emptyTableNavigate_data() { generic_data(); } void emptyTableNavigate(); + void timeStampParsing_data() { generic_data(); } + void timeStampParsing(); #ifdef NOT_READY_YET void task_229811(); @@ -2887,6 +2889,25 @@ void tst_QSqlQuery::emptyTableNavigate() } } +void tst_QSqlQuery::timeStampParsing() +{ + QFETCH(QString, dbName); + QSqlDatabase db = QSqlDatabase::database(dbName); + CHECK_DATABASE(db); + QSqlQuery q(db); + QVERIFY_SQL(q, exec( + "CREATE TABLE \"main\".\"datetest\" (" + "\"id\" integer NOT NULL PRIMARY KEY AUTOINCREMENT," + "\"datefield\" timestamp);" + )); + QVERIFY_SQL(q, exec( + "INSERT INTO datetest (datefield) VALUES (current_timestamp);" + )); + QVERIFY_SQL(q, exec("SELECT * FROM datetest;")); + while (q.next()) + QVERIFY(q.value(1).toDateTime().isValid()); +} + void tst_QSqlQuery::task_217003() { QFETCH( QString, dbName ); |