1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
.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;
}
|
