Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-5188

Use PROJECT_UUID from PROJECTS table to simplify some requests

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0
    • Component/s: Database
    • Labels:
      None

      Description

      The purpose is to fix the issue raised during SONAR-5086 (issue search with both "plan" and "componentRoot" parameters).

      This will require a migration script.

      The validation should also lead to the removal of the hack on the Issues page (see SONAR-5086).

      Technical details :
      The query to be executed in the migration should be something like :

      SELECT
        projects.*, root_one.id as root_one, root_two.id  as root_two
      FROM projects
        LEFT OUTER JOIN projects root_one ON root_one.id = projects.root_id
        LEFT OUTER JOIN projects root_two ON root_two.id = root_one.root_id
      
      • if root_one and root_two are not null -> use root_two
      • if root_one only -> use root_one
      • else -> use projects.uuid (on top level, the project_uuid should return itself to facilitate the search)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              julien.lancelot Julien Lancelot
              Reporter:
              fabemn OLD - Fabrice Bellingard
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: