tests/auto/declarative/qdeclarativesqldatabase/data/iteration-forwardonly.js
author Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
Mon, 04 Oct 2010 01:19:32 +0300
changeset 37 758a864f9613
parent 30 5dc02b23752f
permissions -rw-r--r--
Revision: 201037 Kit: 201039

function test() {
    var db = 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;
}