dosubot[bot] commented on issue #7864:
URL:
https://github.com/apache/incubator-devlake/issues/7864#issuecomment-2276744690
<!-- Answer -->
The names of files that were updated in the `pull_requests` table of the
DevLake database can be found in the `pull_request_commits` table. This table
shows the commits associated with pull requests, which include the files that
were changed.
Here is the relevant schema information:
```md
#### pull_request_commits
This table shows the commits associated with pull requests. Each entry
represents a commit that is part of a pull request.
| **field** | **type** | **length** | **description** | **key**
|
|:----------------|:---------|:-----------|:----------------|:---------------|
| `pull_request_id` | varchar | 255 | Pull Request ID |
FK_pull_requests.id |
| `commit_id` | varchar | 255 | Commit ID | FK_commits.id
|
```
To locate the names of files that were updated, you would need to join the
`pull_requests` table with the `pull_request_commits` table and then with the
`commits` table, which contains the details of the files changed in each commit.
Additionally, the `pull_request_files` table provides detailed information
about the files changed in pull requests:
```md
#### pull_request_files
This table shows the files changed in pull requests. Multiple entries can
exist per pull request.
| **field** | **type** | **length** | **description**
| **key** |
|:---------------|:---------|:-----------|:-------------------------------------------|:---------------|
| `pull_request_id` | varchar | 255 | Pull Request ID
| FK_pull_requests.id |
| `file_path` | varchar | 255 | The path of the file that was
changed | |
| `change_type` | varchar | 50 | The type of change (e.g., added,
modified, deleted) | |
| `additions` | int | | The number of lines added
| |
| `deletions` | int | | The number of lines deleted
| |
```
By leveraging these tables, you can effectively track the files that were
updated in the pull requests
<sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/docs/DataModels/DevLakeDomainLayerSchema.md)</sup><sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.21/DataModels/DevLakeDomainLayerSchema.md)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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: dev-unsubscr...@devlake.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
