gitforge/models/gitea_migrations/fixtures
christopher-besch 8770ffc848 feat: granular settings for watched repo units (#10927)
Continuation of #10598
Closes #7254

Implement repo granular watch selection

I adopted a lot of the frontend from #10598 while redoing the entire back-end. I propose this new model:
- Remove the WatchMode enum.
- Add the WatchSelection struct, which represents the granular selection. Notice that there is no `watching` bool. I tried very hard to keep the structure as simple and redundancy-free as possible. Therefore, people not watching a repo at all either don't have a watch record or one with an entirely unselected WatchSelection struct.
- Add the WatchSource enum. It replaces the WatchMode enum and has a single purpose: determine whether a watch was explicitly or automatically initiated.

Notice that replacing this
```go
		And("`watch`.mode<>?", WatchModeDont).
```
with this is correct:
```go
		And(
			builder.Or(
				builder.Eq{"`watch`.watch_selection_issues": true},
				builder.Eq{"`watch`.watch_selection_pull_requests": true},
				builder.Eq{"`watch`.watch_selection_releases": true},
			),
		).
```
That's because there are four modes: dont, none, auto and normal. When `<>` with dont, we look for auto and normal, because there are no records with none. Therefore, the old code looks for records that indicate watching. The code I replaced this with does so, too, just more granular.

Also notice that I've prepared a future `user preset` in a few places. See below for a little more info on that.

## Next PR
I plan to continue working on this. I want to implement a `user preset` option. The user sets that `user preset` in her settings and may use them in any repo.
<details>
- rename account settings to account and notifications
- user preset (always use this preset for newly accessible repos (according to AutoWatchOnChanges and AutoWatchNewRepos))
</details>

## Further PRs
- make api able to granular watch
- move (email) notifications to new notifications tab

Co-authored-by: 0ko <0ko@noreply.codeberg.org>
Co-authored-by: Gusted <postmaster@gusted.xyz>
Co-authored-by: pat-s <patrick.schratz@gmail.com>
Reviewed-on: https://codeberg.org/forgejo/forgejo/pulls/10927
Reviewed-by: Gusted <gusted@noreply.codeberg.org>
2026-07-09 19:51:10 +02:00
..
Test_AddCombinedIndexToIssueUser
Test_AddConfidentialClientColumnToOAuth2ApplicationTable
Test_AddForeignKeysAccess migration: update existing foreign key migrations to automatically fix inconsistencies (#10568) 2025-12-29 02:50:20 +01:00
Test_addForeignKeysActionRunnerToken feat: add foreign keys to the action_runner_token table (#10756) 2026-01-12 21:59:40 +01:00
Test_addForeignKeysCollaboration migration: update existing foreign key migrations to automatically fix inconsistencies (#10568) 2025-12-29 02:50:20 +01:00
Test_addForeignKeysForgejoAuthToken migration: update existing foreign key migrations to automatically fix inconsistencies (#10568) 2025-12-29 02:50:20 +01:00
Test_addForeignKeysPullRequest1 migration: update existing foreign key migrations to automatically fix inconsistencies (#10568) 2025-12-29 02:50:20 +01:00
Test_AddForeignKeysStopwatchTrackedTime migration: update existing foreign key migrations to automatically fix inconsistencies (#10568) 2025-12-29 02:50:20 +01:00
Test_addGranularWatchColumnsAndDropModeColumn feat: granular settings for watched repo units (#10927) 2026-07-09 19:51:10 +02:00
Test_AddHeaderAuthorizationEncryptedColWebhook
Test_AddIssueResourceIndexTable
Test_AddPayloadVersionToHookTaskTable
Test_AddRepoIDForAttachment
Test_AddUniqueIndexForProjectIssue
Test_ChangeMavenArtifactConcatenation refactor: migrate from lib/pq to jackc/pgx (#10219) 2025-11-30 17:47:45 +01:00
Test_CheckProjectColumnsConsistency fix(models): deduplicate project sorting values and add unique constraints (#11334) 2026-02-27 16:25:20 +01:00
Test_DeleteOrphanedIssueLabels
Test_MigrateActionSecretToKeying
Test_MigrateNormalizedFederatedURI
Test_MigrateTaskSecretsToKeying
Test_MigrateTwoFactorToKeying
Test_MigrateWebhookSecrets feat: use keying for webhook secrets (#10059) 2025-12-22 15:51:37 +01:00
Test_RemigrateU2FCredentials
Test_RemoveInvalidLabels
Test_removeSoftDeleteActionRunnerToken feat: add foreign keys to the action_runner_token table (#10756) 2026-01-12 21:59:40 +01:00
Test_RemoveSSHSignaturesFromReleaseNotes
Test_RepositoryFormat
Test_setOIDCSubjectFormatLegacy15 feat: expose immutable identifiers in Forgejo Actions JWTs (#12355) 2026-05-03 15:46:58 +02:00
Test_SetTopicsAsEmptySlice
Test_StoreWebauthnCredentialIDAsBytes
Test_UnwrapLDAPSourceCfg
Test_UpdateBadgeColName
Test_UpdateOpenMilestoneCounts
Test_v14ActionsApprovalAndTrustPopulateTableActionUser refactor: migrate from lib/pq to jackc/pgx (#10219) 2025-11-30 17:47:45 +01:00