X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fpostgresqlstorage.h;h=5b6a196fb6ad84ce72cb1d66b25a8c861b28812c;hp=f699ca11b94f6e34e3f4007f0c54cf8b3ef886df;hb=d60c5028b49a95d3c27c35b2ea1d74cdd7bb0e46;hpb=b9828e0dd235964b8e2e97f844f4bed3476d3bd4 diff --git a/src/core/postgresqlstorage.h b/src/core/postgresqlstorage.h index f699ca11..5b6a196f 100644 --- a/src/core/postgresqlstorage.h +++ b/src/core/postgresqlstorage.h @@ -33,22 +33,25 @@ public: PostgreSqlStorage(QObject *parent = 0); virtual ~PostgreSqlStorage(); + virtual AbstractSqlMigrationWriter *createMigrationWriter(); + public slots: /* General */ - - bool isAvailable() const; - QString displayName() const; - QString description() const; - QVariantMap setupKeys() const; + virtual bool isAvailable() const; + virtual QString displayName() const; + virtual QString description() const; + virtual QStringList setupKeys() const; + virtual QVariantMap setupDefaults() 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); @@ -89,6 +92,8 @@ public slots: 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 bool logMessage(Message &msg); @@ -97,6 +102,7 @@ public slots: virtual QList requestAllMsgs(UserId user, MsgId first = -1, MsgId last = -1, int limit = -1); protected: + virtual void initDbSession(QSqlDatabase &db); virtual void setConnectionProperties(const QVariantMap &properties); inline virtual QString driverName() { return "QPSQL"; } inline virtual QString hostName() { return _hostName; } @@ -130,8 +136,6 @@ private: QString _userName; QString _password; - static int _maxRetryCount; - typedef QHash QueryHash; QHash _preparedQueries; // one query hash per db connection QMutex _queryHashMutex; @@ -140,4 +144,44 @@ private: inline void PostgreSqlStorage::safeExec(QSqlQuery &query) { query.exec(); } + +// ======================================== +// PostgreSqlMigration +// ======================================== +class PostgreSqlMigrationWriter : public PostgreSqlStorage, public AbstractSqlMigrationWriter { + Q_OBJECT + +public: + PostgreSqlMigrationWriter(); + + virtual bool writeMo(const QuasselUserMO &user); + virtual bool writeMo(const SenderMO &sender); + virtual bool writeMo(const IdentityMO &identity); + virtual bool writeMo(const IdentityNickMO &identityNick); + virtual bool writeMo(const NetworkMO &network); + virtual bool writeMo(const BufferMO &buffer); + virtual bool writeMo(const BacklogMO &backlog); + virtual bool writeMo(const IrcServerMO &ircserver); + virtual bool writeMo(const UserSettingMO &userSetting); + + bool prepareQuery(MigrationObject mo); + + virtual bool postProcess(); + +protected: + virtual inline bool transaction() { return logDb().transaction(); } + virtual inline void rollback() { logDb().rollback(); } + virtual inline bool commit() { return logDb().commit(); } + +private: + // helper struct + struct Sequence { + QLatin1String table; + QLatin1String field; + Sequence(const char *table, const char *field) : table(table), field(field) {} + }; + + QSet _validIdentities; +}; + #endif