Query deploy keys by matching title
What does this MR do and why?
- Extend DeployKeysWithWriteAccessFinder to check if title contains some term
- We start making these queries in the next MR here: !145976 (merged)
New queries
https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/26637/commands/83355
SELECT "keys".*
FROM "keys"
INNER JOIN "deploy_keys_projects" ON "keys"."id" = "deploy_keys_projects"."deploy_key_id"
WHERE "keys"."type" = 'DeployKey'
AND "deploy_keys_projects"."project_id" = 13083
AND "deploy_keys_projects"."can_push" = TRUE
AND "keys"."title" ILIKE '%sync%'
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #432494 (closed)
Edited by Jerry Seto