diff options
Diffstat (limited to 'tests/auto/declarative/qdeclarativesqldatabase/data/changeversion.js')
-rw-r--r-- | tests/auto/declarative/qdeclarativesqldatabase/data/changeversion.js | 55 |
1 files changed, 0 insertions, 55 deletions
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; -} |