[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, 8 insertions, 12 deletions

diff --git a/internal/cache/size.go b/internal/cache/size.go
index ef9259f88..8a6c9e9ad 100644
--- a/internal/cache/size.go
+++ b/internal/cache/size.go
@@ -19,6 +19,7 @@ package cache
 
 import (
 	"crypto/rsa"
+	"regexp"
 	"strings"
 	"time"
 	"unsafe"
@@ -348,8 +349,6 @@ func sizeofEmojiCategory() uintptr {
 func sizeofFilter() uintptr {
 	return uintptr(size.Of(&gtsmodel.Filter{
 		ID:        exampleID,
-		CreatedAt: exampleTime,
-		UpdatedAt: exampleTime,
 		ExpiresAt: exampleTime,
 		AccountID: exampleID,
 		Title:     exampleTextSmall,
@@ -359,21 +358,18 @@ func sizeofFilter() uintptr {
 
 func sizeofFilterKeyword() uintptr {
 	return uintptr(size.Of(&gtsmodel.FilterKeyword{
-		ID:        exampleID,
-		CreatedAt: exampleTime,
-		UpdatedAt: exampleTime,
-		FilterID:  exampleID,
-		Keyword:   exampleTextSmall,
+		ID:       exampleID,
+		FilterID: exampleID,
+		Keyword:  exampleTextSmall,
+		Regexp:   regexp.MustCompile("^match (this)? .*"),
 	}))
 }
 
 func sizeofFilterStatus() uintptr {
 	return uintptr(size.Of(&gtsmodel.FilterStatus{
-		ID:        exampleID,
-		CreatedAt: exampleTime,
-		UpdatedAt: exampleTime,
-		FilterID:  exampleID,
-		StatusID:  exampleID,
+		ID:       exampleID,
+		FilterID: exampleID,
+		StatusID: exampleID,
 	}))
 }