DatabaseThread::DatabaseThread( const QString &fileName )
: QObject()
, mpSqlDB( 0 )
, mpQuery( 0 )
, mpCommitTimer( 0 )
, mpSatellite( 0 )
, mDatabaseVersion( 0 )
, mCodeVersion( 1 )
, mUpdateCount( 0 )
, mUpdateMessage()
, mNotifyDisabled( false )
{
setObjectName( "DatabaseThread" );
qsrand( time((time_t*)0) );
mpSqlDB = new QSqlDatabase( QSqlDatabase::addDatabase( "QSQLITE" ) );
mpCommitTimer = new QTimer( this );
mpCommitTimer->setSingleShot( true );
mpCommitTimer->setInterval( 250 );
connect( mpCommitTimer, SIGNAL(timeout()),
this, SLOT(commit()) );
qRegisterMetaType<TrackInfo>( "TrackInfo" );
qRegisterMetaType<TrackInfoList>( "TrackInfoList" );
if( mpSqlDB->lastError().type() != QSqlError::NoError )
{
QMessageBox::critical( 0, QApplication::applicationName() + ": " + QWidget::tr("Error"),
QWidget::tr("Could not open database.\nPlease make sure that the SQLite driver for Qt is installed.") );
exit(1);
}
if( fileName.isEmpty() )
{
mpSqlDB->setDatabaseName( getDatabaseFileName() );
}
else
{
mpSqlDB->setDatabaseName( fileName );
}
if(!mpSqlDB->open())
{
// \todo: some error handling
logError( QString("open() failed\nDatabase: ") + mpSqlDB->lastError().driverText() );
}
mpQuery = new QSqlQuery;
if( mpQuery->exec( "SELECT value FROM slart_config WHERE key = 'Version';" ) )
{
if( mpQuery->next() )
{
mDatabaseVersion = mpQuery->value(0).toUInt();
}
}
else
{
logError();
}
mpQuery->clear();
if( !mDatabaseVersion )
{
/* create database */
QStringList initSQL;
initSQL
<< "CREATE TABLE slart_config (key VARCHAR PRIMARY KEY,"
"value VARCHAR);"
<< "INSERT OR REPLACE INTO slart_config(key,value) VALUES ('Version'," +
QString::number(mCodeVersion) + ");"
<< "CREATE TABLE slart_tracks (id INTEGER PRIMARY KEY,"
"Directory VARCHAR,"
"FileName VARCHAR,"
"Artist VARCHAR,"
"Title VARCHAR,"
"Album VARCHAR,"
"TrackNr INTEGER,"
"Year INTEGER,"
"Genre VARCHAR,"
"PlayTime INTEGER,"
"LastScanned INTEGER,"
"LastTagsRead INTEGER,"
"TimesPlayed INTEGER,"
"Volume DOUBLE,"
"Folders VARCHAR,"
"Flags INTEGER);"
<< "CREATE UNIQUE INDEX slart_tracks_file ON slart_tracks (Directory,FileName);"
<< "CREATE INDEX slart_tracks_filename ON slart_tracks (FileName);"
<< "CREATE INDEX slart_tracks_artist ON slart_tracks (Artist);"
<< "CREATE INDEX slart_tracks_title ON slart_tracks (Title);"
<< "CREATE TABLE slart_folders (id INTEGER PRIMARY KEY,"
"Name VARCHAR,"
"FileName VARCHAR);"
<< "CREATE UNIQUE INDEX slart_folders_name ON slart_folders (Name);"
;
foreach( const QString &statement, initSQL )
{
if( !mpQuery->exec( statement ) )
{
logError();
}
mpQuery->clear();
}
}
PwDatabaseV3::ErrorCode PwDatabaseV3::readContent(QDataStream& stream) {
setPhaseProgressRawTarget(header.getGroupCount() + header.getEntryCount());
QList<PwGroupV3*> groups;
ErrorCode err = readAllGroups(stream, groups);
if (err != SUCCESS)
return err;
QList<PwEntryV3*> entries;
err = readAllEntries(stream, entries);
if (err != SUCCESS)
return err;
// make a group-by-ID lookup hashtable;
// also find the maximum group level
int maxLevel = 0;
quint16 level;
PwGroupV3* group;
QHash<qint32, PwGroupV3*> groupById;
for (int i = 0; i < groups.size(); i++) {
group = groups.at(i);
groupById.insert(group->getId(), group);
level = group->getLevel();
if (level > maxLevel)
maxLevel = level;
}
// restore group hierarchy
PwGroupV3* rootGroupV3 = new PwGroupV3();
rootGroupV3->setDatabase(this);
rootGroupV3->setLevel(-1); // because its children should have level 0
rootGroupV3->setIconId(PwGroup::DEFAULT_ICON_ID); // created subgroups will use this icon
// give the "virtual" root group some meaningful name
rootGroupV3->setName(getDatabaseFileName());
_rootGroup = rootGroupV3;
PwGroupV3* parentGroup = (PwGroupV3*)_rootGroup;
for (quint16 level = 0; level <= maxLevel; level++) {
quint16 prevLevel = level - 1;
for (int i = 0; i < groups.size(); i++) {
PwGroupV3* group = groups.at(i);
quint16 curLevel = group->getLevel();
if (curLevel == level) {
parentGroup->addSubGroup(group);
} else if (curLevel == prevLevel) {
parentGroup = group;
}
}
}
// put entries to their groups
PwEntryV3* entry;
for (int i = 0; i < entries.size(); i++) {
entry = entries.at(i);
if (entry->isMetaStream()) {
// meta streams are kept in their own list, invisibly for the user
metaStreamEntries.append(entry);
} else {
qint32 groupId = entry->getGroupId();
if (!groupById.contains(groupId)) {
LOG("There is an entry %s with unknown groupId: %d", entry->toString().toUtf8().constData(), groupId);
return ORPHANED_ENTRY_ERROR;
}
PwGroupV3* group = groupById.value(groupId);
entry->setDeleted(group->isDeleted());
group->addEntry(entry);
}
}
return SUCCESS;
}
void PwDatabase::setDatabaseFilePath(const QString& dbFilePath) {
if (dbFilePath != this->_dbFilePath) {
this->_dbFilePath = dbFilePath;
emit dbFileNameChanged(getDatabaseFileName());
}
}
