diff options
Diffstat (limited to 'tests/auto/declarative/qdeclarativesqldatabase')
19 files changed, 0 insertions, 664 deletions
diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/README b/tests/auto/declarative/qdeclarativesqldatabase/data/README deleted file mode 100644 index 7efca3a972..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/README +++ /dev/null @@ -1,3 +0,0 @@ -These tests are executed in sequence - the database persist until the end of the -testing. This is done to better exercise the persistence of the database, since -that is how it is used. diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/changeversion.js b/tests/auto/declarative/qdeclarativesqldatabase/data/changeversion.js deleted file mode 100644 index 178ff7c4af..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/changeversion.js +++ /dev/null @@ -1,55 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - - var db = Sql.openDatabaseSync("QmlTestDB-changeversion", "", "Test database from Qt autotests", 1000000, - function(db) { - db.changeVersion("","1.0") - db.transaction(function(tx){ - tx.executeSql('CREATE TABLE Greeting(salutation TEXT, salutee TEXT)'); - }) - }); - - db.transaction(function(tx){ - tx.executeSql('INSERT INTO Greeting VALUES ("Hello", "world")'); - tx.executeSql('INSERT INTO Greeting VALUES ("Goodbye", "cruel world")'); - }); - - - db = Sql.openDatabaseSync("QmlTestDB-changeversion", "", "Test database from Qt autotests", 1000000); - - if (db.version == "1.0") - db.changeVersion("1.0","2.0",function(tx) - { - tx.executeSql('CREATE TABLE Utterance(type TEXT, phrase TEXT)') - var rs = tx.executeSql('SELECT * FROM Greeting'); - for (var i=0; i<rs.rows.length; ++i) { - var type = "Greeting"; - var phrase = rs.rows.item(i).salutation + ", " + rs.rows.item(i).salutee; - if (rs.rows.item(i).salutation == "Goodbye" - || rs.rows.item(i).salutation == "Farewell" - || rs.rows.item(i).salutation == "Good-bye") type = "Valediction"; - var ins = tx.executeSql('INSERT INTO Utterance VALUES(?,?)',[type,phrase]); - } - tx.executeSql('DROP TABLE Greeting'); - }); - else - return "db.version should be 1.0, but is " + db.version; - - var db = Sql.openDatabaseSync("QmlTestDB-changeversion", "2.0", "Test database from Qt autotests", 1000000); - - db.transaction(function(tx){ - var rs = tx.executeSql('SELECT * FROM Utterance'); - r = "" - for (var i=0; i<rs.rows.length; ++i) { - r += "(" + rs.rows.item(i).type + ": " + rs.rows.item(i).phrase + ")"; - } - if (r == "(Greeting: Hello, world)(Valediction: Goodbye, cruel world)") - r = "passed" - else - r = "WRONG DATA: " + r; - }) - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/creation-a.js b/tests/auto/declarative/qdeclarativesqldatabase/data/creation-a.js deleted file mode 100644 index 25cba05451..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/creation-a.js +++ /dev/null @@ -1,20 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - - var db = Sql.openDatabaseSync("QmlTestDB-creation-a", "1.0", "Test database from Qt autotests", 1000000, - function(db) { - db.transaction(function(tx){ - tx.executeSql('CREATE TABLE Greeting(salutation TEXT, salutee TEXT)'); - r = "passed"; - }) - }); - - var db = Sql.openDatabaseSync("QmlTestDB-creation-a", "1.0", "Test database from Qt autotests", 1000000, - function(db) { - r = "FAILED: should have already been created"; - }); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/creation.js b/tests/auto/declarative/qdeclarativesqldatabase/data/creation.js deleted file mode 100644 index 64eb4c7b92..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/creation.js +++ /dev/null @@ -1,15 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - var db = Sql.openDatabaseSync("QmlTestDB-creation", "1.0", "Test database from Qt autotests", 1000000); - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - r = "passed"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/error-a.js b/tests/auto/declarative/qdeclarativesqldatabase/data/error-a.js deleted file mode 100644 index d7e9b4fdff..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/error-a.js +++ /dev/null @@ -1,22 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-error-a", "1.0", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - try { - db.transaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM NotExists'); - r = "SHOULD NOT SUCCEED"; - } - ); - } catch (err) { - if (err.message == "no such table: NotExists Unable to execute statement") - r = "passed"; - else - r = "WRONG ERROR="+err.message; - } - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/error-b.js b/tests/auto/declarative/qdeclarativesqldatabase/data/error-b.js deleted file mode 100644 index 17e34c989e..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/error-b.js +++ /dev/null @@ -1,15 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-error-b", "1.0", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - db.transaction( - function(tx) { - tx.executeSql('INSERT INTO Greeting VALUES("junk","junk")'); - notexist[123] = "oops" - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/error-creation.js b/tests/auto/declarative/qdeclarativesqldatabase/data/error-creation.js deleted file mode 100644 index d66977d1e2..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/error-creation.js +++ /dev/null @@ -1,16 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - try { - var db = Sql.openDatabaseSync("QmlTestDB-creation", "2.0", "Test database from Qt autotests", 1000000); - } catch (err) { - if (err.code != SQLException.VERSION_ERR) - r = "WRONG ERROR CODE="+err.code; - else if (err.message != "SQL: database version mismatch") - r = "WRONG ERROR="+err.message; - else - r = "passed"; - } - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/error-notransaction.js b/tests/auto/declarative/qdeclarativesqldatabase/data/error-notransaction.js deleted file mode 100644 index 2cce3f613c..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/error-notransaction.js +++ /dev/null @@ -1,17 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-data/error-notransaction", "1.0", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - try { - db.transaction(); - } catch (err) { - if (err.message == "transaction: missing callback") - r = "passed"; - else - r = "WRONG ERROR="+err.message; - } - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/error-outsidetransaction.js b/tests/auto/declarative/qdeclarativesqldatabase/data/error-outsidetransaction.js deleted file mode 100644 index 7af7c1c6a2..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/error-outsidetransaction.js +++ /dev/null @@ -1,19 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-data/error-notransaction", "1.0", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - var v; - - try { - db.transaction(function(tx) { v = tx }); - v.executeSql("SELECT 'bad'") - } catch (err) { - if (err.message == "executeSql called outside transaction()") - r = "passed"; - else - r = "WRONG ERROR="+err.message; - } - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/iteration-forwardonly.js b/tests/auto/declarative/qdeclarativesqldatabase/data/iteration-forwardonly.js deleted file mode 100644 index b3df1be113..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/iteration-forwardonly.js +++ /dev/null @@ -1,31 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-iteration-forwardonly", "", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES ("Hello", "world")'); - tx.executeSql('INSERT INTO Greeting VALUES ("Goodbye", "cruel world")'); - } - ) - - db.transaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM Greeting'); - rs.forwardOnly = !rs.forwardOnly - var r1="" - for(var i = 0; i < rs.rows.length; i++) - r1 += rs.rows.item(i).salutation + ", " + rs.rows.item(i).salutee + ";" - if (r1 != "hello, world;hello, world;hello, world;hello, world;") - if (r1 != "Hello, world;Goodbye, cruel world;") - r = "SELECTED DATA WRONG: "+r1; - else - r = "passed"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/iteration.js b/tests/auto/declarative/qdeclarativesqldatabase/data/iteration.js deleted file mode 100644 index 8d96dc2154..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/iteration.js +++ /dev/null @@ -1,30 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-iteration", "", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES ("Hello", "world")'); - tx.executeSql('INSERT INTO Greeting VALUES ("Goodbye", "cruel world")'); - } - ) - - db.transaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM Greeting'); - var r1="" - for(var i = 0; i < rs.rows.length; i++) - r1 += rs.rows.item(i).salutation + ", " + rs.rows.item(i).salutee + ";" - if (r1 != "hello, world;hello, world;hello, world;hello, world;") - if (r1 != "Hello, world;Goodbye, cruel world;") - r = "SELECTED DATA WRONG: "+r1; - else - r = "passed"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/readonly-error.js b/tests/auto/declarative/qdeclarativesqldatabase/data/readonly-error.js deleted file mode 100644 index 39eb398004..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/readonly-error.js +++ /dev/null @@ -1,29 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - var db = Sql.openDatabaseSync("QmlTestDB-readonly-error", "1.0", "Test database from Qt autotests", 1000000); - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - } - ); - - try { - db.readTransaction( - function(tx) { - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - r = "FAILED"; - } - ); - } catch (err) { - if (err.message == "Read-only Transaction") - r = "passed"; - else - r = "WRONG ERROR="+err.message; - } - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/readonly.js b/tests/auto/declarative/qdeclarativesqldatabase/data/readonly.js deleted file mode 100644 index 985c9ecab5..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/readonly.js +++ /dev/null @@ -1,26 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - var db = Sql.openDatabaseSync("QmlTestDB-readonly", "1.0", "Test database from Qt autotests", 1000000); - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - r = "passed"; - } - ); - - db.readTransaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM Greeting'); - if (rs.rows.item(0).salutation == 'hello') - r = "passed"; - else - r = "FAILED"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/reopen1.js b/tests/auto/declarative/qdeclarativesqldatabase/data/reopen1.js deleted file mode 100644 index 2171fb028e..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/reopen1.js +++ /dev/null @@ -1,16 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - var db = Sql.openDatabaseSync("QmlTestDB-reopen", "1.0", "Test database from Qt autotests", 1000000); - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - r = "passed"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/reopen2.js b/tests/auto/declarative/qdeclarativesqldatabase/data/reopen2.js deleted file mode 100644 index 12c6135145..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/reopen2.js +++ /dev/null @@ -1,18 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var r="transaction_not_finished"; - var db = Sql.openDatabaseSync("QmlTestDB-reopen", "1.0", "Test database from Qt autotests", 1000000); - - db.transaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM Greeting'); - if (rs.rows.item(0).salutation == 'hello') - r = "passed"; - else - r = "FAILED"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/selection-bindnames.js b/tests/auto/declarative/qdeclarativesqldatabase/data/selection-bindnames.js deleted file mode 100644 index 9333ccfacb..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/selection-bindnames.js +++ /dev/null @@ -1,28 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-bindnames", "", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'goodbye', 'world' ]); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'there' ]); - } - ); - - db.transaction( - function(tx) { - var rs = tx.executeSql('SELECT * FROM Greeting WHERE salutation=:p2 AND salutee=:p1', {':p1':'world', ':p2':'hello'}); - if ( rs.rows.length != 2 ) - r = "SELECT RETURNED WRONG VALUE "+rs.rows.length+rs.rows.item(0)+rs.rows.item(1) - else - r = "passed"; - } - ); - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/data/selection.js b/tests/auto/declarative/qdeclarativesqldatabase/data/selection.js deleted file mode 100644 index 18d4dce80f..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/data/selection.js +++ /dev/null @@ -1,46 +0,0 @@ -.import QtQuick.LocalStorage 2.0 as Sql - -function test() { - var db = Sql.openDatabaseSync("QmlTestDB-selection", "", "Test database from Qt autotests", 1000000); - var r="transaction_not_finished"; - - db.transaction( - function(tx) { - tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - tx.executeSql('CREATE TABLE IF NOT EXISTS TypeTest(num INTEGER, txt1 TEXT, txt2 TEXT)'); - tx.executeSql("INSERT INTO TypeTest VALUES(1, null, 'hello')"); - } - ); - - db.transaction( - function(tx) { - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]); - var rs = tx.executeSql('SELECT * FROM Greeting'); - if ( rs.rows.length != 4 ) - r = "SELECT RETURNED WRONG VALUE "+rs.rows.length+rs.rows[0]+rs.rows[1] - else - r = "passed"; - } - ); - if (r == "passed") { - db.transaction(function (tx) { - r = ""; - var firstRow = tx.executeSql("SELECT * FROM TypeTest").rows.item(0); - if (typeof(firstRow.num) != "number") - r += " num:" + firstRow.num+ "type:" + typeof(firstRow.num); - if (typeof(firstRow.txt1) != "object" || firstRow.txt1 != null) - r += " txt1:" + firstRow.txt1 + " type:" + typeof(firstRow.txt1); - if (typeof(firstRow.txt2) != "string" || firstRow.txt2 != "hello") - r += " txt2:" + firstRow.txt2 + " type:" + typeof(firstRow.txt2); - if (r == "") - r = "passed"; - else - r = "SELECT RETURNED VALUES WITH WRONG TYPES " + r; - }); - } - - return r; -} diff --git a/tests/auto/declarative/qdeclarativesqldatabase/qdeclarativesqldatabase.pro b/tests/auto/declarative/qdeclarativesqldatabase/qdeclarativesqldatabase.pro deleted file mode 100644 index cc27d173ab..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/qdeclarativesqldatabase.pro +++ /dev/null @@ -1,15 +0,0 @@ -CONFIG += testcase -TARGET = tst_qdeclarativesqldatabase -macx:CONFIG -= app_bundle - -SOURCES += tst_qdeclarativesqldatabase.cpp - -include (../../shared/util.pri) - -CONFIG += parallel_test - -testDataFiles.files = data -testDataFiles.path = . -DEPLOYMENT += testDataFiles - -QT += core-private gui-private v8-private declarative-private quick-private sql testlib diff --git a/tests/auto/declarative/qdeclarativesqldatabase/tst_qdeclarativesqldatabase.cpp b/tests/auto/declarative/qdeclarativesqldatabase/tst_qdeclarativesqldatabase.cpp deleted file mode 100644 index cf4daed2f9..0000000000 --- a/tests/auto/declarative/qdeclarativesqldatabase/tst_qdeclarativesqldatabase.cpp +++ /dev/null @@ -1,243 +0,0 @@ -/**************************************************************************** -** -** Copyright (C) 2012 Nokia Corporation and/or its subsidiary(-ies). -** Contact: http://www.qt-project.org/ -** -** 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 <qtest.h> -#include <QtDeclarative/qdeclarativeengine.h> -#include <QtDeclarative/qdeclarativecomponent.h> -#include <QtQuick/private/qquicktext_p.h> -#include <private/qdeclarativeengine_p.h> -#include <QtCore/qcryptographichash.h> -/* -#include <QtWebKit/qwebpage.h> -#include <QtWebKit/qwebframe.h> -#include <QtWebKit/qwebdatabase.h> -#include <QtWebKit/qwebsecurityorigin.h> -*/ -#include <QtSql/qsqldatabase.h> -#include <QtCore/qdir.h> -#include <QtCore/qfile.h> -#include "../../shared/util.h" - -class tst_qdeclarativesqldatabase : public QDeclarativeDataTest -{ - Q_OBJECT -public: - tst_qdeclarativesqldatabase() - { - qApp->setApplicationName("tst_qdeclarativesqldatabase"); - qApp->setOrganizationName("Nokia"); - qApp->setOrganizationDomain("nokia.com"); - engine = new QDeclarativeEngine; - } - - ~tst_qdeclarativesqldatabase() - { - delete engine; - } - -private slots: - void initTestCase(); - - void checkDatabasePath(); - - void testQml_data(); - void testQml(); - void testQml_cleanopen_data(); - void testQml_cleanopen(); - void totalDatabases(); - - void cleanupTestCase(); - -private: - QString dbDir() const; - QDeclarativeEngine *engine; -}; - -void removeRecursive(const QString& dirname) -{ - QDir dir(dirname); - QFileInfoList entries(dir.entryInfoList(QDir::Dirs|QDir::Files|QDir::NoDotAndDotDot)); - for (int i = 0; i < entries.count(); ++i) - if (entries[i].isDir()) - removeRecursive(entries[i].filePath()); - else - dir.remove(entries[i].fileName()); - QDir().rmdir(dirname); -} - -void tst_qdeclarativesqldatabase::initTestCase() -{ - QDeclarativeDataTest::initTestCase(); - removeRecursive(dbDir()); - QDir().mkpath(dbDir()); -} - -void tst_qdeclarativesqldatabase::cleanupTestCase() -{ - removeRecursive(dbDir()); -} - -QString tst_qdeclarativesqldatabase::dbDir() const -{ - static QString tmpd = QDir::tempPath()+"/tst_qdeclarativesqldatabase_output-" - + QDateTime::currentDateTime().toString(QLatin1String("yyyyMMddhhmmss")); - return tmpd; -} - -void tst_qdeclarativesqldatabase::checkDatabasePath() -{ - // Check default storage path (we can't use it since we don't want to mess with user's data) - QVERIFY(engine->offlineStoragePath().contains("tst_qdeclarativesqldatabase")); - QVERIFY(engine->offlineStoragePath().contains("OfflineStorage")); -} - -static const int total_databases_created_by_tests = 12; -void tst_qdeclarativesqldatabase::testQml_data() -{ - QTest::addColumn<QString>("jsfile"); // The input file - - // Each test should use a newly named DB to avoid inter-test dependencies - QTest::newRow("creation") << "creation.js"; - QTest::newRow("creation-a") << "creation-a.js"; - QTest::newRow("creation") << "creation.js"; - QTest::newRow("error-creation") << "error-creation.js"; // re-uses above DB - QTest::newRow("changeversion") << "changeversion.js"; - QTest::newRow("readonly") << "readonly.js"; - QTest::newRow("readonly-error") << "readonly-error.js"; - QTest::newRow("selection") << "selection.js"; - QTest::newRow("selection-bindnames") << "selection-bindnames.js"; - QTest::newRow("iteration") << "iteration.js"; - QTest::newRow("iteration-forwardonly") << "iteration-forwardonly.js"; - QTest::newRow("error-a") << "error-a.js"; - QTest::newRow("error-notransaction") << "error-notransaction.js"; - QTest::newRow("error-outsidetransaction") << "error-outsidetransaction.js"; // reuse above - QTest::newRow("reopen1") << "reopen1.js"; - QTest::newRow("reopen2") << "reopen2.js"; // re-uses above DB - - // If you add a test, you should usually use a new database in the - // test - in which case increment total_databases_created_by_tests above. -} - -/* -class QWebPageWithJavaScriptConsoleMessages : public QWebPage { -public: - void javaScriptConsoleMessage(const QString& message, int lineNumber, const QString& sourceID) - { - qWarning() << sourceID << ":" << lineNumber << ":" << message; - } -}; - -void tst_qdeclarativesqldatabase::validateAgainstWebkit() -{ - // Validates tests against WebKit (HTML5) support. - // - QFETCH(QString, jsfile); - QFETCH(QString, result); - QFETCH(int, databases); - - QFile f(jsfile); - QVERIFY(f.open(QIODevice::ReadOnly)); - QString js=f.readAll(); - - QWebPageWithJavaScriptConsoleMessages webpage; - webpage.settings()->setOfflineStoragePath(dbDir()); - webpage.settings()->setAttribute(QWebSettings::OfflineStorageDatabaseEnabled, true); - - QEXPECT_FAIL("","WebKit doesn't support openDatabaseSync yet", Continue); - QCOMPARE(webpage.mainFrame()->evaluateJavaScript(js).toString(),result); - - QTest::qWait(100); // WebKit crashes if you quit it too fast - - QWebSecurityOrigin origin = webpage.mainFrame()->securityOrigin(); - QList<QWebDatabase> dbs = origin.databases(); - QCOMPARE(dbs.count(), databases); -} -*/ - -void tst_qdeclarativesqldatabase::testQml() -{ - // Tests QML SQL Database support with tests - // that have been validated against Webkit. - // - QFETCH(QString, jsfile); - - QString qml= - "import QtQuick 2.0\n" - "import \""+jsfile+"\" as JS\n" - "Text { text: JS.test() }"; - - engine->setOfflineStoragePath(dbDir()); - QDeclarativeComponent component(engine); - component.setData(qml.toUtf8(), testFileUrl("empty.qml")); // just a file for relative local imports - QVERIFY(!component.isError()); - QQuickText *text = qobject_cast<QQuickText*>(component.create()); - QVERIFY(text != 0); - QCOMPARE(text->text(),QString("passed")); -} - -void tst_qdeclarativesqldatabase::testQml_cleanopen_data() -{ - QTest::addColumn<QString>("jsfile"); // The input file - QTest::newRow("reopen1") << "reopen1.js"; - QTest::newRow("reopen2") << "reopen2.js"; - QTest::newRow("error-creation") << "error-creation.js"; // re-uses creation DB -} - -void tst_qdeclarativesqldatabase::testQml_cleanopen() -{ - // Same as testQml, but clean connections between tests, - // making it more like the tests are running in new processes. - testQml(); - - engine->collectGarbage(); - - foreach (QString dbname, QSqlDatabase::connectionNames()) { - QSqlDatabase::removeDatabase(dbname); - } -} - -void tst_qdeclarativesqldatabase::totalDatabases() -{ - QCOMPARE(QDir(dbDir()+"/Databases").entryInfoList(QDir::Files|QDir::NoDotAndDotDot).count(), total_databases_created_by_tests*2); -} - -QTEST_MAIN(tst_qdeclarativesqldatabase) - -#include "tst_qdeclarativesqldatabase.moc" |