From 5af57389807d0b51509d55e1f87042cab393da6e Mon Sep 17 00:00:00 2001
From: Andreas Bacher <andreas.bacher@meon-medical.com>
Date: Tue, 14 Mar 2023 11:25:20 +0100
Subject: SQL/IBASE: Time Zone support (firebird 4.x)

Add support for time zones in the IBASE driver, which was introduced in
firebird 4.x. TIMESTAMP WITH TIME ZONE data type is supported in order
to store and retrieve a QDateTime with the time zone.

Task-number: QTBUG-111879
Change-Id: I631b4262d17796a17630379b7d659f88244a23ad
Reviewed-by: Christian Ehrlicher <ch.ehrlicher@gmx.de>
---
 tests/auto/sql/kernel/qsqldatabase/tst_databases.h | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'tests/auto/sql/kernel/qsqldatabase/tst_databases.h')

diff --git a/tests/auto/sql/kernel/qsqldatabase/tst_databases.h b/tests/auto/sql/kernel/qsqldatabase/tst_databases.h
index c715c1c2a82..c62f6a97ff4 100644
--- a/tests/auto/sql/kernel/qsqldatabase/tst_databases.h
+++ b/tests/auto/sql/kernel/qsqldatabase/tst_databases.h
@@ -9,6 +9,7 @@
 #include <QSqlDriver>
 #include <QSqlError>
 #include <QSqlQuery>
+#include <QSqlRecord>
 #include <QRegularExpression>
 #include <QRegularExpressionMatch>
 #include <QDir>
@@ -20,9 +21,12 @@
 #include <QJsonObject>
 #include <QJsonDocument>
 #include <QSysInfo>
+#include <QVersionNumber>
 #include <QtSql/private/qsqldriver_p.h>
 #include <QTest>
 
+using namespace Qt::StringLiterals;
+
 #define CHECK_DATABASE( db ) \
     if ( !db.isValid() ) { qFatal( "db is Invalid" ); }
 
@@ -434,6 +438,15 @@ public:
         return ver;
     }
 
+    static QVersionNumber getIbaseEngineVersion(const QSqlDatabase &db)
+    {
+        auto q = db.exec("SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version from rdb$database;"_L1);
+        q.next();
+        auto record = q.record();
+        auto version = QVersionNumber::fromString(record.value(0).toString());
+        return version;
+    }
+
     QStringList     dbNames;
     int      counter = 0;
 
-- 
cgit v1.2.3