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

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### What happened
   
   Simply put, the `id` of bitbucket pull request is not unique across 
different repositories of the same connection:
   
   
![image](https://user-images.githubusercontent.com/61080/232265170-32233f5d-892a-49d7-8d05-f227f15163d0.png)
   
   
![image](https://user-images.githubusercontent.com/61080/232265200-7c6d78f9-e0db-4fee-8f19-edcb533d5560.png)
   
   
   thus, the following PKs are utterly wrong:
   
![image](https://user-images.githubusercontent.com/61080/232265226-d86b098a-2d15-48f0-ab60-043b548c89e3.png)
   
![image](https://user-images.githubusercontent.com/61080/232265247-c1821722-89e3-4330-9917-f9bd61b30fa1.png)
   
   
   ### What do you expect to happen
   
   the `repo_id` column should be added to
   ` _tool_bitbucket_pull_request_commits` and
   `_tool_bitbucket_pull_request_comments` to connect to the correct PR
   
   ### How to reproduce
   
   collect multiple repos of one bitbucket connection, the dora metric produces 
incorrect result
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   main
   
   ### Are you willing to submit PR?
   
   - [ ] 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to