Skip to content
Snippets Groups Projects

Query deploy keys by matching title

Merged Jerry Seto requested to merge 432494-graphql-deploy-keys-1 into master
All threads resolved!

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

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Contributor

    E2E Test Result Summary

    allure-report-publisher generated test report!

    e2e-test-on-gdk: :white_check_mark: test report for 21efb0b1

    expand test summary
    +------------------------------------------------------------------+
    |                          suites summary                          |
    +-------------+--------+--------+---------+-------+-------+--------+
    |             | passed | failed | skipped | flaky | total | result |
    +-------------+--------+--------+---------+-------+-------+--------+
    | Govern      | 3      | 0      | 0       | 0     | 3     | ✅     |
    | Create      | 66     | 0      | 9       | 0     | 75    | ✅     |
    | Monitor     | 4      | 0      | 0       | 0     | 4     | ✅     |
    | Plan        | 4      | 0      | 0       | 0     | 4     | ✅     |
    | Package     | 0      | 0      | 1       | 0     | 1     | ➖     |
    | Data Stores | 2      | 0      | 0       | 0     | 2     | ✅     |
    +-------------+--------+--------+---------+-------+-------+--------+
    | Total       | 79     | 0      | 10      | 0     | 89    | ✅     |
    +-------------+--------+--------+---------+-------+-------+--------+

    e2e-package-and-test: :white_check_mark: test report for 21efb0b1

    expand test summary
    +------------------------------------------------------------------+
    |                          suites summary                          |
    +-------------+--------+--------+---------+-------+-------+--------+
    |             | passed | failed | skipped | flaky | total | result |
    +-------------+--------+--------+---------+-------+-------+--------+
    | Create      | 566    | 0      | 58      | 10    | 624   | ✅     |
    | Package     | 0      | 0      | 2       | 0     | 2     | ➖     |
    | Monitor     | 8      | 0      | 0       | 0     | 8     | ✅     |
    | Plan        | 8      | 0      | 0       | 0     | 8     | ✅     |
    | Data Stores | 4      | 0      | 0       | 0     | 4     | ✅     |
    | Govern      | 6      | 0      | 0       | 0     | 6     | ✅     |
    +-------------+--------+--------+---------+-------+-------+--------+
    | Total       | 592    | 0      | 60      | 10    | 652   | ✅     |
    +-------------+--------+--------+---------+-------+-------+--------+
  • Max Orefice
  • Max Orefice approved this merge request

    approved this merge request

  • added databasereviewed label and removed databasereview pending label

  • Max Orefice removed review request for @morefice

    removed review request for @morefice

  • Max Orefice requested review from @a_akgun

    requested review from @a_akgun

  • Mehmet Emin INAC
  • Mehmet Emin INAC
  • Mehmet Emin INAC removed review request for @minac

    removed review request for @minac

  • Mehmet Emin INAC
  • Jerry Seto added 2 commits

    added 2 commits

    • 9c943e46 - Refactor to use scopes on DeployKey
    • 21efb0b1 - - Fix incorrect test

    Compare with previous version

  • Jerry Seto requested review from @minac

    requested review from @minac

  • Mehmet Emin INAC approved this merge request

    approved this merge request

  • Mehmet Emin INAC removed review request for @minac

    removed review request for @minac

  • Alper Akgun approved this merge request

    approved this merge request

  • added databaseapproved label and removed databasereviewed label

  • Alper Akgun removed review request for @a_akgun

    removed review request for @a_akgun

  • Alper Akgun resolved all threads

    resolved all threads

  • Alper Akgun requested review from @a_akgun

    requested review from @a_akgun

  • Alper Akgun enabled an automatic merge when the pipeline for 31a6b536 succeeds

    enabled an automatic merge when the pipeline for 31a6b536 succeeds

  • merged

  • Hello @j.seto :wave:

    The database team is looking for ways to improve the database review process and we would love your help!

    If you'd be open to someone on the database team reaching out to you for a chat, or if you'd like to leave some feedback asynchronously, just post a reply to this comment mentioning:

    @gitlab-org/database-team

    And someone will be by shortly!

    Thanks for your help! :heart:

    This message was generated automatically. You're welcome to improve it.

  • Alper Akgun mentioned in commit f9c8b1b0

    mentioned in commit f9c8b1b0

  • added workflowstaging label and removed workflowcanary label

  • Please register or sign in to reply
    Loading