Implement sender prefix storage in the database
authorJanne Koschinski <janne@kuschku.de>
Thu, 31 Aug 2017 23:11:50 +0000 (01:11 +0200)
committerManuel Nickschas <sputnick@quassel-irc.org>
Mon, 4 Sep 2017 20:40:50 +0000 (22:40 +0200)
commitdba66762993507168b1a3de25cfd2d7bff0ff969
treed1eac8383694260565a84a676b1b9b237a2e2d17
parentc4b49f3777a7b841ad4701e9c03a69dd1ffadc66
Implement sender prefix storage in the database

* When processing a new message, find the mode the user that
  sent this message has in a channel (for example o or hv)
* Convert it to a prefix (for example @ or +%)
* Store this in a new sendermode column in the backlog table

Schema for both SQLite and PostgreSQL is updated.
27 files changed:
src/common/message.cpp
src/common/message.h
src/common/network.h
src/core/SQL/PostgreSQL/insert_message.sql
src/core/SQL/PostgreSQL/migrate_write_backlog.sql
src/core/SQL/PostgreSQL/select_messagesAll.sql
src/core/SQL/PostgreSQL/select_messagesAllNew.sql
src/core/SQL/PostgreSQL/select_messagesNewerThan.sql
src/core/SQL/PostgreSQL/select_messagesNewestK.sql
src/core/SQL/PostgreSQL/select_messagesRange.sql
src/core/SQL/PostgreSQL/setup_060_backlog.sql
src/core/SQL/PostgreSQL/version/23/upgrade_000_create_mode.sql [new file with mode: 0644]
src/core/SQL/SQLite/insert_message.sql
src/core/SQL/SQLite/migrate_read_backlog.sql
src/core/SQL/SQLite/select_messagesAll.sql
src/core/SQL/SQLite/select_messagesAllNew.sql
src/core/SQL/SQLite/select_messagesNewerThan.sql
src/core/SQL/SQLite/select_messagesNewestK.sql
src/core/SQL/SQLite/select_messagesRange.sql
src/core/SQL/SQLite/setup_060_backlog.sql
src/core/SQL/SQLite/version/24/upgrade_000_create_mode.sql [new file with mode: 0644]
src/core/abstractsqlstorage.h
src/core/coresession.cpp
src/core/coresession.h
src/core/postgresqlstorage.cpp
src/core/sql.qrc
src/core/sqlitestorage.cpp