summaryrefslogtreecommitdiffstats
path: root/tests/auto/qsql/tst_qsql.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'tests/auto/qsql/tst_qsql.cpp')
-rw-r--r--tests/auto/qsql/tst_qsql.cpp277
1 files changed, 0 insertions, 277 deletions
diff --git a/tests/auto/qsql/tst_qsql.cpp b/tests/auto/qsql/tst_qsql.cpp
deleted file mode 100644
index e8c6d14f5b..0000000000
--- a/tests/auto/qsql/tst_qsql.cpp
+++ /dev/null
@@ -1,277 +0,0 @@
-/****************************************************************************
-**
-** Copyright (C) 2011 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$
-** GNU Lesser General Public License Usage
-** 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.
-**
-** 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.
-**
-** Other Usage
-** Alternatively, this file may be used in accordance with the terms and
-** conditions contained in a signed written agreement between you and Nokia.
-**
-**
-**
-**
-**
-** $QT_END_LICENSE$
-**
-****************************************************************************/
-
-
-#include <QtTest/QtTest>
-#include <qapplication.h>
-#include <qsqldatabase.h>
-#include <qsqlerror.h>
-#include <qsqlquery.h>
-#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("Testing: %s", qPrintable(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" ) );
- }
-
- 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("Promiscuous database server without access control - test skipped for %s",
- qPrintable(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"
generated by cgit v1.2.3 (git 2.25.1) at 2024-05-06 17:43:04 +0000