X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.h;h=9aa70066d2aa87663f5fd5525a9ffa70cc5ad1a4;hp=a710b630eafd4088b14bf02e3473dc011b83a739;hb=393ac8b4bca9db98f297cb4756ef2e79364bf6f0;hpb=ef1ee865c342a16daab514a99110f56150ea95e7 diff --git a/src/core/sqlitestorage.h b/src/core/sqlitestorage.h index a710b630..9aa70066 100644 --- a/src/core/sqlitestorage.h +++ b/src/core/sqlitestorage.h @@ -1,5 +1,5 @@ /*************************************************************************** - * Copyright (C) 2005-08 by the Quassel Project * + * Copyright (C) 2005-09 by the Quassel Project * * devel@quassel-irc.org * * * * This program is free software; you can redistribute it and/or modify * @@ -34,23 +34,36 @@ public: SqliteStorage(QObject *parent = 0); virtual ~SqliteStorage(); + virtual AbstractSqlMigrationReader *createMigrationReader(); + public slots: /* General */ - + bool isAvailable() const; QString displayName() const; + virtual inline QStringList setupKeys() const { return QStringList(); } + virtual inline QVariantMap setupDefaults() const { return QVariantMap(); } 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 bool 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 getUserId(const QString &username); + 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()); + + /* Identity handling */ + virtual IdentityId createIdentity(UserId user, CoreIdentity &identity); + virtual bool updateIdentity(UserId user, const CoreIdentity &identity); + virtual void removeIdentity(UserId user, IdentityId identityId); + virtual QList identities(UserId user); + /* Network handling */ virtual NetworkId createNetwork(UserId user, const NetworkInfo &info); virtual bool updateNetwork(UserId user, const NetworkInfo &info); @@ -63,36 +76,88 @@ public slots: 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); - + + /* persistent user states */ + virtual QString awayMessage(UserId user, NetworkId networkId); + virtual void setAwayMessage(UserId user, NetworkId networkId, const QString &awayMsg); + virtual QString userModes(UserId user, NetworkId networkId); + virtual void setUserModes(UserId user, NetworkId networkId, const QString &userModes); + /* Buffer handling */ - virtual BufferInfo getBufferInfo(UserId user, const NetworkId &networkId, BufferInfo::Type type, const QString &buffer = ""); + virtual BufferInfo bufferInfo(UserId user, const NetworkId &networkId, BufferInfo::Type type, const QString &buffer = "", bool create = true); virtual BufferInfo getBufferInfo(UserId user, const BufferId &bufferId); - virtual QList requestBuffers(UserId user, QDateTime since = QDateTime()); + 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 setBufferLastSeen(UserId user, const BufferId &bufferId, const QDateTime &seenDate); - virtual QHash bufferLastSeenDates(UserId user); - + virtual bool renameBuffer(const UserId &user, const BufferId &bufferId, const QString &newName); + virtual bool mergeBuffersPermanently(const UserId &user, const BufferId &bufferId1, const BufferId &bufferId2); + virtual void setBufferLastSeenMsg(UserId user, const BufferId &bufferId, const MsgId &msgId); + virtual QHash bufferLastSeenMsgIds(UserId user); + virtual void setBufferMarkerLineMsg(UserId user, const BufferId &bufferId, const MsgId &msgId); + virtual QHash bufferMarkerLineMsgIds(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); + virtual bool logMessage(Message &msg); + virtual bool logMessages(MessageList &msgs); + virtual QList requestMsgs(UserId user, BufferId bufferId, MsgId first = -1, MsgId last = -1, int limit = -1); + virtual QList requestAllMsgs(UserId user, MsgId first = -1, MsgId last = -1, int limit = -1); protected: + inline virtual void setConnectionProperties(const QVariantMap & /* properties */) {} inline virtual QString driverName() { return "QSQLITE"; } inline virtual QString databaseName() { return backlogFile(); } virtual int installedSchemaVersion(); + virtual bool updateSchemaVersion(int newVersion); + virtual bool setupSchemaVersion(int version); + bool safeExec(QSqlQuery &query, int retryCount = 0); - 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); + void bindNetworkInfo(QSqlQuery &query, const NetworkInfo &info); + void bindServerInfo(QSqlQuery &query, const Network::Server &server); + + inline void lockForRead() { _dbLock.lockForRead(); } + inline void lockForWrite() { _dbLock.lockForWrite(); } + inline void unlock() { _dbLock.unlock(); } + QReadWriteLock _dbLock; + static int _maxRetryCount; +}; + +// ======================================== +// SqliteMigration +// ======================================== +class SqliteMigrationReader : public SqliteStorage, public AbstractSqlMigrationReader { + Q_OBJECT + +public: + SqliteMigrationReader(); + + virtual bool readMo(QuasselUserMO &user); + virtual bool readMo(SenderMO &sender); + virtual bool readMo(IdentityMO &identity); + virtual bool readMo(IdentityNickMO &identityNick); + virtual bool readMo(NetworkMO &network); + virtual bool readMo(BufferMO &buffer); + virtual bool readMo(BacklogMO &backlog); + virtual bool readMo(IrcServerMO &ircserver); + virtual bool readMo(UserSettingMO &userSetting); + + virtual bool prepareQuery(MigrationObject mo); + + inline int stepSize() { return 50000; } + +protected: + virtual inline bool transaction() { return logDb().transaction(); } + virtual inline void rollback() { logDb().rollback(); } + virtual inline bool commit() { return logDb().commit(); } + +private: + void setMaxId(MigrationObject mo); + int _maxId; }; +inline AbstractSqlMigrationReader *SqliteStorage::createMigrationReader() { + return new SqliteMigrationReader(); +} + #endif