Add foreign key constraint to `projects.organization_id`

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166980



Merged-by: Omar Qunsul <oqunsul@gitlab.com>
Approved-by: João Pereira <jpereira@gitlab.com>
Approved-by: Alex Pooley <apooley@gitlab.com>
Approved-by: Omar Qunsul <oqunsul@gitlab.com>
Co-authored-by: Abdul Wadood <awadood@gitlab.com>

Changelog: other

Improve exact code and advanced search docs

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167580



Merged-by: Dmitry Gruzd <dgruzd@gitlab.com>
Approved-by: Dmitry Gruzd <dgruzd@gitlab.com>
Reviewed-by: Dmitry Gruzd <dgruzd@gitlab.com>
Co-authored-by: Ashraf Khamis <akhamis@gitlab.com>

Update Members page

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166384



Merged-by: Payton Burdette <pburdette@gitlab.com>
Approved-by: Chad Lavimoniere <clavimoniere@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Ravi Kumar <rkumar@gitlab.com>
Approved-by: Payton Burdette <pburdette@gitlab.com>
Co-authored-by: Julia Miocene <jmiocene@gitlab.com>

Update workspaces developer README.md with video of testing levels

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167914



Merged-by: Enrique Alcántara <ealcantara@gitlab.com>
Approved-by: Enrique Alcántara <ealcantara@gitlab.com>
Co-authored-by: Chad Woolley <cwoolley@gitlab.com>

Add MR and Issue categories to additional context

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167734



Merged-by: Jan Provaznik <jprovaznik@gitlab.com>
Approved-by: Missy Davies <mdavies@gitlab.com>
Approved-by: Jan Provaznik <jprovaznik@gitlab.com>
Co-authored-by: Vitali Tatarintev <vtatarintev@gitlab.com>

MR Vulnerability: display logic for AI resolution

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167577



Merged-by: Savas Vedova <svedova@gitlab.com>
Approved-by: Michael Becker <mbecker@gitlab.com>
Approved-by: Samantha Ming <sming@gitlab.com>
Approved-by: mo khan <mo@mokhan.ca>
Reviewed-by: David Pisek <dpisek@gitlab.com>
Co-authored-by: Dave Pisek <dpisek@gitlab.com>

Checks if the correct permissions are set
and the given finding is resolvable with AI.

Docs: Update Early Access Program features list

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167242



Merged-by: Suzanne Selhorn <sselhorn@gitlab.com>
Co-authored-by: Rostyslav Safonov <rsafonov-ext@gitlab.com>

Prevent work item console error

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167893



Merged-by: Coung Ngo <cngo@gitlab.com>
Approved-by: Coung Ngo <cngo@gitlab.com>
Co-authored-by: Simon Knox <simon@gitlab.com>

Merge branch '481665-audit-list-of-classes-in-app-assets-stylesheets-page_bundles-ide-scss' into 'master' 

Remove unused css from ide.scss

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167802



Merged-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Approved-by: Thomas Randolph <trandolph@gitlab.com>
Approved-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Co-authored-by: James Rushford <jrushford@gitlab.com>

Resolve "Introduce merge check for policy violations"

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166300



Merged-by: Sashi Kumar Kumaresan <skumar@gitlab.com>
Approved-by: Martin Čavoj <mcavoj@gitlab.com>
Approved-by: Sashi Kumar Kumaresan <skumar@gitlab.com>
Reviewed-by: Sashi Kumar Kumaresan <skumar@gitlab.com>
Reviewed-by: Artur Fedorov <afedorov@gitlab.com>
Reviewed-by: Martin Čavoj <mcavoj@gitlab.com>
Co-authored-by: Marc Shaw <mshaw@gitlab.com>

MR: gitlab.com/gitlab-org/gitlab/-/merge_requests/166300

Update Ruby version in README.md

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167919



Merged-by: Jenny Kim <yjeankim@gitlab.com>
Approved-by: Dat Tang <dattang@gitlab.com>

Reapply "Include axe checks in todos feature test"

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167459



Merged-by: Paulina Sedlak-Jakubowska <psedlak-jakubowska@gitlab.com>
Approved-by: Amelia Bauerly <abauerly@gitlab.com>
Approved-by: Ragnar Hardarson <rhardarson@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Tristan Read <tread@gitlab.com>
Approved-by: Piotr Skorupa <pskorupa@gitlab.com>

This reverts commit b37e8373.

Add pagination to Vue version of Your work -> Projects

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167040



Merged-by: Kos Palchyk <kpalchyk@gitlab.com>
Approved-by: Lukas Wanko <lwanko@gitlab.com>
Approved-by: Kos Palchyk <kpalchyk@gitlab.com>
Reviewed-by: Kos Palchyk <kpalchyk@gitlab.com>
Reviewed-by: Lukas Wanko <lwanko@gitlab.com>
Co-authored-by: Peter Hegman <phegman@gitlab.com>

Behind the your_work_projects_vue feature flag

Organize datetime utility functions

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167799



Merged-by: Jacques Erasmus <jerasmus@gitlab.com>
Approved-by: Jacques Erasmus <jerasmus@gitlab.com>
Reviewed-by: Coung Ngo <cngo@gitlab.com>
Co-authored-by: Coung Ngo <cngo@gitlab.com>

Add note about scope of group level gitlab-deploy-token

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167638



Merged-by: Phillip Wells <pwells@gitlab.com>
Approved-by: Phillip Wells <pwells@gitlab.com>
Co-authored-by: Paul Murray <pmurray@gitlab.com>

Co-authored-by: Phillip Wells <pwells@gitlab.com>

Create work item: Add dividers to items in sidebar

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167747



Merged-by: Natalia Tepluhina <ntepluhina@gitlab.com>
Approved-by: Nick Leonard <nleonard@gitlab.com>
Approved-by: Natalia Tepluhina <ntepluhina@gitlab.com>
Reviewed-by: Sascha Eggenberger <seggenberger@gitlab.com>
Co-authored-by: Sascha Eggenberger <seggenberger@gitlab.com>

Remove pipeline_run_keyword feature flag

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167722



Merged-by: Avielle Wolfe <awolfe@gitlab.com>
Approved-by: Avielle Wolfe <awolfe@gitlab.com>
Co-authored-by: Rajendra Kadam <rkadam@gitlab.com>

Maven virtual registries: improve the senddependency workhorse command

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167034



Merged-by: Dzmitry (Dima) Meshcharakou <12459192-dmeshcharakou@users.noreply.gitlab.com>
Approved-by: Moaz Khalifa <mkhalifa@gitlab.com>
Approved-by: Alessio Caiazza <acaiazza@gitlab.com>
Approved-by: Dzmitry (Dima) Meshcharakou <12459192-dmeshcharakou@users.noreply.gitlab.com>
Reviewed-by: Alessio Caiazza <acaiazza@gitlab.com>
Reviewed-by: David Fernandez <dfernandez@gitlab.com>
Reviewed-by: Dzmitry (Dima) Meshcharakou <12459192-dmeshcharakou@users.noreply.gitlab.com>
Reviewed-by: Moaz Khalifa <mkhalifa@gitlab.com>
Co-authored-by: David Fernandez <dfernandez@gitlab.com>

Add support in the workhorse senddependency action to include the
upload authorization response.

This way, the upload handler doesn't need to get the upload
authorization from the rails backend, it's already there.

This saves one request to the rails backend and shorten the overall
upload processing time.

Apply this shortcut in the maven virtual registry feature.

Merge branch '481683-remove-unused-css-from-app/assets/stylesheets/page_bundles/pipelines.scss' into 'master' 

Removes unused CSS Class class from app/assets/stylesheets/page_bundles/pipelines.scss

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/164635



Merged-by: Jacques Erasmus <jerasmus@gitlab.com>
Approved-by: James Rushford <jrushford@gitlab.com>
Approved-by: Jacques Erasmus <jerasmus@gitlab.com>
Co-authored-by: NIKU-SINGH <soapmactavishmw4@gmail.com>

From app/assets/stylesheets/page_bundles/pipelines.scss

Changelog : other

Closes : https://gitlab.com/gitlab-org/gitlab/-/issues/481683

Migrate todos Vue app filtering to `GlFilteredSearch`

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167471



Merged-by: Lukas Eipert <leipert@gitlab.com>
Approved-by: Amelia Bauerly <abauerly@gitlab.com>
Approved-by: Thomas Hutterer <thutterer@gitlab.com>
Approved-by: Lukas Eipert <leipert@gitlab.com>
Reviewed-by: Lukas Eipert <leipert@gitlab.com>
Reviewed-by: Paul Gascou-Vaillancourt <pgascouvaillancourt@gitlab.com>
Reviewed-by: Thomas Hutterer <thutterer@gitlab.com>
Co-authored-by: Paul Gascou-Vaillancourt <paul.gascvail@gmail.com>

This replaces the dropdown filters with the `GlFilteredSearch` component
in the todos Vue app.

Preselect namespace when buying storage

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167367



Merged-by: Vitali Tatarintev <vtatarintev@gitlab.com>
Approved-by: Nwanna Isong <nisong@gitlab.com>
Approved-by: Vitali Tatarintev <vtatarintev@gitlab.com>
Reviewed-by: Nwanna Isong <nisong@gitlab.com>
Co-authored-by: Ryan Cobb <rcobb@gitlab.com>

Fix permissions docs entries for Terraform state and cluster agents

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167842



Merged-by: Ryan Lehmann <rlehmann@gitlab.com>
Approved-by: Ryan Lehmann <rlehmann@gitlab.com>
Co-authored-by: Tiger <twatson@gitlab.com>

Add helper class method in SidekiqSharding::Router for iterating

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166849



Merged-by: Sylvester Chin <schin@gitlab.com>
Approved-by: Imre Farkas <ifarkas@gitlab.com>
Reviewed-by: Michael Kozono <mkozono@gitlab.com>
Co-authored-by: Michael Kozono <mkozono@gitlab.com>

This allows devs to re-use the `.with_routed_client` method to iterate
over all shards when using Sidekiq API.

Add and backfill project_id for ci_resources

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167645



Merged-by: Max Woolf <mwoolf@gitlab.com>
Approved-by: Jay Montal <jmontal@gitlab.com>
Approved-by: Omar Qunsul <oqunsul@gitlab.com>
Approved-by: Max Woolf <mwoolf@gitlab.com>
Reviewed-by: Max Woolf <mwoolf@gitlab.com>
Reviewed-by: Jay Montal <jmontal@gitlab.com>
Reviewed-by: Duo Code Reviewer <duo-code-review-bot@gitlab.com>
Co-authored-by: Shubham Kumar <shukumar@gitlab.com>

## What does this MR do and why?

Add and backfill project_id for ci_resources.

This table has a
[desired sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key)
configured ([view configuration](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/ci_resources.yml)).

This merge request is the first step towards transforming the desired sharding key into a
[sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#defining-a-sharding-key-for-all-cell-local-tables).

This involves three changes:

- Adding a new column that will serve as the sharding key (along with the relevant index and foreign key).
- Populating the sharding key when new records are created by adding a database function and trigger.
- Scheduling a [batched background migration](https://docs.gitlab.com/ee/development/database/batched_background_migrations.html)
  to set the sharding key for existing records.

Once the background migration has completed, a second merge request will be created to finalize the background
migration and validate the not null constraint.

## How to verify

We have assigned a random backend engineer from ~"group::pipeline execution" to review these changes. Please review this merge
request from a ~backend perspective. The main thing we are looking to verify is that the added column and association
match the values specified by the [desired sharding key](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/ci_resources.yml)
configuration and that backfilling the column from this other table makes sense in the context of this feature.

When you are finished, please:

1. Trigger the [database testing pipeline](https://docs.gitlab.com/ee/development/database/database_migration_pipeline.html)
   as instructed by Danger.
1. Request a review from the ~backend maintainer and ~database reviewer suggested by Danger.

If you have any questions or concerns, reach out to `@tigerwnz` or @shubhamkrai.

This merge request was generated by a once off keep implemented in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/143774

This change was generated by
[gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::BackfillDesiredShardingKeySmallTable keep.

To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the
label ~"GitLab Housekeeper" and consider pinging the author of this keep.

Changelog: other