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;
}
}
