X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.h;h=944c46b4c8fcb416f44cc6f90f9452356499d162;hp=40c23a6c8ad3a42e25ae303e9e3e273e3151abc9;hb=4ed404c7a72dd21bb06b003274ae544ab5ca1ad7;hpb=d6b056e936ec441258d291b7a8af7b83f9f53016 diff --git a/src/core/sqlitestorage.h b/src/core/sqlitestorage.h index 40c23a6c..944c46b4 100644 --- a/src/core/sqlitestorage.h +++ b/src/core/sqlitestorage.h @@ -1,5 +1,5 @@ /*************************************************************************** - * Copyright (C) 2005-07 by the Quassel IRC 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 * @@ -18,77 +18,74 @@ * 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 "storage.h" +#include class QSqlQuery; -class SqliteStorage : public Storage { +class SqliteStorage : public AbstractSqlStorage { Q_OBJECT - public: - SqliteStorage(); - virtual ~SqliteStorage(); - - /* General */ - - static bool isAvailable(); - static QString displayName(); - virtual bool setup(const QVariantMap &settings = QVariantMap()); - virtual bool init(const QVariantMap &settings = QVariantMap()); - - // 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 void delUser(UserId user); - - /* Network handling */ - virtual uint getNetworkId(UserId user, const QString &network); - - /* Buffer handling */ - virtual BufferInfo getBufferInfo(UserId user, const QString &network, const QString &buffer = ""); - virtual QList requestBuffers(UserId user, QDateTime since = QDateTime()); - - /* Message handling */ - - virtual MsgId logMessage(Message msg); - virtual QList requestMsgs(BufferInfo buffer, int lastmsgs = -1, int offset = -1); - virtual QList requestMsgs(BufferInfo buffer, QDateTime since, int offset = -1); - virtual QList requestMsgRange(BufferInfo buffer, int first, int last); - - signals: - void bufferInfoUpdated(BufferInfo); - - protected: - - private: - static QString backlogFile(bool createPath = false); - - void createBuffer(UserId user, const QString &network, const QString &buffer); - bool watchQuery(QSqlQuery *query); - - QSqlDatabase logDb; - - QSqlQuery *logMessageQuery; - QSqlQuery *addSenderQuery; - QSqlQuery *getLastMessageIdQuery; - QSqlQuery *requestMsgsQuery; - QSqlQuery *requestMsgsOffsetQuery; - QSqlQuery *requestMsgsSinceQuery; - QSqlQuery *requestMsgsSinceOffsetQuery; - QSqlQuery *requestMsgRangeQuery; - QSqlQuery *createNetworkQuery; - QSqlQuery *createBufferQuery; - QSqlQuery *getBufferInfoQuery; +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 void delUser(UserId user); + + /* 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); + + /* 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, QDateTime since = QDateTime()); + 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 setBufferLastSeen(UserId user, const BufferId &bufferId, const QDateTime &seenDate); + virtual QHash bufferLastSeenDates(UserId user); + + /* Message handling */ + + virtual MsgId logMessage(Message msg); + virtual QList requestMsgs(BufferInfo buffer, int lastmsgs = -1, int offset = -1); + virtual QList requestMsgs(BufferInfo buffer, QDateTime since, int offset = -1); + virtual QList requestMsgRange(BufferInfo buffer, int first, int last); + +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(); + 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); }; #endif