From efc97aa2b0d7a4d63a2e6219070919559a0cf64d Mon Sep 17 00:00:00 2001 From: ouwou <26526779+ouwou@users.noreply.github.com> Date: Thu, 10 Jun 2021 15:27:32 -0400 Subject: reduce db access + refactor --- discord/store.hpp | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'discord/store.hpp') diff --git a/discord/store.hpp b/discord/store.hpp index e3713eb..1e0b4c7 100644 --- a/discord/store.hpp +++ b/discord/store.hpp @@ -41,6 +41,9 @@ public: std::optional GetBan(Snowflake guild_id, Snowflake user_id) const; std::vector GetBans(Snowflake guild_id) const; + std::vector GetLastMessages(Snowflake id, size_t num) const; + std::vector GetChannelMessageIDs(Snowflake id) const; + void ClearGuild(Snowflake id); void ClearChannel(Snowflake id); void ClearBan(Snowflake guild_id, Snowflake user_id); @@ -63,6 +66,8 @@ public: void EndTransaction(); private: + Message GetMessageBound(sqlite3_stmt *stmt) const; + void SetMessageInteractionPair(Snowflake message_id, const MessageInteractionData &interaction); std::unordered_set m_channels; @@ -126,6 +131,8 @@ private: mutable sqlite3_stmt *m_clear_ban_stmt; mutable sqlite3_stmt *m_get_bans_stmt; mutable sqlite3_stmt *m_set_msg_interaction_stmt; + mutable sqlite3_stmt *m_get_last_msgs_stmt; + mutable sqlite3_stmt *m_get_msg_ids_stmt; }; template -- cgit v1.2.3