From: Marcus Eggenberger Date: Fri, 21 Nov 2008 00:48:02 +0000 (+0100) Subject: removing very old migration code X-Git-Tag: 0.4.0~415 X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=4fef2ef49965b4e89a25e8cdc33100d9717d1aa8 removing very old migration code --- diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index eb6b3d88..613fa32d 100644 --- a/src/core/sqlitestorage.cpp +++ b/src/core/sqlitestorage.cpp @@ -798,51 +798,3 @@ QList SqliteStorage::requestMsgRange(UserId user, BufferId bufferId, in QString SqliteStorage::backlogFile() { return quasselDir().absolutePath() + "/quassel-storage.sqlite"; } - - -// ONLY NEEDED FOR MIGRATION -bool SqliteStorage::init(const QVariantMap &settings) { - if(!AbstractSqlStorage::init(settings)) - return false; - - QSqlQuery checkMigratedQuery(logDb()); - checkMigratedQuery.prepare("SELECT DISTINCT typeOf(password) FROM quasseluser"); - checkMigratedQuery.exec(); - if(!watchQuery(checkMigratedQuery)) - return false; - - if(!checkMigratedQuery.first()) - return true; // table is empty -> no work to be done - - QString passType = checkMigratedQuery.value(0).toString().toLower(); - if(passType == "text") - return true; // allready migrated - - Q_ASSERT(passType == "blob"); - - QSqlQuery getPasswordsQuery(logDb()); - getPasswordsQuery.prepare("SELECT userid, password FROM quasseluser"); - getPasswordsQuery.exec(); - - if(!watchQuery(getPasswordsQuery)) { - qCritical() << "unable to migrate to new password format!"; - return false; - } - - QHash passHash; - while(getPasswordsQuery.next()) { - passHash[getPasswordsQuery.value(0).toInt()] = getPasswordsQuery.value(1).toByteArray(); - } - - QSqlQuery setPasswordsQuery(logDb()); - setPasswordsQuery.prepare("UPDATE quasseluser SET password = :password WHERE userid = :userid"); - foreach(int userId, passHash.keys()) { - setPasswordsQuery.bindValue(":password", QString(passHash[userId])); - setPasswordsQuery.bindValue(":userid", userId); - setPasswordsQuery.exec(); - watchQuery(setPasswordsQuery); - } - - qDebug() << "successfully migrated passwords!"; - return true; -} diff --git a/src/core/sqlitestorage.h b/src/core/sqlitestorage.h index 4b49d417..45f1c468 100644 --- a/src/core/sqlitestorage.h +++ b/src/core/sqlitestorage.h @@ -89,8 +89,6 @@ protected: inline virtual QString driverName() { return "QSQLITE"; } inline virtual QString databaseName() { return backlogFile(); } virtual int installedSchemaVersion(); - - virtual bool init(const QVariantMap &settings = QVariantMap()); // only needed for migration private: static QString backlogFile();