X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.cpp;h=86bf9881877f829ac428052c85a0b2c01437d4b1;hp=7ee2e5651cd3a7eda2e06477559de61b8aa25fdc;hb=48151f63e7f953bf07828be39ba314095c472c74;hpb=0ac9ce4d7cf768d13993d6aa1d6b791c4149a843 diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index 7ee2e565..86bf9881 100644 --- a/src/core/sqlitestorage.cpp +++ b/src/core/sqlitestorage.cpp @@ -109,6 +109,7 @@ SqliteStorage::SqliteStorage() { } SqliteStorage::~SqliteStorage() { + //logDb.close(); delete logMessageQuery; delete addSenderQuery; delete getLastMessageIdQuery; @@ -201,13 +202,15 @@ UserId SqliteStorage::addUser(QString user, QString password) { query.exec(); if(query.lastError().isValid() && query.lastError().number() == 19) { // user already exists - sadly 19 seems to be the general constraint violation error... return 0; - } + } query.prepare("SELECT userid FROM quasseluser WHERE username = :username"); query.bindValue(":username", user); query.exec(); query.first(); - return query.value(0).toUInt(); + UserId uid = query.value(0).toUInt(); + emit userAdded(uid, user); + return uid; } void SqliteStorage::updateUser(UserId user, QString password) { @@ -221,6 +224,15 @@ void SqliteStorage::updateUser(UserId user, QString password) { query.exec(); } +void SqliteStorage::renameUser(UserId user, QString newName) { + QSqlQuery query(logDb); + query.prepare("UPDATE quasseluser SET username = :username WHERE userid = :userid"); + query.bindValue(":userid", user); + query.bindValue(":username", newName); + query.exec(); + emit userRenamed(user, newName); +} + UserId SqliteStorage::validateUser(QString user, QString password) { QByteArray cryptopass = QCryptographicHash::hash(password.toUtf8(), QCryptographicHash::Sha1); cryptopass = cryptopass.toHex(); @@ -257,6 +269,7 @@ void SqliteStorage::delUser(UserId user) { query.bindValue(":userid", user); query.exec(); // I hate the lack of foreign keys and on delete cascade... :( + emit userRemoved(user); } void SqliteStorage::createBuffer(UserId user, QString network, QString buffer) {