Advertisement
Guest User

Untitled

a guest
Oct 16th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. db = new DbManager();
  2. sqlParcelleModel = new QSqlTableModel(nullptr, db->getDB());
  3. sqlParcelleModel->setTable("Parcelle");
  4. qDebug() << "row count:" << sqlParcelleModel->rowCount();
  5.  
  6. /* sqlUserModel = new QSqlTableModel(nullptr, db->getDB());
  7. sqlUserModel->setTable("Person");
  8. sqlMissionModel = new QSqlTableModel(nullptr, db->getDB());
  9. sqlMissionModel->setTable("Mission");*/
  10.  
  11. QSqlRecord record = sqlParcelleModel->record();
  12.  
  13. record.setValue("owner", "foo");
  14. record.setValue("parcelleFile", "fooFile");
  15. record.setValue("type", "fooType");
  16. record.setValue("speed", 2);
  17. /*-1 is set to indicate that it will be added to the last row*/
  18. if(sqlParcelleModel->insertRecord(-1, record)){
  19. qDebug()<<"successful insertion with value " << record.value("owner");
  20. sqlParcelleModel->submitAll();
  21. }
  22. qDebug() << "row count:" << sqlParcelleModel->rowCount();
  23.  
  24. for(int i=0; i<10;i++) {
  25.  
  26. qDebug() << "row: " << sqlParcelleModel->record(i).value("owner");
  27.  
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement