blob: e2f27049274ac87d45b7717e995bc4a718d18a8a (
plain)
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
|
.import QtQuick.LocalStorage 2.0 as Sql
function test() {
var db = Sql.LocalStorage.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;
}
|