File: nullvalues.js

package info (click to toggle)
qtdeclarative-opensource-src-gles 5.15.15%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 258,796 kB
  • sloc: javascript: 512,412; cpp: 497,152; xml: 8,892; python: 3,304; ansic: 2,764; sh: 206; makefile: 46; php: 27
file content (24 lines) | stat: -rw-r--r-- 824 bytes parent folder | download | duplicates (13)
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;
}