Adopt new app-based auth model for GitLab for Jira Cloud app
requested to merge bmarjanovic/416864-adopt-new-app-based-auth-model-developed-by-atlassian-for-gitlab-for-jira-cloud-app into master
What does this MR do and why?
Based on the #416864 (closed), we're introducing new app-based auth model developed by Atlassian for GitLab for Jira Cloud app.
Database queries
SQL | postgres.ai |
---|---|
SELECT * FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."namespace_id" = "namespaces"."id" WHERE "jira_connect_subscriptions"."jira_connect_installation_id" = ID |
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/26101/commands/82156 |
SELECT * FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."namespace_id" = "namespaces"."id" WHERE "jira_connect_subscriptions"."jira_connect_installation_id" = ID AND "projects"."id" = PROJECT_ID LIMIT 1 |
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/26101/commands/82157 |
SELECT * FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."namespace_id" = "namespaces"."id" WHERE "jira_connect_subscriptions"."jira_connect_installation_id" = ID AND (projects.name LIKE 'NAME%') LIMIT 20 OFFSET 0 |
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/26101/commands/82158 |
SELECT * FROM "namespaces" INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."namespace_id" = "namespaces"."id" WHERE "namespaces"."type" != 'Project' AND "jira_connect_subscriptions"."jira_connect_installation_id" = ID |
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/26101/commands/82159 |
SELECT * FROM "namespaces" INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."namespace_id" = "namespaces"."id" WHERE "namespaces"."type" != 'Project' AND "jira_connect_subscriptions"."jira_connect_installation_id" = 8 AND (name LIKE 'NAME%') |
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/26101/commands/82160 |
How to set up and validate locally
- TBD
Related to #416864 (closed)
Edited by Bojan Marjanovic