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);
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<BufferId, MsgId> bufferLastSeenMsgIds(UserId user);
+ virtual void setBufferMarkerLineMsg(UserId user, const BufferId &bufferId, const MsgId &msgId);
+ virtual QHash<BufferId, MsgId> bufferMarkerLineMsgIds(UserId user);
/* Message handling */
virtual bool logMessage(Message &msg);
virtual QList<Message> 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; }
public:
PostgreSqlMigrationWriter();
-
-// virtual bool writeUser(const QuasselUserMO &user);
-// virtual bool writeSender(const SenderMO &sender);
-// virtual bool writeIdentity(const IdentityMO &identity);
-// virtual bool writeIdentityNick(const IdentityNickMO &identityNick);
-// virtual bool writeNetwork(const NetworkMO &network);
-// virtual bool writeBuffer(const BufferMO &buffer);
-// virtual bool writeBacklog(const BacklogMO &backlog);
-// virtual bool writeIrcServer(const IrcServerMO &ircserver);
-// virtual bool writeUserSetting(const UserSettingMO &userSetting);
virtual bool writeMo(const QuasselUserMO &user);
virtual bool writeMo(const SenderMO &sender);
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<int> _validIdentities;
};
#endif