Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db = new DbManager();
- sqlParcelleModel = new QSqlTableModel(nullptr, db->getDB());
- sqlParcelleModel->setTable("Parcelle");
- qDebug() << "row count:" << sqlParcelleModel->rowCount();
- /* sqlUserModel = new QSqlTableModel(nullptr, db->getDB());
- sqlUserModel->setTable("Person");
- sqlMissionModel = new QSqlTableModel(nullptr, db->getDB());
- sqlMissionModel->setTable("Mission");*/
- QSqlRecord record = sqlParcelleModel->record();
- record.setValue("owner", "foo");
- record.setValue("parcelleFile", "fooFile");
- record.setValue("type", "fooType");
- record.setValue("speed", 2);
- /*-1 is set to indicate that it will be added to the last row*/
- if(sqlParcelleModel->insertRecord(-1, record)){
- qDebug()<<"successful insertion with value " << record.value("owner");
- sqlParcelleModel->submitAll();
- }
- qDebug() << "row count:" << sqlParcelleModel->rowCount();
- for(int i=0; i<10;i++) {
- qDebug() << "row: " << sqlParcelleModel->record(i).value("owner");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement