Advertisement
TheNofx68

Database

Mar 21st, 2016
682
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  2.     db.setDatabaseName("./database.db");
  3.  
  4.     if (db.open()) {
  5.         std::cout << "You're now logged in. DBName: " << q2c(db.databaseName()) << std::endl;
  6.  
  7.         QSqlQuery query;
  8.         if (query.exec("select * from commands;")) {
  9.             while (query.next()) {
  10.                 std::cout << "Count: " << query.record().count() << std::endl;
  11.                 for (int x(0);x<query.record().count(); ++x) {
  12.                     std::cout << "\t#" << x << ": " << q2c(query.record().fieldName(x)) << ": " << q2c(query.record().value(x).toString()) << std::endl;
  13.                 }
  14.             }
  15.         } else {
  16.             std::cout << "Query error. Last error: " << std::endl << q2c(query.lastError().text()) << std::endl;
  17.             db.close();
  18.             exit(1);
  19.         }
  20.  
  21.         db.close();
  22.     } else {
  23.         std::cout << "Connection failed. Last error: " << std::endl << q2c(db.lastError().text()) << std::endl;
  24.         exit(1);
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement