1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
.import QtQuick.LocalStorage 2.0 as Sql
function test() {
var db = Sql.LocalStorage.openDatabaseSync("QmlTestDB-nullvalues", "", "Test database from Qt autotests", 1000000);
var r="transaction_not_finished";
db.transaction(
function(tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS NullValues(salutation TEXT, salutee TEXT)');
tx.executeSql('INSERT INTO NullValues VALUES(?, ?)', [ 'hello', null ]);
var firstRow = tx.executeSql("SELECT * FROM NullValues").rows.item(0);
if (firstRow.salutation !== "hello")
return
if (firstRow.salutee === "") {
r = "wrong_data_type"
return
}
if (firstRow.salutee === null)
r = "passed";
}
);
return r;
}
|
