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_QSqlDriver::recreateTestTables(QSqlDatabase db)
{
QSqlQuery q(db);
if(tst_Databases::isPostgreSQL(db))
QVERIFY_SQL( q, exec("set client_min_messages='warning'"));
tst_Databases::safeDropTable( db, qTableName( "relTEST1" ) );
QVERIFY_SQL( q, exec("create table " + qTableName("relTEST1") +
" (id int not null primary key, name varchar(20), title_key int, another_title_key int)"));
QVERIFY_SQL( q, exec("insert into " + qTableName("relTEST1") + " values(1, 'harry', 1, 2)"));
QVERIFY_SQL( q, exec("insert into " + qTableName("relTEST1") + " values(2, 'trond', 2, 1)"));
QVERIFY_SQL( q, exec("insert into " + qTableName("relTEST1") + " values(3, 'vohi', 1, 2)"));
QVERIFY_SQL( q, exec("insert into " + qTableName("relTEST1") + " values(4, 'boris', 2, 2)"));
}
// 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
}
