Intagrating SQLite with Qt Quick

dstudentx

I'm trying to include a SQLite database with QT Quick but I can't find any examples.

Does anyone know of any example programs I can play with?

luoqiya

There is example in yourInstall\Qt5.0.2\5.0.2\mingw47_32\examples\declarative\sqllocalstorage

dstudentx

Thanks but I need it to be non c++

chrisadams

https://qt.gitorious.org/qt/qtdeclarative/blobs/stable/examples/quick/localstorage/localstorage/hello.qml

Cheers,
Chris.

dstudentx

Thanks that helped me loads!
I have a question the is related to the link you sent me; I posted it on stackoverflow but never got a response.

in qtquick 2.0 I can read text from a database but I can't get it to show in in a specific state only in all states. how can I call my function reading in the database in a specific state for example 'state1'

@Text {
text: "?"
anchors.horizontalCenter: parent.horizontalCenter
function get_db() {
var db = LocalStorage.openDatabaseSync("DB1", "1.0", "The Example QML SQL!", 1000000);
db.transaction(
function(tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)');
for ( var z=0; z<10; z++){
// tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ z, z ]);
}
// tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]);
var rs = tx.executeSql('SELECT * FROM Greeting');
var r = ""
for(var i = 0; i < rs.rows.length; i++) {
r += rs.rows.item(i).salutation + ", " + rs.rows.item(i).salutee + "\n"
}
text = r
})}
Component.onCompleted: get_db()
}

states: [

State {
    name: "State1"
    PropertyChanges {
        target: mousearea1
        x: 608
        y: 1022
    }

    PropertyChanges {
        target: image5
        x: 760
        y: 980
    }

    PropertyChanges {
        target: image1
        x: 245
        y: 345
        width: 298
        height: 271
        fillMode: "PreserveAspectFit"
        source: "images/item.png"
        opacity: 1

    }

    PropertyChanges {
        target: mousearea2
        width: 130
        height: 190
        opacity: 1
          onClicked: page.state = 'base state'
    }

    PropertyChanges {
        target: image2
        x: 543
        y: 345
        width: 154
        height: 271
        fillMode: "PreserveAspectFit"
        source: "images/item.png"
        opacity: 1
    }
}

]@

luoqiya

@Component.onComplated{
get_db();
Test_id.state:"State1"
}@
u should set when to change your state.

dstudentx

Thanks for the help!
I getting a syntax error though.

!http://farm9.staticflickr.com/8545/8938019077_5c2dccb53c_o.jpg(image)!

luoqiya

Sorry for the lately reply.
You should set your parent item id to Test_id

Like this:

@
Rectangle{
id:"test_id"
...
Component.onComplated{
test_id.state="your state"
}
}
@

in your demo,you should change Test_id.state="State1" to mouseArea1.state="State1"

read QML states manual u may understand it