Skip to content

Query deploy keys by matching title

Jerry Seto requested to merge 432494-graphql-deploy-keys-1 into master

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

Merge request reports