27 lines
764 B
JavaScript
27 lines
764 B
JavaScript
.import QtQuick.LocalStorage 2.0 as Sql
|
|
|
|
function test() {
|
|
var r="transaction_not_finished";
|
|
var db = Sql.LocalStorage.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;
|
|
}
|