--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/tests/auto/qsql/tst_qsql.cpp Mon Jan 11 14:00:40 2010 +0000
@@ -0,0 +1,321 @@
+/****************************************************************************
+**
+** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies).
+** All rights reserved.
+** Contact: Nokia Corporation (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 Technology Preview License Agreement accompanying
+** this package.
+**
+** 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.1, included in the file LGPL_EXCEPTION.txt in this package.
+**
+** If you have questions regarding the use of this file, please contact
+** Nokia at qt-info@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"