QString database::dbPrivate::baseRecord::selectStr() { QString queryS("SELECT id"); for(constEntryIter i= entries.constBegin(); i!=entries.constEnd(); i++) { QString s=i.value()->name(); if(s.isEmpty() ) { setError("Unkown entry name"); return QString(); } queryS.append(","+s); } queryS.append(" FROM "+table()); return queryS; }
bool connectToDB() { Static = QSqlDatabase::addDatabase("QSQLITE", "Static"); Dynamic = QSqlDatabase::addDatabase("QSQLITE", "Dynamic"); Static.setDatabaseName(staticdatabase);// WHERE TO STORE THE FILES Dynamic.setDatabaseName(dynamicdatabase); if (!Static.open() || !Dynamic.open() ) { // CHECK IF IT OPEN return false; } else { QSqlQuery queryS(Static); if( queryS.exec("SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY 1") ) { qDebug() << "game.db already contains: "; while(queryS.next()) { qDebug() << queryS.record().field("name").value().toString(); } } else { qDebug() << queryS.lastError().databaseText(); } QSqlQuery queryD(Dynamic); if( queryD.exec("SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY 1") ) { qDebug() << "saveData.db already contains: "; while(queryD.next()) { qDebug() << queryD.record().field("name").value().toString(); } } else { qDebug() << queryS.lastError().databaseText(); } return true; } }