ODBC Driver for GitHub

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175