FCL/sf/mw/qt: comparison tests/auto/q3sqlcursor/tst

equal deleted inserted replaced

-:41300fa6a67c
+:f7bc934e204c
 /****************************************************************************
 **
-** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies).
+** Copyright (C) 2010 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.
 **
 #include <QtTest/QtTest>
 #include <q3sqlcursor.h>
 #include <qsqlfield.h>
 #include <qsqldriver.h>
+#include <QSet>
 #include "../qsqldatabase/tst_databases.h"
+const QString qtest(qTableName( "qtest", __FILE__ ));
 //TESTED_FILES=
 QT_FORWARD_DECLARE_CLASS(QSqlDatabase)
 void tst_Q3SqlCursor::generic_data(const QString &engine)
 {
 if ( dbs.fillTestTable(engine) == 0 ) {
 if(engine.isEmpty())
-	   QSKIP( "No database drivers are available in this Qt configuration", SkipAll );
+QSKIP( "No database drivers are available in this Qt configuration", SkipAll );
 else
 QSKIP( (QString("No database drivers of type %1 are available in this Qt configuration").arg(engine)).toLocal8Bit(), SkipAll );
 }
 }
 void tst_Q3SqlCursor::createTestTables( QSqlDatabase db )
 {
 if ( !db.isValid() )
-	return;
+return;
 QSqlQuery q( db );
 if (tst_Databases::isSqlServer(db)) {
 QVERIFY_SQL(q, exec("SET ANSI_DEFAULTS ON"));
 QVERIFY_SQL(q, exec("SET IMPLICIT_TRANSACTIONS OFF"));
 else if(tst_Databases::isPostgreSQL(db))
 QVERIFY_SQL( q, exec("set client_min_messages='warning'"));
 // please never ever change this table; otherwise fix all tests ;)
 if ( tst_Databases::isMSAccess( db ) ) {
-	QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest" ) + " ( id int not null, t_varchar varchar(40) not null,"
+QVERIFY_SQL(q, exec( "create table " + qtest + " ( id int not null, t_varchar varchar(40) not null,"
-			 "t_char char(40), t_numeric number, primary key (id, t_varchar) )" ));
+"t_char char(40), t_numeric number, primary key (id, t_varchar) )" ));
 } else {
-	QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest" ) + " ( id int not null, t_varchar varchar(40) not null,"
+QVERIFY_SQL(q, exec( "create table " + qtest + " ( id int not null, t_varchar varchar(40) not null,"
-			 "t_char char(40), t_numeric numeric(6, 3), primary key (id, t_varchar) )" ));
+"t_char char(40), t_numeric numeric(6, 3), primary key (id, t_varchar) )" ));
 }
 if ( tst_Databases::isSqlServer( db ) ) {
-	//workaround for SQL SERVER since he can store unicode only in nvarchar fields
+//workaround for SQL SERVER since he can store unicode only in nvarchar fields
-	QVERIFY_SQL(q, exec("create table " + qTableName("qtest_unicode") + " (id int not null, "
+QVERIFY_SQL(q, exec("create table " + qTableName("qtest_unicode", __FILE__) + " (id int not null, "
-		       "t_varchar nvarchar(80) not null, t_char nchar(80) )" ));
+"t_varchar nvarchar(80) not null, t_char nchar(80) )" ));
 } else {
-	QVERIFY_SQL(q, exec("create table " + qTableName("qtest_unicode") + " (id int not null, "
+QVERIFY_SQL(q, exec("create table " + qTableName("qtest_unicode", __FILE__) + " (id int not null, "
-		       "t_varchar varchar(100) not null," "t_char char(100))" ));
+"t_varchar varchar(100) not null," "t_char char(100))" ));
 }
 if (tst_Databases::isMSAccess(db)) {
-QVERIFY_SQL(q, exec("create table " + qTableName("qtest_precision") + " (col1 number)"));
+QVERIFY_SQL(q, exec("create table " + qTableName("qtest_precision", __FILE__) + " (col1 number)"));
 } else {
-QVERIFY_SQL(q, exec("create table " + qTableName("qtest_precision") + " (col1 numeric(15, 14))"));
+QVERIFY_SQL(q, exec("create table " + qTableName("qtest_precision", __FILE__) + " (col1 numeric(15, 14))"));
 }
 }
 void tst_Q3SqlCursor::dropTestTables( QSqlDatabase db )
 {
 if ( !db.isValid() )
-	return;
+return;
 QStringList tableNames;
-tableNames << qTableName( "qtest" )
+tableNames << qtest
-<< qTableName( "qtest_unicode" )
+<< qTableName( "qtest_unicode", __FILE__ )
-<< qTableName( "qtest_precision" )
+<< qTableName( "qtest_precision", __FILE__ )
-<< qTableName( "qtest_ovchar" )
+<< qTableName( "qtest_ovchar", __FILE__ )
-<< qTableName( "qtest_onvchar" )
+<< qTableName( "qtest_onvchar", __FILE__ )
-<< qTableName( "qtestPK" );
+<< qTableName( "qtestPK", __FILE__ );
 tst_Databases::safeDropTables( db, tableNames );
 }
 void tst_Q3SqlCursor::populateTestTables( QSqlDatabase db )
 {
 if (!db.isValid())
-	return;
+return;
 QSqlQuery q( db );
-q.exec( "delete from " + qTableName( "qtest" ) ); //not fatal
+q.exec( "delete from " + qtest ); //not fatal
-QVERIFY_SQL(q, prepare("insert into " + qTableName( "qtest" ) + " (id, t_varchar, t_char, t_numeric) values (?, ?, ?, ?)"));
+QVERIFY_SQL(q, prepare("insert into " + qtest + " (id, t_varchar, t_char, t_numeric) values (?, ?, ?, ?)"));
 q.addBindValue(QVariantList() << 0 << 1 << 2 << 3);
 q.addBindValue(QVariantList() << "VarChar0" << "VarChar1" << "VarChar2" << "VarChar3");
 q.addBindValue(QVariantList() << "Char0" << "Char1" << "Char2" << "Char3");
 q.addBindValue(QVariantList() << 1.1 << 2.2 << 3.3 << 4.4);
 QVERIFY_SQL(q, execBatch());
 void tst_Q3SqlCursor::initTestCase()
 {
 dbs.open();
 for ( QStringList::ConstIterator it = dbs.dbNames.begin(); it != dbs.dbNames.end(); ++it ) {
-	QSqlDatabase db = QSqlDatabase::database( (*it) );
+QSqlDatabase db = QSqlDatabase::database( (*it) );
-	CHECK_DATABASE( db );
+CHECK_DATABASE( db );
-	dropTestTables( db ); //in case of leftovers
+dropTestTables( db ); //in case of leftovers
-	createTestTables( db );
+createTestTables( db );
-	populateTestTables( db );
+populateTestTables( db );
 }
 }
 void tst_Q3SqlCursor::cleanupTestCase()
 {
 for ( QStringList::ConstIterator it = dbs.dbNames.begin(); it != dbs.dbNames.end(); ++it ) {
-	QSqlDatabase db = QSqlDatabase::database( (*it) );
+QSqlDatabase db = QSqlDatabase::database( (*it) );
-	CHECK_DATABASE( db );
+CHECK_DATABASE( db );
-	dropTestTables( db );
+dropTestTables( db );
 }
 dbs.close();
 }
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
 if ( QTest::currentTestFailed() ) {
-	//since Oracle ODBC totally craps out on error, we init again
+//since Oracle ODBC totally craps out on error, we init again
-	db.close();
+db.close();
-	db.open();
+db.open();
 }
 }
 void tst_Q3SqlCursor::copyConstructor()
 {
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
 Q3SqlCursor cur2;
 {
-	Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
-	QVERIFY_SQL(cur, select( cur.index( QString("id") ) ));
+QVERIFY_SQL(cur, select( cur.index( QString("id") ) ));
-	cur2 = Q3SqlCursor( cur );
+cur2 = Q3SqlCursor( cur );
-	// let "cur" run out of scope...
+// let "cur" run out of scope...
 }
 QSqlRecord* rec = cur2.primeUpdate();
 Q_ASSERT( rec );
 QCOMPARE( (int)rec->count(), 4 );
 int i = 0;
 while ( cur2.next() ) {
-	QVERIFY( cur2.value("id").toInt() == i );
+QVERIFY( cur2.value("id").toInt() == i );
-	i++;
+i++;
 }
 }
 void tst_Q3SqlCursor::value()
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 QVERIFY_SQL(cur, select( cur.index( QString("id") ) ));
 int i = 0;
 while ( cur.next() ) {
-	QCOMPARE(cur.value("id").toInt(), i);
+QCOMPARE(cur.value("id").toInt(), i);
-	i++;
+i++;
 }
 }
 void tst_Q3SqlCursor::primaryIndex()
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 QSqlIndex index = cur.primaryIndex();
 if ( tst_Databases::isMSAccess( db ) ) {
-	QCOMPARE( index.fieldName(1).upper(), QString( "ID" ) );
+QCOMPARE( index.fieldName(1).upper(), QString( "ID" ) );
-	QCOMPARE( index.fieldName(0).upper(), QString( "T_VARCHAR" ) );
+QCOMPARE( index.fieldName(0).upper(), QString( "T_VARCHAR" ) );
 } else {
-	QCOMPARE( index.fieldName(0).upper(), QString( "ID" ) );
+QCOMPARE( index.fieldName(0).upper(), QString( "ID" ) );
-	QCOMPARE( index.fieldName(1).upper(), QString( "T_VARCHAR" ) );
+QCOMPARE( index.fieldName(1).upper(), QString( "T_VARCHAR" ) );
 }
 QVERIFY(!index.isDescending(0));
 QVERIFY(!index.isDescending(1));
 }
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 QSqlRecord* irec = cur.primeInsert();
 QVERIFY( irec != 0 );
 // check that primeInsert returns a valid QSqlRecord
 QCOMPARE( (int)irec->count(), 4 );
 if ( ( irec->field( 0 ).type() != QVariant::Int ) &&
-	 ( irec->field( 0 ).type() != QVariant::String ) &&
+( irec->field( 0 ).type() != QVariant::String ) &&
 ( irec->field( 0 ).type() != QVariant::Double ) ) {
-	QFAIL( QString( "Wrong datatype %1 for field 'ID'"
+QFAIL( QString( "Wrong datatype %1 for field 'ID'"
-	    " (expected Int or String)" ).arg( QVariant::typeToName( irec->field( 0 ).type() ) ) );
+" (expected Int or String)" ).arg( QVariant::typeToName( irec->field( 0 ).type() ) ) );
 }
 QCOMPARE( QVariant::typeToName( irec->field( 1 ).type() ), QVariant::typeToName( QVariant::String ) );
 QCOMPARE( QVariant::typeToName( irec->field( 2 ).type() ), QVariant::typeToName( QVariant::String ) );
 QVERIFY((QVariant::typeToName(irec->field(3).type()) == QVariant::typeToName(QVariant::Double)) ||
 (QVariant::typeToName(irec->field(3).type()) == QVariant::typeToName(QVariant::String)));
 irec->setValue( "id", 400 );
 irec->setValue( "t_varchar", "SomeVarChar" );
 irec->setValue( "t_char", "SomeChar" );
 irec->setValue( "t_numeric", 400.400 );
-QCOMPARE( cur.insert(), 1 );
+QSet<int> validReturns(QSet<int>() << -1 << 1);
+QVERIFY( validReturns.contains(cur.insert()) );
 // restore old test-tables
 populateTestTables( db );
 }
 void tst_Q3SqlCursor::insertSpecial()
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
+QSet<int> validReturns(QSet<int>() << -1 << 1);
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 QSqlRecord* irec = cur.primeInsert();
 QVERIFY( irec != 0 );
 QStringList strings;
 strings << "StringWith'ATick" << "StringWith\"Doublequote" << "StringWith\\Backslash" << "StringWith~Tilde";
 int i = 800;
 // INSERT the strings
 QStringList::Iterator it;
 for ( it = strings.begin(); it != strings.end(); ++it ) {
-	QSqlRecord* irec = cur.primeInsert();
+QSqlRecord* irec = cur.primeInsert();
-	QVERIFY( irec != 0 );
+QVERIFY( irec != 0 );
-	irec->setValue( "id", i );
+irec->setValue( "id", i );
-	irec->setValue( "t_varchar", (*it) );
+irec->setValue( "t_varchar", (*it) );
-	irec->setValue( "t_char", (*it) );
+irec->setValue( "t_char", (*it) );
-	irec->setValue( "t_numeric", (double)i );
+irec->setValue( "t_numeric", (double)i );
-	++i;
+++i;
-	QCOMPARE( cur.insert(), 1 );
+QVERIFY( validReturns.contains(cur.insert()) );
 }
 QVERIFY( cur.select( "id >= 800 and id < 900" ) );
 int i2 = 800;
 while( cur.next() ) {
-	QCOMPARE( cur.value( "id" ).toInt(), i2 );
+QCOMPARE( cur.value( "id" ).toInt(), i2 );
-	QCOMPARE( cur.value( "t_varchar" ).toString().stripWhiteSpace(), strings.at( i2 - 800 ) );
+QCOMPARE( cur.value( "t_varchar" ).toString().stripWhiteSpace(), strings.at( i2 - 800 ) );
-	QCOMPARE( cur.value( "t_char" ).toString().stripWhiteSpace(), strings.at( i2 - 800 ) );
+QCOMPARE( cur.value( "t_char" ).toString().stripWhiteSpace(), strings.at( i2 - 800 ) );
-	QCOMPARE( cur.value( "t_numeric" ).toDouble(), (double)i2 );
+QCOMPARE( cur.value( "t_numeric" ).toDouble(), (double)i2 );
-	++i2;
+++i2;
 }
 QCOMPARE( i, i2 );
 populateTestTables( db );
 }
 void tst_Q3SqlCursor::batchInsert()
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
+QSet<int> validReturns(QSet<int>() << -1 << 1);
 QSqlQuery q( db );
-q.exec( "delete from " + qTableName( "qtest" ) );
+q.exec( "delete from " + qtest );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 int i = 0;
 for ( ; i < 100; ++i ) {
-	QSqlRecord* irec = cur.primeInsert();
+QSqlRecord* irec = cur.primeInsert();
-	Q_ASSERT( irec );
+Q_ASSERT( irec );
-	irec->setValue( "id", i );
+irec->setValue( "id", i );
-	irec->setValue( "t_varchar", "blah" );
+irec->setValue( "t_varchar", "blah" );
-	irec->setValue( "t_char", "blah" );
+irec->setValue( "t_char", "blah" );
-	irec->setValue( "t_numeric", 1.1 );
+irec->setValue( "t_numeric", 1.1 );
-	if ( db.driverName().startsWith( "QSQLITE" ) ) {
+if ( db.driverName().startsWith( "QSQLITE" ) ) {
-	    QVERIFY( cur.insert( true ) );
+QVERIFY( cur.insert( true ) );
-	} else {
+} else {
-	    QCOMPARE( cur.insert( true ), 1 );
+QVERIFY( validReturns.contains(cur.insert( true )) );
 }
 }
 for ( ; i < 200; ++i ) {
 QSqlRecord* irec = cur.primeInsert();
 Q_ASSERT( irec );
 irec->setValue( "id", i );
 irec->setValue( "t_varchar", "blah" );
 irec->setValue( "t_char", "blah" );
 irec->setValue( "t_numeric", 1.1 );
-	if ( db.driverName().startsWith( "QSQLITE" ) ) {
+if ( db.driverName().startsWith( "QSQLITE" ) ) {
-	    QVERIFY( cur.insert( false ) );
+QVERIFY( cur.insert( false ) );
-	} else {
+} else {
-	    QCOMPARE( cur.insert( false ), 1 );
+QVERIFY( validReturns.contains(cur.insert( false )) );
 }
 }
 i = 0;
-QVERIFY_SQL(q, exec( "select * from " + qTableName( "qtest" ) + " order by id" ));
+QVERIFY_SQL(q, exec( "select * from " + qtest + " order by id" ));
 while ( q.next() ) {
-	QCOMPARE( q.value( 0 ).toInt(), i );
+QCOMPARE( q.value( 0 ).toInt(), i );
-	i++;
+i++;
 }
 QCOMPARE( i, 200 );
 populateTestTables( db );
 static QString dumpUtf8( const QString& str )
 {
 QString res;
 for ( int i = 0; i < (int)str.length(); ++i ) {
-	res += "0x" + QString::number( str[ i ].unicode(), 16 ) + ' ';
+res += "0x" + QString::number( str[ i ].unicode(), 16 ) + ' ';
 }
 return res;
 }
 void tst_Q3SqlCursor::insertORA()
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
 if (tst_Databases::getOraVersion(db) < 9)
-	QSKIP("Need Oracle >= 9", SkipSingle);
+QSKIP("Need Oracle >= 9", SkipSingle);
 /****** CHARSET TEST ******/
 QSqlQuery q( db );
-QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest_ovchar" ) + " ( id int primary key, t_char varchar(40) )" ));
+QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest_ovchar", __FILE__ ) + " ( id int primary key, t_char varchar(40) )" ));
 static const QString val1( "blah1" );
-Q3SqlCursor cur ( qTableName( "qtest_ovchar" ), true, db );
+Q3SqlCursor cur ( qTableName( "qtest_ovchar", __FILE__ ), true, db );
 QSqlRecord* irec = cur.primeInsert();
 irec->setValue( "id", 1 );
 irec->setValue( "t_char", val1 );
 QVERIFY( cur.insert() );
 QVERIFY_SQL(cur, select());
 QVERIFY( cur.next() );
 if ( cur.value( "t_char" ).toString() != val1 )
-	qDebug( QString( "Wrong value for t_char: expected '%1', got '%2'" ).arg( val1 ).arg(
+qDebug( QString( "Wrong value for t_char: expected '%1', got '%2'" ).arg( val1 ).arg(
-		cur.value( "t_char" ).toString() ) );
+cur.value( "t_char" ).toString() ) );
 static const unsigned short utf8arr[] = { 0xd792,0xd79c,0xd792,0xd79c,0xd799,0x00 };
 static const QString utf8str = QString::fromUcs2( utf8arr );
 irec = cur.primeInsert();
 qDebug( QString( "Wrong value for t_char: expected '%1', got '%2'" ).arg( dumpUtf8 ( utf8str ) ).arg(
 dumpUtf8( cur.value( "t_char" ).toString() ) ) );
 /****** NCHARSET TEST ********/
-QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest_onvchar" ) + " ( id int primary key, t_nchar nvarchar2(40) )" ));
+QVERIFY_SQL(q, exec( "create table " + qTableName( "qtest_onvchar", __FILE__ ) + " ( id int primary key, t_nchar nvarchar2(40) )" ));
-Q3SqlCursor cur2 ( qTableName( "qtest_onvchar" ), true, db );
+Q3SqlCursor cur2 ( qTableName( "qtest_onvchar", __FILE__ ), true, db );
 irec = cur2.primeInsert();
 irec->setValue( "id", 1 );
 irec->setValue( "t_nchar", val1 );
 QVERIFY( cur2.insert() );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
 static const QString utf8str = QString::fromUtf8( "ὕαλον ϕαγεῖν δύναμαι· τοῦτο οὔ με βλάπτει." );
 if ( !db.driver()->hasFeature( QSqlDriver::Unicode ) ) {
-	 QSKIP( "DBMS not Unicode capable", SkipSingle );
+QSKIP( "DBMS not Unicode capable", SkipSingle );
 }
 // ascii in the data storage, can't transliterate properly. invalid test.
 if(db.driverName().startsWith("QIBASE") && (db.databaseName() == "silence.nokia.troll.no:c:\\ibase\\testdb_ascii" || db.databaseName() == "/opt/interbase/qttest.gdb"))
 QSKIP("Can't transliterate extended unicode to ascii", SkipSingle);
-Q3SqlCursor cur( qTableName( "qtest_unicode" ), true, db );
+Q3SqlCursor cur( qTableName( "qtest_unicode", __FILE__ ), true, db );
 QSqlRecord* irec = cur.primeInsert();
 irec->setValue( 0, 500 );
 irec->setValue( 1, utf8str );
 irec->setValue( 2, utf8str );
 QVERIFY_SQL(cur, insert());
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest_precision" ), true, db );
+Q3SqlCursor cur( qTableName( "qtest_precision", __FILE__ ), true, db );
 cur.setTrimmed( "col1", true );
 QSqlRecord* irec = cur.primeInsert();
 irec->setValue( 0, precStr );
 QVERIFY( cur.insert() );
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 cur.setFilter( "id = 2" );
 QVERIFY_SQL(cur, select());
 QVERIFY( cur.next() );
 QCOMPARE( cur.value( "id" ).toInt(), 2 );
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor cur( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur( qtest, true, db );
 QVERIFY_SQL(cur, select());
 QVERIFY( cur.next() );
 QVERIFY( cur.next() );
-Q3SqlCursor cur2( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur2( qtest, true, db );
 QVERIFY_SQL(cur2, select( "id = 1" ));
 QVERIFY( cur2.next() );
 QCOMPARE( cur2.value( 0 ).toInt(), 1 );
-Q3SqlCursor cur3( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur3( qtest, true, db );
 QVERIFY_SQL(cur3, select( cur3.primaryIndex( false ) ));
 QVERIFY( cur3.next() );
 QVERIFY( cur3.next() );
 QCOMPARE( cur3.value( 0 ).toInt(), 1 );
-Q3SqlCursor cur4( qTableName( "qtest" ), true, db );
+Q3SqlCursor cur4( qtest, true, db );
 QSqlIndex idx = cur4.primaryIndex( false );
 QCOMPARE( (int)idx.count(), 2 );
 if ( tst_Databases::isMSAccess( db ) ) {
-	QCOMPARE( idx.field( 1 ).name().upper(), QString("ID") );
+QCOMPARE( idx.field( 1 ).name().upper(), QString("ID") );
-	QCOMPARE( idx.field( 0 ).name().upper(), QString("T_VARCHAR") );
+QCOMPARE( idx.field( 0 ).name().upper(), QString("T_VARCHAR") );
 } else {
-	QCOMPARE( idx.field( 0 ).name().upper(), QString("ID") );
+QCOMPARE( idx.field( 0 ).name().upper(), QString("ID") );
-	QCOMPARE( idx.field( 1 ).name().upper(), QString("T_VARCHAR") );
+QCOMPARE( idx.field( 1 ).name().upper(), QString("T_VARCHAR") );
 }
 #ifdef QT_DEBUG
 // Ignore debugging message advising users of a potential pitfall.
 QTest::ignoreMessage(QtDebugMsg, "Q3SqlCursor::setValue(): This will not affect actual database values. Use primeInsert(), primeUpdate() or primeDelete().");
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
-Q3SqlCursor c2( qTableName( "qtest" ), true, db );
+Q3SqlCursor c2( qtest, true, db );
-QCOMPARE( c2.name(), qTableName( "qtest" ) );
+QCOMPARE( c2.name(), qtest );
 QCOMPARE( c2.fieldName( 0 ).lower(), QString( "id" ) );
 Q3SqlCursor c( QString(), true, db );
-c.setName( qTableName( "qtest" ) );
+c.setName( qtest );
-QCOMPARE( c.name(), qTableName( "qtest" ) );
+QCOMPARE( c.name(), qtest );
 QCOMPARE( c.fieldName( 0 ).lower(), QString( "id" ) );
-c.setName( qTableName( "qtest_precision" ) );
+c.setName( qTableName( "qtest_precision", __FILE__ ) );
-QCOMPARE( c.name(), qTableName( "qtest_precision" ) );
+QCOMPARE( c.name(), qTableName( "qtest_precision", __FILE__ ) );
 QCOMPARE( c.fieldName( 0 ).lower(), QString( "col1" ) );
 }
 /* Database independent test */
 void tst_Q3SqlCursor::updateNoPK()
 {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
+QSet<int> validReturns(QSet<int>() << -1 << 1);
 QSqlQuery q(db);
-QVERIFY_SQL(q, exec("create table " + qTableName( "qtestPK" ) + " (id int, name varchar(20), num numeric)"));
+QVERIFY_SQL(q, exec("create table " + qTableName( "qtestPK", __FILE__ ) + " (id int, name varchar(20), num numeric)"));
-Q3SqlCursor cur(qTableName("qtestPK"), true, db);
+Q3SqlCursor cur(qTableName("qtestPK", __FILE__), true, db);
 QSqlRecord* rec = cur.primeInsert();
 Q_ASSERT(rec);
 rec->setNull(0);
 rec->setNull(1);
 rec->setNull(2);
-QVERIFY_SQL(cur, insert() == 1);
+QVERIFY(validReturns.contains(cur.insert()));
 if (!db.driver()->hasFeature(QSqlDriver::PreparedQueries)) {
 // Only QPSQL, QMYSQL, QODBC and QOCI drivers currently use escape identifiers for column names
 if (db.driverName().startsWith("QPSQL") ||
 db.driverName().startsWith("QMYSQL") ||
 db.driverName().startsWith("QODBC") ||
 db.driverName().startsWith("QOCI")) {
-QString query = QString::fromLatin1("insert into " + qTableName("qtestPK") +
+QString query = QString::fromLatin1("insert into " + qTableName("qtestPK", __FILE__) +
 " (" + db.driver()->escapeIdentifier("id", QSqlDriver::FieldName) + ','
 + db.driver()->escapeIdentifier("name", QSqlDriver::FieldName) + ','
 + db.driver()->escapeIdentifier("num", QSqlDriver::FieldName) + ')'
 + " values (NULL,NULL,NULL)");
 QCOMPARE(cur.lastQuery(), query);
 } else {
-	    QCOMPARE(cur.lastQuery(), QString::fromLatin1("insert into " + qTableName("qtestPK") +
+QCOMPARE(cur.lastQuery(), QString::fromLatin1("insert into " + qTableName("qtestPK", __FILE__) +
-						         " (\"id\",\"name\",\"num\") values (NULL,NULL,NULL)"));
+" (\"id\",\"name\",\"num\") values (NULL,NULL,NULL)"));
 }
 }
 rec = cur.primeUpdate();
 Q_ASSERT(rec);
 rec->setValue(0, 1);
 rec->setNull(1);
 rec->setNull(2);
 // Sqlite returns 2, don't ask why.
 QVERIFY(cur.update() != 0);
-QString expect = "update " + qTableName("qtestPK") +
+QString expect = "update " + qTableName("qtestPK", __FILE__) +
 " set "+db.driver()->escapeIdentifier("id", QSqlDriver::FieldName)+" = 1 , "
 +db.driver()->escapeIdentifier("name", QSqlDriver::FieldName)+" = NULL , "
-+db.driver()->escapeIdentifier("num", QSqlDriver::FieldName)+" = NULL  where " + qTableName("qtestPK") + ".id"
++db.driver()->escapeIdentifier("num", QSqlDriver::FieldName)+" = NULL  where " + qTableName("qtestPK", __FILE__) + ".id"
-" IS NULL and " + qTableName("qtestPK") + ".name IS NULL and " +
+" IS NULL and " + qTableName("qtestPK", __FILE__) + ".name IS NULL and " +
-qTableName("qtestPK") + ".num IS NULL";
+qTableName("qtestPK", __FILE__) + ".num IS NULL";
 if (!db.driver()->hasFeature(QSqlDriver::PreparedQueries)) {
 if (!db.driverName().startsWith("QSQLITE")) {
-	    QCOMPARE(cur.lastQuery(), expect);
+QCOMPARE(cur.lastQuery(), expect);
 }
 }
 QVERIFY(cur.select(cur.index(QString("id"))));
 QVERIFY(cur.next());
 QCOMPARE(cur.value("id").toInt(), 1);
 void tst_Q3SqlCursor::insertFieldNameContainsWS() {
 QFETCH( QString, dbName );
 QSqlDatabase db = QSqlDatabase::database( dbName );
 CHECK_DATABASE( db );
+QSet<int> validReturns(QSet<int>() << -1 << 1);
 // The bugfix (and this test) depends on QSqlDriver::escapeIdentifier(...)
 // to be implemented, which is currently only the case for the
 // QPSQL, QODBC and QOCI drivers.
 if (!db.driverName().startsWith("QPSQL") &&
 !db.driverName().startsWith("QOCI")) {
 QSKIP("PSQL, QODBC or QOCI specific test", SkipSingle);
 return;
 }
-QString tableName = qTableName("qtestws");
+QString tableName = qTableName("qtestws", __FILE__);
 QSqlQuery q(db);
 tst_Databases::safeDropTable(db, tableName);
 QString query = "CREATE TABLE %1 (id int, "
 + db.driver()->escapeIdentifier("first Name", QSqlDriver::FieldName)
 QSqlRecord *r = cur.primeInsert();
 r->setValue("id", 1);
 r->setValue("firsT NaMe", "Kong");
 r->setValue("lastNaMe", "Harald");
-QVERIFY(cur.insert() == 1);
+QVERIFY(validReturns.contains(cur.insert()));
 cur.select();
 cur.next();
 QVERIFY(cur.value(0) == 1);

changeset 7	f7bc934e204c
parent 0	1918ee327afb