Trying to get records from database with c++ and pass it to listview model

[daka]

I'm lost with all datatypes and what I'm trying to do is to get object or json to pass to qml list view model.

Lets start, I have the resuts from SELECT query and Im looping:

QJsonObject data;
while (query.next()) {
        data.insert("firstname", query.value("FIRSTNAME").toString());
        data.insert("name", query.value("NAME").toString());
}

I have like 10 results from database, but if I print this with qdebug() I get only last result.
So it doesn't append new result, but it overwrites it.

Even if I make this work to append the data, then I hope in qml it will be easy to place it in listview.
Maybe QJsonObject is not way to go, any suggestion would be nice.

[daka]

What tried is next:

QJsonArray data;
QJsonObject myObject;
while (query.next()) {
         myObject.insert("firstname", query.value("FIRSTNAME").toString());
         myObject.insert("name", query.value("NAME").toString());
         data.push_back(myObject);

then in qml I'm trying to get this object:

Rectangle {
        id: rectangle
        color: "#2c313c"
        anchors.fill: parent
        Component.onCompleted: {
            cli = JSON.stringify(Clients.clients())
            for (var i = 0; i < cli.length; i++) {
                console.log(cli[i] + "<br>")
            }
        }

        ListView {
            anchors.fill: parent
            anchors.margins: 20
            clip: true
            model: Clients.clients()
            delegate: spaceManDelegate
            section.property: "nation"
            section.delegate: sectionDelegate
        }

        Component {
            id: spaceManDelegate
            Item {
                width: ListView.view.width
                height: 20
                Text {
                    anchors.left: parent.left
                    anchors.verticalCenter: parent.verticalCenter
                    anchors.leftMargin: 8
                    font.pixelSize: 12
                    text: name
                    color: "#b9b5b5"
                }
            }
        }

        Component {
            id: sectionDelegate
            Text {
                width: ListView.view.width
                height: 20
                text: section
            }
        }

I get next error:
qrc:/qml/views/clients/read.qml: ReferenceError: name is not defined

[daka]

On the QML site when I do next:

Component.onCompleted: {
            var cli = Clients.clients()
            console.log(cli)
            for (var i = 0; i < cli.length; i++) {
                console.log(cli[i].name + " : " + cli[i].firstname)
            }
        }

I get the valid results....but format does spaceManDelegate want?

[daka]

Text {
                    anchors.left: parent.left
                    anchors.verticalCenter: parent.verticalCenter
                    anchors.leftMargin: 8
                    font.pixelSize: 12
                    text: modelData.name
                    color: "#b9b5b5"
                    Component.onCompleted: {

                        console.log(JSON.stringify(modelData.name))
                    }
                }

so modelData.name does the trick....maybe there are better ways, if someone hve any suggestion, please share