ODBC Driver for GitHub

Build 24.0.9175

CommitCompareFiles

Tracks files modified during a comparison between two references, providing details on up to 300 changed files for review.

View-Specific Information

Select

The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

  • Base supports the '=' comparison operator.
  • Head supports the '=' comparison operator.

For example, the following query is processed server-side:

SELECT * FROM [CommitCompareFiles] WHERE [Base] = 'Val1' AND [Head] = 'Val2'

The 本製品 processes other filters client-side within the 本製品.

Columns

Name Type References OrderBySupport Description
Sha [KEY] String The SHA (Secure Hash Algorithm) of the file, uniquely identifying the file's content in the repository.
FileName String The name of the file that was changed 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 additions and deletions.
Status String The status of the file in the commit, such as 'modified', 'added', or 'removed'.
BlobUrl String A URL linking to the file in blob format, representing the file's content at the time of the commit.
RawUrl String A direct URL linking to the raw content of the file, allowing users to view 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-format representation of the changes made to the file, showing additions and deletions.
PreviousFileName String The name of the file before any changes were made in this commit, if applicable (for example, in renaming).
Base String The ref (branch, tag, or commit hash) that serves as the starting point for a comparison between the file versions.
Head String The ref (branch, tag, or commit hash) that serves as the endpoint for a comparison between the file versions.

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