X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.h;h=9df9be340a328ede5e9ffc6df48263f97f168e27;hp=393050b5c4c86a2057e0d69be15884684c109b15;hb=26b9300ccab24e526a9f43bef95a2a70f59161df;hpb=0ac9ce4d7cf768d13993d6aa1d6b791c4149a843 diff --git a/src/core/sqlitestorage.h b/src/core/sqlitestorage.h index 393050b5..9df9be34 100644 --- a/src/core/sqlitestorage.h +++ b/src/core/sqlitestorage.h @@ -1,11 +1,11 @@ /*************************************************************************** - * Copyright (C) 2005-07 by The Quassel Team * + * Copyright (C) 2005-08 by the Quassel Project * * devel@quassel-irc.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * * the Free Software Foundation; either version 2 of the License, or * - * (at your option) any later version. * + * (at your option) version 3. * * * * This program is distributed in the hope that it will be useful, * * but WITHOUT ANY WARRANTY; without even the implied warranty of * @@ -18,79 +18,87 @@ * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. * ***************************************************************************/ -#ifndef _SQLITESTORAGE_H_ -#define _SQLITESTORAGE_H_ +#ifndef SQLITESTORAGE_H +#define SQLITESTORAGE_H -#include +#include "abstractsqlstorage.h" -#include "global.h" -#include "storage.h" +#include class QSqlQuery; -class SqliteStorage : public Storage { +class SqliteStorage : public AbstractSqlStorage { Q_OBJECT - public: - SqliteStorage(); - virtual ~SqliteStorage(); - - static void init(); - - /* General */ - - static bool isAvailable(); - static QString displayName(); - - // TODO: Add functions for configuring the backlog handling, i.e. defining auto-cleanup settings etc - - /* User handling */ - - virtual UserId addUser(QString user, QString password); - virtual void updateUser(UserId user, QString password); - virtual UserId validateUser(QString user, QString password); - virtual void delUser(UserId user); - - /* Buffer handling */ - - virtual BufferId getBufferId(UserId user, QString network, QString buffer = ""); - virtual QList requestBuffers(UserId user, QDateTime since = QDateTime()); - - /* Message handling */ - - virtual MsgId logMessage(Message msg); - virtual QList requestMsgs(BufferId buffer, int lastmsgs = -1, int offset = -1); - virtual QList requestMsgs(BufferId buffer, QDateTime since, int offset = -1); - virtual QList requestMsgRange(BufferId buffer, int first, int last); - - public slots: - //! This is just for importing the old file-based backlog */ - /** This slot needs to be implemented in the storage backends. - * It should first prepare (delete?) the database, then call initBackLogOld(UserId id). - * If the importing was successful, backLogEnabledOld will be true afterwards. - */ - void importOldBacklog(); - - signals: - void bufferIdUpdated(BufferId); - - protected: - - private: - void initDb(); - void createBuffer(UserId user, QString network, QString buffer); - QSqlQuery *logMessageQuery; - QSqlQuery *addSenderQuery; - QSqlQuery *getLastMessageIdQuery; - QSqlQuery *requestMsgsQuery; - QSqlQuery *requestMsgsOffsetQuery; - QSqlQuery *requestMsgsSinceQuery; - QSqlQuery *requestMsgsSinceOffsetQuery; - QSqlQuery *requestMsgRangeQuery; - QSqlQuery *createNetworkQuery; - QSqlQuery *createBufferQuery; - QSqlQuery *getBufferIdQuery; +public: + SqliteStorage(QObject *parent = 0); + virtual ~SqliteStorage(); + +public slots: + /* General */ + + bool isAvailable() const; + QString displayName() const; + QString description() const; + + // TODO: Add functions for configuring the backlog handling, i.e. defining auto-cleanup settings etc + + /* User handling */ + + virtual UserId addUser(const QString &user, const QString &password); + virtual void updateUser(UserId user, const QString &password); + virtual void renameUser(UserId user, const QString &newName); + virtual UserId validateUser(const QString &user, const QString &password); + virtual UserId internalUser(); + virtual void delUser(UserId user); + virtual void setUserSetting(UserId userId, const QString &settingName, const QVariant &data); + virtual QVariant getUserSetting(UserId userId, const QString &settingName, const QVariant &defaultData = QVariant()); + + + /* Network handling */ + virtual NetworkId createNetwork(UserId user, const NetworkInfo &info); + virtual bool updateNetwork(UserId user, const NetworkInfo &info); + virtual bool removeNetwork(UserId user, const NetworkId &networkId); + virtual QList networks(UserId user); + virtual QList connectedNetworks(UserId user); + virtual void setNetworkConnected(UserId user, const NetworkId &networkId, bool isConnected); + + /* persistent channels */ + virtual QHash persistentChannels(UserId user, const NetworkId &networkId); + virtual void setChannelPersistent(UserId user, const NetworkId &networkId, const QString &channel, bool isJoined); + virtual void setPersistentChannelKey(UserId user, const NetworkId &networkId, const QString &channel, const QString &key); + + /* Buffer handling */ + virtual BufferInfo getBufferInfo(UserId user, const NetworkId &networkId, BufferInfo::Type type, const QString &buffer = ""); + virtual BufferInfo getBufferInfo(UserId user, const BufferId &bufferId); + virtual QList requestBuffers(UserId user); + virtual QList requestBufferIdsForNetwork(UserId user, NetworkId networkId); + virtual bool removeBuffer(const UserId &user, const BufferId &bufferId); + virtual BufferId renameBuffer(const UserId &user, const NetworkId &networkId, const QString &newName, const QString &oldName); + virtual void setBufferLastSeenMsg(UserId user, const BufferId &bufferId, const MsgId &msgId); + virtual QHash bufferLastSeenMsgIds(UserId user); + + /* Message handling */ + + virtual MsgId logMessage(Message msg); + virtual QList requestMsgs(UserId user, BufferId bufferId, int limit = -1, int offset = -1); + virtual QList requestMsgs(UserId user, BufferId bufferId, QDateTime since, int offset = -1); + virtual QList requestMsgRange(UserId user, BufferId bufferId, int first, int last); + +protected: + inline virtual QString driverName() { return "QSQLITE"; } + inline virtual QString databaseName() { return backlogFile(); } + virtual int installedSchemaVersion(); + bool safeExec(QSqlQuery &query, int retryCount = 0); + +private: + static QString backlogFile(); + bool isValidNetwork(UserId user, const NetworkId &networkId); + bool isValidBuffer(const UserId &user, const BufferId &bufferId); + NetworkId getNetworkId(UserId user, const QString &network); + void createBuffer(UserId user, const NetworkId &networkId, BufferInfo::Type type, const QString &buffer); + + static int _maxRetryCount; }; - #endif