[GitHub] [incubator-devlake] mindlesscloud opened a new issue, #4463: [Feature][Jira] extract the git repo URL from the issue remote link

["mindlesscloud (via GitHub)" <gi...@apache.org>]

mindlesscloud opened a new issue, #4463:
URL: https://github.com/apache/incubator-devlake/issues/4463

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement.
   
   
   ### Use case
   
   The issues  were associated with the git commits by the remote links of issues. The repo URL was transformed from the commit URL with a hardcoded regex. For more flexibility, the regex should be configurable.
   
   ### Description
   
   ## Example
   Let's take BitBucket as an example
   - BitBucket Server 
     - commit url：/projects/{projectKey}/repos/{repoName}/commits/{commitId}
     - repo url：/scm/{projectKey}/{repoName}.git
   - BitBucket cloud
     - commit url：/{userName}/{repoName}/commits/{commitId}
     - repo url：/{userName}/{repoName}.git
    As the example is indicated, The repo URL could be assembled from pieces extracted from the commit URL.
   
   ## Solution
   The solution mainly focuses on the versatility and the friendliness of the configuration.
   - Versatility: no matter what data source (BitBucket, GitHub, Gitee, etc.) in the remote link of the user's Jira issue is used, what URL splicing method is used (BitBucket Cloud and Server versions are quite different).
   - Configuration friendliness: no need for users to input particularly long/complex regular rules.
   
   1. The output goes into the table`issue_repo_commits`
   
   field | type |  example |
   -- | -- | -- |
   issue_id | varchar(255) |  
   commit_sha | char(40) |  
   repo_url | varchar(255) | https://atc.bmw-brilliance.cn/bitbucket/projects/JIRAUI/repos/bba_ui_jira/commits/1e23e7f1a0cb539c7408c38e5a37de3bc836bc94https://github.com/apache/incubator-devlake/pull/4445/commits/a7c6550b6a273af36e9850291a52601d3dca367chttps://gitlab.com/merico-dev/ee/vdev.co/-/commit/050baf4575caf069275f5fa14db9ad4a21a79883
   host | varchar(255) | <br>atc.bmw-brilliance.cngithub.comgitlab.com<br/><br>github.com<br/><br>gitlab.com<br/>
   namespace | varchar(255) | <br>JIRAUI<br/><br>apache<br/><br>merico-dev/ee<br/>
   repo_name | varchar(255) | <br>bba_ui_jira<br/><br>incubator-devlake<br/><br>vdev.co<br/>
   
   2. modify the `Jira transformation` to supply a configuration item, which accepts the URL patterns and generates regexes
   
   
   Data Source | Remote Link Examples | UI configuration - Remote Link Pattern | generated regex |
   -- | -- | -- | -- |
   BitBucket Server | https://atc.bmw-brilliance.cn/bitbucket/projects/JIRAUI/repos/bba_ui_jira/commits/1e23e7f1a0cb539c7408c38e5a37de3bc836bc94 |  https://atc.bmw-brilliance.cn/bitbucket/projects/{namespace}/repos/{repo_name}/commits/{commit_sha} |  
   BitBucket Cloud | https://bitbucket.org/zhangliangatbitbucket/incubator-devlake/commits/fef8d697fbb9a2b336be6fa2e2848f585c86a622 | https://bitbucket.org/{namespace}/{repo_name}/commits/{commit_sha} |  
   GitHub Cloud | https://github.com/apache/incubator-devlake/commit/a7c6550b6a273af36e9850291a52601d3dca367c | https://github.com/{namespace}/{repo_name}/commit/{commit_sha} |  
   GitLab Cloud | https://gitlab.com/merico-dev/ee/vdev.co/-/commit/050baf4575caf069275f5fa14db9ad4a21a79883 | https://gitlab.com/{namespace}/{repo_name}/-/commit/{commit_sha} |  
   
   ### Compatibility
   - Configuration
   1. Add configuration to extract namespace, repo_name, and commit_sha from Jira remote link
   2. Keep the configuration to extract commit sha from Jira remote link as a fallback
   3. Keep the existing logic of transforming the commit URL to the repo URL as a fallback.
   - Value of column `repo_url`
   1. assemble the repo URL from the host, namespace, and repo_name if the new configuration is available.
   2. the existing logic will be executed as a fallback if the new configuration is not available.
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@devlake.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-devlake] warren830 closed issue #4463: [Feature][Jira] extract the git repo URL from the issue remote link

["warren830 (via GitHub)" <gi...@apache.org>]

warren830 closed issue #4463: [Feature][Jira] extract the git repo URL from the issue remote link
URL: https://github.com/apache/incubator-devlake/issues/4463


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org