CommitFiles
Details files modified in specific commits, including filenames, change types (for example, added, deleted, modified), and related metadata.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- CommitOid supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [CommitFiles]
SELECT * FROM [CommitFiles] WHERE [CommitOid] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
Name | Type | References | OrderBySupport | Description |
CommitId [KEY] | String |
Commits.Id | The node ID of the commit, uniquely identifying the commit in the repository history. | |
CommitOid | String |
Commits.Oid | The SHA (Secure Hash Algorithm) of the commit, which serves as a unique identifier for this commit. | |
Sha [KEY] | String | The SHA of the file, uniquely identifying the file's content in the commit. | ||
FileName | String | The name of the file that was modified in the commit. | ||
Additions | Int | The number of lines added to the file in this commit. | ||
Deletions | Int | The number of lines deleted from the file in this commit. | ||
Changes | Int | The total number of changes made to the file, including both additions and deletions. | ||
Status | String | The status of the file after the commit, such as 'modified', 'added', or 'removed'. | ||
BlobUrl | String | A URL linking to the file in blob format, which represents the file's content at the time of the commit. | ||
RawUrl | String | A direct URL linking to the raw content of the file, allowing access to the file as plain text. | ||
ContentsUrl | String | A URL linking to the file served by the content management system, providing access to the file's content. | ||
Patch | String | A diff representation of the changes made to the file, showing additions and deletions. | ||
PreviousFileName | String | The name of the file before it was changed in this commit, applicable in case of renaming. |