Long live Qt 4.5!

3 files changed, 332 insertions, 0 deletions

diff --git a/tests/auto/qsql/.gitignore b/tests/auto/qsql/.gitignore
new file mode 100644
index 0000000..b1e335b
--- /dev/null
+++ b/tests/auto/qsql/.gitignore
@@ -0,0 +1 @@
+tst_qsql
diff --git a/tests/auto/qsql/qsql.pro b/tests/auto/qsql/qsql.pro
new file mode 100644
index 0000000..2c0e337
--- /dev/null
+++ b/tests/auto/qsql/qsql.pro
@@ -0,0 +1,10 @@
+load(qttest_p4)
+SOURCES  += tst_qsql.cpp
+
+QT += sql 
+
+contains(QT_CONFIG, qt3support): QT += qt3support
+
+wince*: {
+   DEPLOYMENT_PLUGIN += qsqlite
+}
diff --git a/tests/auto/qsql/tst_qsql.cpp b/tests/auto/qsql/tst_qsql.cpp
new file mode 100644
index 0000000..d664680
--- /dev/null
+++ b/tests/auto/qsql/tst_qsql.cpp
@@ -0,0 +1,321 @@
+/****************************************************************************
+**
+** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies).
+** Contact: Qt Software Information (qt-info@nokia.com)
+**
+** This file is part of the test suite of the Qt Toolkit.
+**
+** $QT_BEGIN_LICENSE:LGPL$
+** No Commercial Usage
+** This file contains pre-release code and may not be distributed.
+** You may use this file in accordance with the terms and conditions
+** contained in the either Technology Preview License Agreement or the
+** Beta Release License Agreement.
+**
+** GNU Lesser General Public License Usage
+** Alternatively, this file may be used under the terms of the GNU Lesser
+** General Public License version 2.1 as published by the Free Software
+** Foundation and appearing in the file LICENSE.LGPL included in the
+** packaging of this file.  Please review the following information to
+** ensure the GNU Lesser General Public License version 2.1 requirements
+** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
+**
+** In addition, as a special exception, Nokia gives you certain
+** additional rights. These rights are described in the Nokia Qt LGPL
+** Exception version 1.0, included in the file LGPL_EXCEPTION.txt in this
+** package.
+**
+** GNU General Public License Usage
+** Alternatively, this file may be used under the terms of the GNU
+** General Public License version 3.0 as published by the Free Software
+** Foundation and appearing in the file LICENSE.GPL included in the
+** packaging of this file.  Please review the following information to
+** ensure the GNU General Public License version 3.0 requirements will be
+** met: http://www.gnu.org/copyleft/gpl.html.
+**
+** If you are unsure which license is appropriate for your use, please
+** contact the sales department at qt-sales@nokia.com.
+** $QT_END_LICENSE$
+**
+****************************************************************************/
+
+
+#include <QtTest/QtTest>
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlerror.h>
+#include <qsqlquery.h>
+#ifdef QT3_SUPPORT
+#include <q3sqlcursor.h>
+#endif
+#include <qsqlrecord.h>
+#include <qsql.h>
+#include <qsqlresult.h>
+#include <qsqldriver.h>
+#include <qdebug.h>
+#include <private/qsqlnulldriver_p.h>
+
+#include "../qsqldatabase/tst_databases.h"
+
+//TESTED_FILES=
+
+class tst_QSql : public QObject
+{
+Q_OBJECT
+
+public:
+    tst_QSql();
+    virtual ~tst_QSql();
+
+
+public slots:
+    void initTestCase();
+    void cleanupTestCase();
+    void init();
+    void cleanup();
+private slots:
+    void open();
+    void openInvalid();
+    void registerSqlDriver();
+
+    // problem specific tests
+    void openErrorRecovery();
+    void concurrentAccess();
+    void basicDriverTest();
+};
+
+/****************** General Qt SQL Module tests *****************/
+
+tst_QSql::tst_QSql()
+{
+}
+
+tst_QSql::~tst_QSql()
+{
+}
+
+void tst_QSql::initTestCase()
+{
+}
+
+void tst_QSql::cleanupTestCase()
+{
+}
+
+void tst_QSql::init()
+{
+}
+
+void tst_QSql::cleanup()
+{
+}
+
+
+// this is a very basic test for drivers that cannot create/delete tables
+// it can be used while developing new drivers,
+// it's original purpose is to test ODBC Text datasources that are basically
+// to stupid to do anything more advanced than SELECT/INSERT/UPDATE/DELETE
+// the datasource has to have a table called "qtest_basictest" consisting
+// of a field "id"(integer) and "name"(char/varchar).
+void tst_QSql::basicDriverTest()
+{
+    int argc = 0;
+    QApplication app( argc, 0, false );
+    tst_Databases dbs;
+    dbs.open();
+
+    foreach( const QString& dbName, dbs.dbNames )
+    {
+        QSqlDatabase db = QSqlDatabase::database( dbName );
+        QVERIFY_SQL( db, isValid() );
+
+        QStringList tables = db.tables();
+        QString tableName;
+
+        if ( tables.contains( "qtest_basictest.txt" ) )
+            tableName = "qtest_basictest.txt";
+        else if ( tables.contains( "qtest_basictest" ) )
+            tableName = "qtest_basictest";
+        else if ( tables.contains( "QTEST_BASICTEST" ) )
+            tableName = "QTEST_BASICTEST";
+        else {
+            QVERIFY( 1 );
+            continue;
+        }
+
+        qDebug( qPrintable( QLatin1String( "Testing: " ) + tst_Databases::dbToString( db ) ) );
+
+        QSqlRecord rInf = db.record( tableName );
+        QCOMPARE( rInf.count(), 2 );
+        QCOMPARE( rInf.fieldName( 0 ).toLower(), QString( "id" ) );
+        QCOMPARE( rInf.fieldName( 1 ).toLower(), QString( "name" ) );
+
+#ifdef QT3_SUPPORT
+        QSqlRecord* rec = 0;
+        Q3SqlCursor cur( tableName, true, db );
+        QVERIFY_SQL( cur, select() );
+        QCOMPARE( cur.count(), 2 );
+        QCOMPARE( cur.fieldName( 0 ).lower(), QString( "id" ) );
+        QCOMPARE( cur.fieldName( 1 ).lower(), QString( "name" ) );
+
+        rec = cur.primeDelete();
+        rec->setGenerated( 0, false );
+        rec->setGenerated( 1, false );
+        QVERIFY_SQL( cur, del() );
+        QVERIFY_SQL( cur, select() );
+        QCOMPARE( cur.at(), int( QSql::BeforeFirst ) );
+        QVERIFY( !cur.next() );
+        rec = cur.primeInsert();
+        rec->setValue( 0, 1 );
+        rec->setValue( 1, QString( "Harry" ) );
+        QVERIFY_SQL( cur, insert( false ) );
+        rec = cur.primeInsert();
+        rec->setValue( 0, 2 );
+        rec->setValue( 1, QString( "Trond" ) );
+        QVERIFY_SQL( cur, insert( true ) );
+        QVERIFY_SQL( cur, select( cur.index( QString( "id" ) ) ) );
+        QVERIFY_SQL( cur, next() );
+        QCOMPARE( cur.value( 0 ).toInt(), 1 );
+        QCOMPARE( cur.value( 1 ).toString().stripWhiteSpace(), QString( "Harry" ) );
+        QVERIFY_SQL( cur, next() );
+        QCOMPARE( cur.value( 0 ).toInt(), 2 );
+        QCOMPARE( cur.value( 1 ).toString().stripWhiteSpace(), QString( "Trond" ) );
+        QVERIFY( !cur.next() );
+        QVERIFY_SQL( cur, first() );
+        rec = cur.primeUpdate();
+        rec->setValue( 1, QString( "Vohi" ) );
+        QVERIFY_SQL( cur, update( true ) );
+        QVERIFY_SQL( cur, select( "id = 1" ) );
+        QVERIFY_SQL( cur, next() );
+        QCOMPARE( cur.value( 0 ).toInt(), 1 );
+        QCOMPARE( cur.value( 1 ).toString().stripWhiteSpace(), QString( "Vohi" ) );
+#endif
+    }
+
+    dbs.close();
+    QVERIFY( 1 ); // make sure the test doesn't fail if no database drivers are there
+}
+
+// make sure that the static stuff will be deleted
+// when using multiple QApplication objects
+void tst_QSql::open()
+{
+    int i;
+    int argc = 0;
+    int count = -1;
+    for ( i = 0; i < 10; ++i ) {
+
+	QApplication app( argc, 0, false );
+	tst_Databases dbs;
+
+	dbs.open();
+	if ( count == -1 )
+	    // first iteration: see how many dbs are open
+	    count = (int) dbs.dbNames.count();
+	else
+	    // next iterations: make sure all are opened again
+	    QCOMPARE( count, (int)dbs.dbNames.count() );
+	dbs.close();
+    }
+}
+
+void tst_QSql::openInvalid()
+{
+    QSqlDatabase db;
+    QVERIFY(!db.open());
+
+    QSqlDatabase db2 = QSqlDatabase::addDatabase("doesnt_exist_will_never_exist", "blah");
+    QFAIL_SQL(db2, open());
+}
+
+void tst_QSql::concurrentAccess()
+{
+    int argc = 0;
+    QApplication app( argc, 0, false );
+    tst_Databases dbs;
+
+    dbs.open();
+    foreach ( const QString& dbName, dbs.dbNames ) {
+	QSqlDatabase db = QSqlDatabase::database( dbName );
+	QVERIFY( db.isValid() );
+        if (tst_Databases::isMSAccess(db))
+            continue;
+
+	QSqlDatabase ndb = QSqlDatabase::addDatabase( db.driverName(), "tst_QSql::concurrentAccess" );
+	ndb.setDatabaseName( db.databaseName() );
+	ndb.setHostName( db.hostName() );
+	ndb.setPort( db.port() );
+	ndb.setUserName( db.userName() );
+	ndb.setPassword( db.password() );
+	QVERIFY_SQL( ndb, open() );
+
+	QCOMPARE( db.tables(), ndb.tables() );
+    }
+    // no database servers installed - don't fail
+    QVERIFY(1);
+    dbs.close();
+}
+
+void tst_QSql::openErrorRecovery()
+{
+    int argc = 0;
+    QApplication app( argc, 0, false );
+    tst_Databases dbs;
+
+    dbs.addDbs();
+    if (dbs.dbNames.isEmpty())
+        QSKIP("No database drivers installed", SkipAll);
+    foreach ( const QString& dbName, dbs.dbNames ) {
+	QSqlDatabase db = QSqlDatabase::database( dbName, false );
+	CHECK_DATABASE( db );
+
+	QString userName = db.userName();
+	QString password = db.password();
+
+	// force an open error
+	if ( db.open( "dummy130977", "doesnt_exist" ) ) {
+	    qDebug( qPrintable(QLatin1String("Promiscuous database server without access control - test skipped for ") +
+		    tst_Databases::dbToString( db )) );
+	    QVERIFY(1);
+	    continue;
+	}
+
+	QFAIL_SQL( db, isOpen() );
+	QVERIFY_SQL( db, isOpenError() );
+
+	// now open it
+	if ( !db.open( userName, password ) ) {
+	    qDebug() << "Could not open Database " << tst_Databases::dbToString( db ) <<
+		    ". Assuming DB is down, skipping... (Error: " << 
+		    tst_Databases::printError( db.lastError() ) << ")";
+	    continue;
+	}
+	QVERIFY_SQL( db, open( userName, password ) );
+	QVERIFY_SQL( db, isOpen() );
+	QFAIL_SQL( db, isOpenError() );
+	db.close();
+	QFAIL_SQL( db, isOpen() );
+
+	// force another open error
+	QFAIL_SQL( db, open( "dummy130977", "doesnt_exist" ) );
+	QFAIL_SQL( db, isOpen() );
+	QVERIFY_SQL( db, isOpenError() );
+    }
+}
+
+void tst_QSql::registerSqlDriver()
+{
+    int argc = 0;
+    QApplication app( argc, 0, false );
+
+    QSqlDatabase::registerSqlDriver( "QSQLTESTDRIVER", new QSqlDriverCreator<QSqlNullDriver> );
+    QVERIFY( QSqlDatabase::drivers().contains( "QSQLTESTDRIVER" ) );
+
+    QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLTESTDRIVER" );
+    QVERIFY( db.isValid() );
+
+    QCOMPARE( db.tables(), QStringList() );
+}
+
+QTEST_APPLESS_MAIN(tst_QSql)
+#include "tst_qsql.moc"