forgejo/services/repository
Mathieu Fenniak 82ad5189fe feat: add foreign keys to the access table (#9557)
Adds two foreign keys:
- `access.user_id` -> `user`
- `access.repo_id` -> `repository`

Testing:
- Existing automated test suite
    - Minor adjustments required to `reverseproxy_test.go`
    - Test failures caused a reorganization of delete operations in `DeleteRepositoryDirectly`
- Manually tested
    - On "user" and "repo" Collaborator page, added, removed, and changed the access-level of collaborators

## Checklist

The [contributor guide](https://forgejo.org/docs/next/contributor/) contains information that will be helpful to first time contributors. There also are a few [conditions for merging Pull Requests in Forgejo repositories](https://codeberg.org/forgejo/governance/src/branch/main/PullRequestsAgreement.md). You are also welcome to join the [Forgejo development chatroom](https://matrix.to/#/#forgejo-development:matrix.org).

### Tests

- I added test coverage for Go changes...
  - [ ] in their respective `*_test.go` for unit tests.
  - [ ] in the `tests/integration` directory if it involves interactions with a live Forgejo server.
- I added test coverage for JavaScript changes...
  - [ ] in `web_src/js/*.test.js` if it can be unit tested.
  - [ ] in `tests/e2e/*.test.e2e.js` if it requires interactions with a live Forgejo server (see also the [developer guide for JavaScript testing](https://codeberg.org/forgejo/forgejo/src/branch/forgejo/tests/e2e/README.md#end-to-end-tests)).

### Documentation

- [ ] I created a pull request [to the documentation](https://codeberg.org/forgejo/docs) to explain to Forgejo users how to use this change.
- [x] I did not document these changes and I do not expect someone else to do it.

### Release notes

- [ ] I do not want this change to show in the release notes.
- [x] I want the title to show in the release notes with a link to this pull request.
- [ ] I want the content of the `release-notes/<pull request number>.md` to be be used for the release notes instead of the title.

<!--start release-notes-assistant-->

## Release notes
<!--URL:https://codeberg.org/forgejo/forgejo-->
- Features
  - [PR](https://codeberg.org/forgejo/forgejo/pulls/9557): <!--number 9557 --><!--line 0 --><!--description YWRkIGZvcmVpZ24ga2V5cyB0byB0aGUgYGFjY2Vzc2AgdGFibGU=-->add foreign keys to the `access` table<!--description-->
<!--end release-notes-assistant-->

Reviewed-on: https://codeberg.org/forgejo/forgejo/pulls/9557
Reviewed-by: Gusted <gusted@noreply.codeberg.org>
Co-authored-by: Mathieu Fenniak <mathieu@fenniak.net>
Co-committed-by: Mathieu Fenniak <mathieu@fenniak.net>
2025-10-14 05:39:47 +02:00
..
archiver Update module github.com/golangci/golangci-lint/cmd/golangci-lint to v2 (forgejo) (#7367) 2025-03-28 22:22:21 +00:00
commitstatus chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
files feat: improve getting shortstat (#9587) 2025-10-10 14:15:38 +02:00
gitgraph chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
adopt.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
adopt_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
avatar.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
avatar_test.go Update module github.com/golangci/golangci-lint/cmd/golangci-lint to v2 (forgejo) (#7367) 2025-03-28 22:22:21 +00:00
branch.go chore(cleanup): replaces unnecessary calls to formatting functions by non-formatting equivalents (#7994) 2025-05-29 17:34:29 +02:00
cache.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
check.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
collaboration.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
collaboration_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
commit.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
contributors_graph.go chore(cleanup): replaces unnecessary calls to formatting functions by non-formatting equivalents (#7994) 2025-05-29 17:34:29 +02:00
contributors_graph_test.go Update module github.com/golangci/golangci-lint/cmd/golangci-lint to v2 (forgejo) (#7367) 2025-03-28 22:22:21 +00:00
create.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
create_test.go fix: ensure consistent empty repository topics field (#7920) 2025-05-29 22:39:53 +02:00
delete.go feat: add foreign keys to the access table (#9557) 2025-10-14 05:39:47 +02:00
fork.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
fork_test.go chore: QoL improvements to tests (#7917) 2025-05-21 15:45:56 +02:00
generate.go fix: camel and pascal case transformer (#8034) 2025-06-01 17:06:25 +02:00
generate_test.go fix: camel and pascal case transformer (#8034) 2025-06-01 17:06:25 +02:00
hooks.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
init.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
lfs.go Update module github.com/golangci/golangci-lint/cmd/golangci-lint to v2 (forgejo) (#7367) 2025-03-28 22:22:21 +00:00
lfs_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
main_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
migrate.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
push.go chore(cleanup): replaces unnecessary calls to formatting functions by non-formatting equivalents (#7994) 2025-05-29 17:34:29 +02:00
repository.go feat: Add converting mirror repos to normal to the API (#8932) 2025-09-14 14:25:05 +02:00
repository_test.go feat: Add converting mirror repos to normal to the API (#8932) 2025-09-14 14:25:05 +02:00
review.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
review_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
setting.go feat: move StopTask, CancelPreviousJobs and CleanRepoScheduleTasks to services/actions 2025-04-10 08:38:27 +02:00
star.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
sync_fork.go feat: improved performances when checking for conflicts on pull requests (#7727) 2025-05-16 12:40:38 +00:00
template.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
transfer.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00
transfer_test.go chore: branding import path (#7337) 2025-03-27 19:40:14 +00:00