MVC SQL question

[cpuinthebrain]

I'd like to make simple invoice app.
I use SQLite for database.
I can't find similar example of MVC structured app using SQL(QsqlQuery) without ORM.

What i can't understand is how the model class should looks like?
Should be there some class named Model for instance that simply has functions which returns data with different queries?

For instance:

Model

QSqlQueryModel Model::getPartners(){
 
    QSqlQueryModel *model = new QSqlQueryModel(this);
    model->setQuery("SELECT ID, Name, City, Address, Bulstat FROM partners");
    return model;
 
}
 
 
void Model::addNewPartner(QString name,QString city, QString address, QString mol, QString bulstat, QString vat, QString phone, QString email){
 
    QSqlQuery query;
    query.prepare("INSERT INTO partners .............
 
}

QSqlQueryModel Model::getPartners(){

    QSqlQueryModel *model = new QSqlQueryModel(this);
    model->setQuery("SELECT ID, Name, City, Address, Bulstat FROM partners");
    return model;

}


void Model::addNewPartner(QString name,QString city, QString address, QString mol, QString bulstat, QString vat, QString phone, QString email){

    QSqlQuery query;
    query.prepare("INSERT INTO partners .............

}

To copy to clipboard, switch view to plain text mode