[chore] Update bun / sqlite versions; update gtsmodels (#754)

* upstep bun and sqlite versions

* allow specific columns to be updated in the db

* only update necessary columns for user

* bit tidier

* only update necessary fields of media_attachment

* only update relevant instance fields

* update tests

* update only specific account columns

* use bool pointers on gtsmodels
includes attachment, status, account, user

* update columns more selectively

* test all default fields on new account insert

* updating remaining bools on gtsmodels

* initialize pointer fields when extracting AP emoji

* copy bools properly

* add copyBoolPtr convenience function + test it

* initialize false bool ptrs a bit more neatly

1 files changed, 220 insertions, 191 deletions

diff --git a/testrig/testmodels.go b/testrig/testmodels.go
index 3a231bfeb..223d9d5ed 100644
--- a/testrig/testmodels.go
+++ b/testrig/testmodels.go
@@ -43,6 +43,18 @@ import (
 	"github.com/superseriousbusiness/gotosocial/internal/transport"
 )
 
+// TrueBool just returns a pointer to boolean true.
+func TrueBool() *bool {
+	b := new(bool)
+	*b = true
+	return b
+}
+
+// FalseBool just returns a pointer to boolean false.
+func FalseBool() *bool {
+	return new(bool)
+}
+
 // NewTestTokens returns a map of tokens keyed according to which account the token belongs to.
 func NewTestTokens() map[string]*gtsmodel.Token {
 	tokens := map[string]*gtsmodel.Token{
@@ -182,10 +194,10 @@ func NewTestUsers() map[string]*gtsmodel.User {
 			ConfirmedAt:            time.Time{},
 			ConfirmationSentAt:     TimeMustParse("2022-06-04T13:12:00Z"),
 			UnconfirmedEmail:       "weed_lord420@example.org",
-			Moderator:              false,
-			Admin:                  false,
-			Disabled:               false,
-			Approved:               false,
+			Moderator:              FalseBool(),
+			Admin:                  FalseBool(),
+			Disabled:               FalseBool(),
+			Approved:               FalseBool(),
 			ResetPasswordToken:     "",
 			ResetPasswordSentAt:    time.Time{},
 		},
@@ -212,10 +224,10 @@ func NewTestUsers() map[string]*gtsmodel.User {
 			ConfirmedAt:            TimeMustParse("2022-06-02T13:12:00Z"),
 			ConfirmationSentAt:     time.Time{},
 			UnconfirmedEmail:       "",
-			Moderator:              true,
-			Admin:                  true,
-			Disabled:               false,
-			Approved:               true,
+			Moderator:              TrueBool(),
+			Admin:                  TrueBool(),
+			Disabled:               FalseBool(),
+			Approved:               TrueBool(),
 			ResetPasswordToken:     "",
 			ResetPasswordSentAt:    time.Time{},
 		},
@@ -242,10 +254,10 @@ func NewTestUsers() map[string]*gtsmodel.User {
 			ConfirmedAt:            TimeMustParse("2022-06-02T13:12:00Z"),
 			ConfirmationSentAt:     TimeMustParse("2022-06-02T13:12:00Z"),
 			UnconfirmedEmail:       "",
-			Moderator:              false,
-			Admin:                  false,
-			Disabled:               false,
-			Approved:               true,
+			Moderator:              FalseBool(),
+			Admin:                  FalseBool(),
+			Disabled:               FalseBool(),
+			Approved:               TrueBool(),
 			ResetPasswordToken:     "",
 			ResetPasswordSentAt:    time.Time{},
 		},
@@ -272,10 +284,10 @@ func NewTestUsers() map[string]*gtsmodel.User {
 			ConfirmedAt:            TimeMustParse("2022-05-24T13:12:00Z"),
 			ConfirmationSentAt:     TimeMustParse("2022-05-23T13:12:00Z"),
 			UnconfirmedEmail:       "",
-			Moderator:              false,
-			Admin:                  false,
-			Disabled:               false,
-			Approved:               true,
+			Moderator:              FalseBool(),
+			Admin:                  FalseBool(),
+			Disabled:               FalseBool(),
+			Approved:               TrueBool(),
 			ResetPasswordToken:     "",
 			ResetPasswordSentAt:    time.Time{},
 		},
@@ -295,16 +307,16 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			DisplayName:             "",
 			Fields:                  []gtsmodel.Field{},
 			Note:                    "",
-			Memorial:                false,
+			Memorial:                FalseBool(),
 			MovedToAccountID:        "",
 			CreatedAt:               TimeMustParse("2022-06-04T13:12:00Z"),
 			UpdatedAt:               TimeMustParse("2022-06-04T13:12:00Z"),
-			Bot:                     false,
+			Bot:                     FalseBool(),
 			Reason:                  "hi, please let me in! I'm looking for somewhere neato bombeato to hang out.",
-			Locked:                  false,
-			Discoverable:            false,
+			Locked:                  FalseBool(),
+			Discoverable:            FalseBool(),
 			Privacy:                 gtsmodel.VisibilityPublic,
-			Sensitive:               false,
+			Sensitive:               FalseBool(),
 			Language:                "en",
 			URI:                     "http://localhost:8080/users/weed_lord420",
 			URL:                     "http://localhost:8080/@weed_lord420",
@@ -322,7 +334,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:            time.Time{},
 			SilencedAt:              time.Time{},
 			SuspendedAt:             time.Time{},
-			HideCollections:         false,
+			HideCollections:         FalseBool(),
 			SuspensionOrigin:        "",
 		},
 		"admin_account": {
@@ -334,16 +346,16 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			Fields:                  []gtsmodel.Field{},
 			Note:                    "",
 			NoteRaw:                 "",
-			Memorial:                false,
+			Memorial:                FalseBool(),
 			MovedToAccountID:        "",
 			CreatedAt:               TimeMustParse("2022-05-17T13:10:59Z"),
 			UpdatedAt:               TimeMustParse("2022-05-17T13:10:59Z"),
-			Bot:                     false,
+			Bot:                     FalseBool(),
 			Reason:                  "",
-			Locked:                  false,
-			Discoverable:            true,
+			Locked:                  FalseBool(),
+			Discoverable:            TrueBool(),
 			Privacy:                 gtsmodel.VisibilityPublic,
-			Sensitive:               false,
+			Sensitive:               FalseBool(),
 			Language:                "en",
 			URI:                     "http://localhost:8080/users/admin",
 			URL:                     "http://localhost:8080/@admin",
@@ -361,7 +373,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:            time.Time{},
 			SilencedAt:              time.Time{},
 			SuspendedAt:             time.Time{},
-			HideCollections:         false,
+			HideCollections:         FalseBool(),
 			SuspensionOrigin:        "",
 		},
 		"local_account_1": {
@@ -373,16 +385,16 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			Fields:                  []gtsmodel.Field{},
 			Note:                    "<p>hey yo this is my profile!</p>",
 			NoteRaw:                 "hey yo this is my profile!",
-			Memorial:                false,
+			Memorial:                FalseBool(),
 			MovedToAccountID:        "",
 			CreatedAt:               TimeMustParse("2022-05-20T11:09:18Z"),
 			UpdatedAt:               TimeMustParse("2022-05-20T11:09:18Z"),
-			Bot:                     false,
+			Bot:                     FalseBool(),
 			Reason:                  "I wanna be on this damned webbed site so bad! Please! Wow",
-			Locked:                  false,
-			Discoverable:            true,
+			Locked:                  FalseBool(),
+			Discoverable:            TrueBool(),
 			Privacy:                 gtsmodel.VisibilityPublic,
-			Sensitive:               false,
+			Sensitive:               FalseBool(),
 			Language:                "en",
 			URI:                     "http://localhost:8080/users/the_mighty_zork",
 			URL:                     "http://localhost:8080/@the_mighty_zork",
@@ -400,7 +412,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:            time.Time{},
 			SilencedAt:              time.Time{},
 			SuspendedAt:             time.Time{},
-			HideCollections:         false,
+			HideCollections:         FalseBool(),
 			SuspensionOrigin:        "",
 		},
 		"local_account_2": {
@@ -412,16 +424,16 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			Fields:                  []gtsmodel.Field{},
 			Note:                    "<p>i post about things that concern me</p>",
 			NoteRaw:                 "i post about things that concern me",
-			Memorial:                false,
+			Memorial:                FalseBool(),
 			MovedToAccountID:        "",
 			CreatedAt:               TimeMustParse("2022-06-04T13:12:00Z"),
 			UpdatedAt:               TimeMustParse("2022-06-04T13:12:00Z"),
-			Bot:                     false,
+			Bot:                     FalseBool(),
 			Reason:                  "",
-			Locked:                  true,
-			Discoverable:            false,
+			Locked:                  TrueBool(),
+			Discoverable:            FalseBool(),
 			Privacy:                 gtsmodel.VisibilityFollowersOnly,
-			Sensitive:               false,
+			Sensitive:               FalseBool(),
 			Language:                "en",
 			URI:                     "http://localhost:8080/users/1happyturtle",
 			URL:                     "http://localhost:8080/@1happyturtle",
@@ -439,7 +451,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:            time.Time{},
 			SilencedAt:              time.Time{},
 			SuspendedAt:             time.Time{},
-			HideCollections:         false,
+			HideCollections:         FalseBool(),
 			SuspensionOrigin:        "",
 		},
 		"remote_account_1": {
@@ -449,14 +461,14 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			DisplayName:           "big gerald",
 			Fields:                []gtsmodel.Field{},
 			Note:                  "i post about like, i dunno, stuff, or whatever!!!!",
-			Memorial:              false,
+			Memorial:              FalseBool(),
 			MovedToAccountID:      "",
 			CreatedAt:             TimeMustParse("2021-09-26T12:52:36+02:00"),
 			UpdatedAt:             TimeMustParse("2022-06-04T13:12:00Z"),
-			Bot:                   false,
-			Locked:                false,
-			Discoverable:          true,
-			Sensitive:             false,
+			Bot:                   FalseBool(),
+			Locked:                FalseBool(),
+			Discoverable:          TrueBool(),
+			Sensitive:             FalseBool(),
 			Language:              "en",
 			URI:                   "http://fossbros-anonymous.io/users/foss_satan",
 			URL:                   "http://fossbros-anonymous.io/@foss_satan",
@@ -474,7 +486,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:          time.Time{},
 			SilencedAt:            time.Time{},
 			SuspendedAt:           time.Time{},
-			HideCollections:       false,
+			HideCollections:       FalseBool(),
 			SuspensionOrigin:      "",
 		},
 		"remote_account_2": {
@@ -484,14 +496,14 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			DisplayName:           "some user",
 			Fields:                []gtsmodel.Field{},
 			Note:                  "i'm a real son of a gun",
-			Memorial:              false,
+			Memorial:              FalseBool(),
 			MovedToAccountID:      "",
 			CreatedAt:             TimeMustParse("2020-08-10T14:13:28+02:00"),
 			UpdatedAt:             TimeMustParse("2022-06-04T13:12:00Z"),
-			Bot:                   false,
-			Locked:                true,
-			Discoverable:          true,
-			Sensitive:             false,
+			Bot:                   FalseBool(),
+			Locked:                TrueBool(),
+			Discoverable:          TrueBool(),
+			Sensitive:             FalseBool(),
 			Language:              "en",
 			URI:                   "http://example.org/users/some_user",
 			URL:                   "http://example.org/@some_user",
@@ -509,7 +521,7 @@ func NewTestAccounts() map[string]*gtsmodel.Account {
 			SensitizedAt:          time.Time{},
 			SilencedAt:            time.Time{},
 			SuspendedAt:           time.Time{},
-			HideCollections:       false,
+			HideCollections:       FalseBool(),
 			SuspensionOrigin:      "",
 		},
 	}
@@ -607,9 +619,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH17FWEB39HZJ76B6VXSKF/attachment/small/01F8MH6NEM8D7527KZAECTCR76.jpeg",
 				RemoteURL:   "",
 			},
-			Avatar: false,
-			Header: false,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 		"local_account_1_status_4_attachment_1": {
 			ID:        "01F8MH7TDVANYKWVE8VVKFPJTJ",
@@ -656,9 +668,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/attachment/small/01F8MH7TDVANYKWVE8VVKFPJTJ.jpeg",
 				RemoteURL:   "",
 			},
-			Avatar: false,
-			Header: false,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 		"local_account_1_unattached_1": {
 			ID:        "01F8MH8RMYQ6MSNY3JM2XT1CQ5",
@@ -705,9 +717,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/attachment/small/01F8MH8RMYQ6MSNY3JM2XT1CQ5.jpeg",
 				RemoteURL:   "",
 			},
-			Avatar: false,
-			Header: false,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 		"local_account_1_avatar": {
 			ID:        "01F8MH58A357CV5K7R7TJMSH6S",
@@ -754,9 +766,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/avatar/small/01F8MH58A357CV5K7R7TJMSH6S.jpeg",
 				RemoteURL:   "",
 			},
-			Avatar: true,
-			Header: false,
-			Cached: true,
+			Avatar: TrueBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 		"local_account_1_header": {
 			ID:        "01PFPMWK2FF0D9WMHEJHR07C3Q",
@@ -803,9 +815,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/header/small/01PFPMWK2FF0D9WMHEJHR07C3Q.jpeg",
 				RemoteURL:   "",
 			},
-			Avatar: false,
-			Header: true,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: TrueBool(),
+			Cached: TrueBool(),
 		},
 		"remote_account_1_status_1_attachment_1": {
 			ID:        "01FVW7RXPQ8YJHTEXYPE7Q8ZY0",
@@ -852,9 +864,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/attachment/small/01FVW7RXPQ8YJHTEXYPE7Q8ZY0.jpeg",
 				RemoteURL:   "http://fossbros-anonymous.io/attachments/small/a499f55b-2d1e-4acd-98d2-1ac2ba6d79b9.jpeg",
 			},
-			Avatar: false,
-			Header: false,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 		"remote_account_1_status_1_attachment_2": {
 			ID:        "01FVW7RXPQ8YJHTEXYPE7Q8ZY1",
@@ -901,9 +913,9 @@ func NewTestAttachments() map[string]*gtsmodel.MediaAttachment {
 				URL:         "http://localhost:8080/fileserver/01F8MH1H7YV1Z7D2C8K2730QBF/attachment/small/01FVW7RXPQ8YJHTEXYPE7Q8ZY0.jpeg",
 				RemoteURL:   "http://fossbros-anonymous.io/attachments/small/a499f55b-2d1e-4acd-98d2-1ac2ba6d79b9.jpeg",
 			},
-			Avatar: false,
-			Header: false,
-			Cached: true,
+			Avatar: FalseBool(),
+			Header: FalseBool(),
+			Cached: TrueBool(),
 		},
 	}
 }
@@ -928,9 +940,9 @@ func NewTestEmojis() map[string]*gtsmodel.Emoji {
 			ImageFileSize:          36702,
 			ImageStaticFileSize:    10413,
 			ImageUpdatedAt:         TimeMustParse("2021-09-20T12:40:37+02:00"),
-			Disabled:               false,
+			Disabled:               FalseBool(),
 			URI:                    "http://localhost:8080/emoji/01F8MH9H8E4VG3KDYJR9EGPXCQ",
-			VisibleInPicker:        true,
+			VisibleInPicker:        TrueBool(),
 			CategoryID:             "",
 		},
 	}
@@ -978,7 +990,7 @@ func NewTestDomainBlocks() map[string]*gtsmodel.DomainBlock {
 			CreatedByAccountID: "01F8MH17FWEB39HZJ76B6VXSKF",
 			PrivateComment:     "i blocked this domain because they keep replying with pushy + unwarranted linux advice",
 			PublicComment:      "reply-guying to tech posts",
-			Obfuscate:          false,
+			Obfuscate:          FalseBool(),
 		},
 	}
 }
@@ -1044,20 +1056,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			EmojiIDs:                 []string{"01F8MH9H8E4VG3KDYJR9EGPXCQ"},
 			CreatedAt:                TimeMustParse("2021-10-20T11:36:45Z"),
 			UpdatedAt:                TimeMustParse("2021-10-20T11:36:45Z"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/admin",
 			AccountID:                "01F8MH17FWEB39HZJ76B6VXSKF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGXQRHYF5QPMTMXP78QC2F",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"admin_account_status_2": {
@@ -1067,20 +1080,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐕🐕🐕🐕🐕",
 			CreatedAt:                TimeMustParse("2021-10-20T12:36:45Z"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:36:45Z"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/admin",
 			AccountID:                "01F8MH17FWEB39HZJ76B6VXSKF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "open to see some puppies",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGXQRHYF5QPMTMXP78QC2F",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"admin_account_status_3": {
@@ -1090,7 +1104,7 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "hi @the_mighty_zork welcome to the instance!",
 			CreatedAt:                TimeMustParse("2021-11-20T13:32:16Z"),
 			UpdatedAt:                TimeMustParse("2021-11-20T13:32:16Z"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/admin",
 			MentionIDs:               []string{"01FF26A6BGEKCZFWNEHXB2ZZ6M"},
 			AccountID:                "01F8MH17FWEB39HZJ76B6VXSKF",
@@ -1099,13 +1113,14 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			InReplyToURI:             "http://localhost:8080/users/the_mighty_zork/statuses/01F8MHAMCHF6Y650WCRSCP4WMY",
 			BoostOfID:                "",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGXQRHYF5QPMTMXP78QC2F",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"admin_account_status_4": {
@@ -1115,7 +1130,7 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "hello everyone!",
 			CreatedAt:                TimeMustParse("2021-10-20T12:41:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:41:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/admin",
 			AccountID:                "01F8MH17FWEB39HZJ76B6VXSKF",
 			InReplyToID:              "",
@@ -1125,13 +1140,14 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			BoostOfAccountID:         "01F8MH1H7YV1Z7D2C8K2730QBF",
 			ContentWarning:           "introduction post",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGXQRHYF5QPMTMXP78QC2F",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_1_status_1": {
@@ -1141,20 +1157,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "hello everyone!",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/the_mighty_zork",
 			AccountID:                "01F8MH1H7YV1Z7D2C8K2730QBF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "introduction post",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGY43H3N2C8EWPR2FPYEXG",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_1_status_2": {
@@ -1164,20 +1181,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "this is an unlocked local-only post that shouldn't federate, but it's still boostable, replyable, and likeable",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/the_mighty_zork",
 			AccountID:                "01F8MH1H7YV1Z7D2C8K2730QBF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityUnlocked,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGY43H3N2C8EWPR2FPYEXG",
-			Federated:                false,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                FalseBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_1_status_3": {
@@ -1187,20 +1205,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "this is a very personal post that I don't want anyone to interact with at all, and i only want mutuals to see it",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/the_mighty_zork",
 			AccountID:                "01F8MH1H7YV1Z7D2C8K2730QBF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "test: you shouldn't be able to interact with this post in any way",
 			Visibility:               gtsmodel.VisibilityMutualsOnly,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGY43H3N2C8EWPR2FPYEXG",
-			Federated:                true,
-			Boostable:                false,
-			Replyable:                false,
-			Likeable:                 false,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                FalseBool(),
+			Replyable:                FalseBool(),
+			Likeable:                 FalseBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_1_status_4": {
@@ -1211,20 +1230,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			AttachmentIDs:            []string{"01F8MH7TDVANYKWVE8VVKFPJTJ"},
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/the_mighty_zork",
 			AccountID:                "01F8MH1H7YV1Z7D2C8K2730QBF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "eye contact, trent reznor gif",
 			Visibility:               gtsmodel.VisibilityMutualsOnly,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGY43H3N2C8EWPR2FPYEXG",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_1_status_5": {
@@ -1235,20 +1255,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			AttachmentIDs:            []string{},
 			CreatedAt:                TimeMustParse("2022-05-20T11:37:55Z"),
 			UpdatedAt:                TimeMustParse("2022-05-20T11:37:55Z"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/the_mighty_zork",
 			AccountID:                "01F8MH1H7YV1Z7D2C8K2730QBF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityFollowersOnly,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGY43H3N2C8EWPR2FPYEXG",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_1": {
@@ -1258,20 +1279,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 hi everyone i post about turtles 🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "introduction post",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_2": {
@@ -1281,20 +1303,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 this one is federated, likeable, and boostable but not replyable 🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                false,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                FalseBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_3": {
@@ -1304,20 +1327,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 i don't mind people sharing this one but I don't want likes or replies to it because cba🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "you won't be able to like or reply to this",
 			Visibility:               gtsmodel.VisibilityUnlocked,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                false,
-			Likeable:                 false,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                FalseBool(),
+			Likeable:                 FalseBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_4": {
@@ -1327,20 +1351,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 this is a public status but I want it local only and not boostable 🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                true,
+			Sensitive:                TrueBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                false,
-			Boostable:                false,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                FalseBool(),
+			Boostable:                FalseBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 
 			ActivityStreamsType: ap.ObjectNote,
 		},
@@ -1351,7 +1376,7 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 @the_mighty_zork hi zork! 🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			MentionIDs:               []string{"01FDF2HM2NF6FSRZCDEDV451CN"},
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
@@ -1361,13 +1386,14 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityPublic,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_6": {
@@ -1377,7 +1403,7 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			Content:                  "🐢 @the_mighty_zork hi zork, this is a direct message, shhhhhh! 🐢",
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			MentionIDs:               []string{"01FDF2HM2NF6FSRZCDEDV451CN"},
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
@@ -1387,13 +1413,14 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityDirect,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"local_account_2_status_7": {
@@ -1404,20 +1431,21 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			AttachmentIDs:            []string{},
 			CreatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-10-20T12:40:37+02:00"),
-			Local:                    true,
+			Local:                    TrueBool(),
 			AccountURI:               "http://localhost:8080/users/1happyturtle",
 			AccountID:                "01F8MH5NBDF2MV7CTC4Q5128HF",
 			InReplyToID:              "",
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityFollowersOnly,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "01F8MGYG9E893WRHW0TAEXR8GJ",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 		"remote_account_1_status_1": {
@@ -1428,7 +1456,7 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			AttachmentIDs:            []string{"01FVW7RXPQ8YJHTEXYPE7Q8ZY0"},
 			CreatedAt:                TimeMustParse("2021-09-20T12:40:37+02:00"),
 			UpdatedAt:                TimeMustParse("2021-09-20T12:40:37+02:00"),
-			Local:                    false,
+			Local:                    FalseBool(),
 			AccountURI:               "http://fossbros-anonymous.io/users/foss_satan",
 			MentionIDs:               []string{},
 			AccountID:                "01F8MH5ZK5VRH73AKHQM6Y9VNX",
@@ -1438,13 +1466,14 @@ func NewTestStatuses() map[string]*gtsmodel.Status {
 			BoostOfID:                "",
 			ContentWarning:           "",
 			Visibility:               gtsmodel.VisibilityUnlocked,
-			Sensitive:                false,
+			Sensitive:                FalseBool(),
 			Language:                 "en",
 			CreatedWithApplicationID: "",
-			Federated:                true,
-			Boostable:                true,
-			Replyable:                true,
-			Likeable:                 true,
+			Pinned:                   FalseBool(),
+			Federated:                TrueBool(),
+			Boostable:                TrueBool(),
+			Replyable:                TrueBool(),
+			Likeable:                 TrueBool(),
 			ActivityStreamsType:      ap.ObjectNote,
 		},
 	}
@@ -1460,8 +1489,8 @@ func NewTestTags() map[string]*gtsmodel.Tag {
 			FirstSeenFromAccountID: "",
 			CreatedAt:              TimeMustParse("2022-05-14T13:21:09+02:00"),
 			UpdatedAt:              TimeMustParse("2022-05-14T13:21:09+02:00"),
-			Useable:                true,
-			Listable:               true,
+			Useable:                TrueBool(),
+			Listable:               TrueBool(),
 			LastStatusAt:           TimeMustParse("2022-05-14T13:21:09+02:00"),
 		},
 		"Hashtag": {
@@ -1471,8 +1500,8 @@ func NewTestTags() map[string]*gtsmodel.Tag {
 			FirstSeenFromAccountID: "",
 			CreatedAt:              TimeMustParse("2022-05-14T13:21:09+02:00"),
 			UpdatedAt:              TimeMustParse("2022-05-14T13:21:09+02:00"),
-			Useable:                true,
-			Listable:               true,
+			Useable:                TrueBool(),
+			Listable:               TrueBool(),
 			LastStatusAt:           TimeMustParse("2022-05-14T13:21:09+02:00"),
 		},
 	}
@@ -1564,7 +1593,7 @@ func NewTestNotifications() map[string]*gtsmodel.Notification {
 			TargetAccountID:  "01F8MH1H7YV1Z7D2C8K2730QBF",
 			OriginAccountID:  "01F8MH17FWEB39HZJ76B6VXSKF",
 			StatusID:         "01F8MHAMCHF6Y650WCRSCP4WMY",
-			Read:             false,
+			Read:             FalseBool(),
 		},
 	}
 }
@@ -1578,9 +1607,9 @@ func NewTestFollows() map[string]*gtsmodel.Follow {
 			UpdatedAt:       TimeMustParse("2022-05-14T13:21:09+02:00"),
 			AccountID:       "01F8MH1H7YV1Z7D2C8K2730QBF",
 			TargetAccountID: "01F8MH17FWEB39HZJ76B6VXSKF",
-			ShowReblogs:     true,
+			ShowReblogs:     TrueBool(),
 			URI:             "http://localhost:8080/users/the_mighty_zork/follow/01F8PY8RHWRQZV038T4E8T9YK8",
-			Notify:          false,
+			Notify:          FalseBool(),
 		},
 		"local_account_1_local_account_2": {
 			ID:              "01F8PYDCE8XE23GRE5DPZJDZDP",
@@ -1588,9 +1617,9 @@ func NewTestFollows() map[string]*gtsmodel.Follow {
 			UpdatedAt:       TimeMustParse("2022-05-14T13:21:09+02:00"),
 			AccountID:       "01F8MH1H7YV1Z7D2C8K2730QBF",
 			TargetAccountID: "01F8MH5NBDF2MV7CTC4Q5128HF",
-			ShowReblogs:     true,
+			ShowReblogs:     TrueBool(),
 			URI:             "http://localhost:8080/users/the_mighty_zork/follow/01F8PYDCE8XE23GRE5DPZJDZDP",
-			Notify:          false,
+			Notify:          FalseBool(),
 		},
 		"local_account_2_local_account_1": {
 			ID:              "01G1TK1RS4K3E0MSFTXBFWAH9Q",
@@ -1598,9 +1627,9 @@ func NewTestFollows() map[string]*gtsmodel.Follow {
 			UpdatedAt:       TimeMustParse("2022-05-14T13:21:09+02:00"),
 			AccountID:       "01F8MH5NBDF2MV7CTC4Q5128HF",
 			TargetAccountID: "01F8MH1H7YV1Z7D2C8K2730QBF",
-			ShowReblogs:     true,
+			ShowReblogs:     TrueBool(),
 			URI:             "http://localhost:8080/users/1happyturtle/follow/01F8PYDCE8XE23GRE5DPZJDZDP",
-			Notify:          false,
+			Notify:          FalseBool(),
 		},
 		"admin_account_local_account_1": {
 			ID:              "01G1TK3PQKFW1BQZ9WVYRTFECK",
@@ -1608,9 +1637,9 @@ func NewTestFollows() map[string]*gtsmodel.Follow {
 			UpdatedAt:       TimeMustParse("2022-05-14T13:21:09+02:00"),
 			AccountID:       "01F8MH17FWEB39HZJ76B6VXSKF",
 			TargetAccountID: "01F8MH1H7YV1Z7D2C8K2730QBF",
-			ShowReblogs:     true,
+			ShowReblogs:     TrueBool(),
 			URI:             "http://localhost:8080/users/admin/follow/01G1TK3PQKFW1BQZ9WVYRTFECK",
-			Notify:          false,
+			Notify:          FalseBool(),
 		},
 	}
 }