[performance] filter model and database table improvements (#4277)

- removes unnecessary fields / columns (created_at, updated_at)
- replaces filter.context_* columns with singular filter.contexts bit field which should save both struct memory and database space
- replaces filter.action string with integer enum type which should save both struct memory and database space
- adds links from filter to filter_* tables with Filter{}.KeywordIDs and Filter{}.StatusIDs fields (this also means we now have those ID slices cached, which reduces some lookups)
- removes account_id fields from filter_* tables, since there's a more direct connection between filter and filter_* tables, and filter.account_id already exists
- refactors a bunch of the filter processor logic to save on code repetition, factor in the above changes, fix a few bugs with missed error returns and bring it more in-line with some of our newer code

Reviewed-on: https://codeberg.org/superseriousbusiness/gotosocial/pulls/4277
Co-authored-by: kim <grufwub@gmail.com>
Co-committed-by: kim <grufwub@gmail.com>

1 files changed, 23 insertions, 0 deletions

diff --git a/internal/cache/invalidate.go b/internal/cache/invalidate.go
index 88b7415ae..4941b2540 100644
--- a/internal/cache/invalidate.go
+++ b/internal/cache/invalidate.go
@@ -112,6 +112,29 @@ func (c *Caches) OnInvalidateEmojiCategory(category *gtsmodel.EmojiCategory) {
 	c.DB.Emoji.Invalidate("CategoryID", category.ID)
 }
 
+func (c *Caches) OnInvalidateFilter(filter *gtsmodel.Filter) {
+	// Invalidate list of filters for account.
+	c.DB.FilterIDs.Invalidate(filter.AccountID)
+
+	// Invalidate all associated keywords and statuses.
+	c.DB.FilterKeyword.InvalidateIDs("ID", filter.KeywordIDs)
+	c.DB.FilterStatus.InvalidateIDs("ID", filter.StatusIDs)
+
+	// Invalidate account's timelines (in case local).
+	c.Timelines.Home.Unprepare(filter.AccountID)
+	c.Timelines.List.Unprepare(filter.AccountID)
+}
+
+func (c *Caches) OnInvalidateFilterKeyword(filterKeyword *gtsmodel.FilterKeyword) {
+	// Invalidate filter that keyword associated with.
+	c.DB.Filter.Invalidate("ID", filterKeyword.FilterID)
+}
+
+func (c *Caches) OnInvalidateFilterStatus(filterStatus *gtsmodel.FilterStatus) {
+	// Invalidate filter that status associated with.
+	c.DB.Filter.Invalidate("ID", filterStatus.FilterID)
+}
+
 func (c *Caches) OnInvalidateFollow(follow *gtsmodel.Follow) {
 	// Invalidate follow request with this same ID.
 	c.DB.FollowRequest.Invalidate("ID", follow.ID)