Commits
Contains metadata for commits in a repository, including author information, timestamps, and commit messages for version tracking.
Table-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- BranchName supports the '=,IN' comparison operators.
- CommittedDate supports the '=,>=,>,=,<,<=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Commits]
SELECT * FROM [Commits] WHERE [BranchName] = 'Val1'
SELECT * FROM [Commits] WHERE [CommittedDate] = '2023-01-01 11:10:00'
The add-in processes other filters client-side within the add-in.
Insert
You can use the following columns to create (insert) a new record:
- BranchName
- MessageBody
- MessageHeadline
You can use the following pseudo-columns to create a new record:
- ExpectedHeadOid
- FileChangeAdditions (references FileChangeAdditions)
- FileChangeDeletions (references FileChangeDeletions)
INSERT INTO [Commits] ([BranchName], [MessageBody], [MessageHeadline], [ExpectedHeadOid], [FileChangeAdditions], [FileChangeDeletions]) VALUES ('Branch', 'Test commit.', 'Test headline.', '77c120c11bb482d243fcfaa52be277f3e626c6d4', '[{"contents":"dGVzdA==","path":"1.txt"},{"contents":"dGVzdDI=","path":"2.txt"}]', '[{"path":"a.txt"},{"path":"b.txt"}]')
FileChangeAdditions Temporary Table Columns
| Column Name | Type | Description |
| Contents | String | The base64 encoded contents of the file. |
| Path | String | The path in the repository where the file will be located. |
FileChangeDeletions Temporary Table Columns
| Column Name | Type | Description |
| Path | String | The path to delete. |
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier for the commit. | |
| Oid | String | True |
The Git object ID, uniquely identifying this commit in the Git repository. | |
| AbbreviatedOid | String | True |
An abbreviated version of the Git object ID, commonly used for easier reference. | |
| BranchName [KEY] | String | False |
Branches.Name |
The name of the branch where the commit was made. |
| ChangedFilesIfAvailable | Int | True |
The number of files changed in this commit. Returns 'null' if the number can't be calculated. | |
| Additions | Int | True |
The total number of lines added in this commit. | |
| Deletions | Int | True |
The total number of lines removed in this commit. | |
| AuthoredByCommitter | Bool | True |
Indicates whether the author and the committer of this commit are the same. | |
| CommittedViaWeb | Bool | True |
Indicates whether this commit was made through GitHub's web UI. | |
| AuthoredDate | Datetime | True |
The date and time when this commit was authored. | |
| CommittedDate | Datetime | True |
The date and time when this commit was actually committed. | |
| ViewerSubscription | String | True |
Indicates the subscription status of the viewer (for example, watching, not watching, ignoring) for this commit's repository. | |
| ViewerCanSubscribe | Bool | True |
Indicates whether the viewer has the ability to change their subscription status for the repository. | |
| Message | String | True |
The main message or description of the changes made in this commit. | |
| MessageBody | String | False |
The full body text of the commit message. | |
| MessageHeadline | String | False |
The headline or short summary of the commit message. | |
| MessageBodyHTML | String | True |
The body of the commit message rendered as HTML. | |
| MessageHeadlineHTML | String | True |
The headline of the commit message rendered as HTML. | |
| ResourcePath | String | True |
The HTTP path for this specific commit. | |
| CommitResourcePath | String | True |
The HTTP path for the Git object associated with this commit. | |
| TreeResourcePath | String | True |
The HTTP path for accessing the tree structure of the commit. | |
| Url | String | True |
The HTTP URL that leads to this commit's page. | |
| CommitUrl | String | True |
The URL for accessing this specific Git object in the repository. | |
| TarballUrl | String | True |
The URL to download a tarball archive of the repository. (Links expire after five minutes for private repositories.) | |
| TreeUrl | String | True |
The HTTP URL for accessing the tree structure of this commit. | |
| ZipballUrl | String | True |
The URL to download a zipball archive of the repository. (Links expire after five minutes for private repositories.) | |
| AuthorName | String | True |
The name of the author who authored the commit. | |
| AuthorEmail | String | True |
The email address of the commit author. | |
| AuthorDate | Datetime | True |
The timestamp when the commit was authored (Git action). | |
| AuthorUserLogin | String | True |
The GitHub username corresponding to the email address associated with this commit. Null if no user is found. | |
| CommitterName | String | True |
The name of the committer who committed the changes. | |
| CommitterEmail | String | True |
The email address of the person who committed the changes. | |
| CommitterDate | Datetime | True |
The timestamp indicating when the commit was committed. | |
| CommitterUserLogin | String | True |
The GitHub username corresponding to the email address of the committer. Null if no user is found. | |
| OnBehalfOfId | String | True |
The unique ID of the organization this commit was made on behalf of. | |
| OnBehalfOf | String | True |
The login name of the organization this commit was made on behalf of. | |
| SignatureIsValid | Bool | True |
Indicates whether the commit's signature is valid and verified by GitHub. | |
| Signature | String | True |
The ASCII-armored signature header used in this commit. | |
| SignatureEmail | String | True |
The email address associated with the signature for this commit. | |
| SignaturePayload | String | True |
The payload used for the GPG signature. Represents the raw ODB object without the signature header. | |
| SignatureState | String | True |
The state of the signature. 'VALID' indicates that the signature is valid, and other states indicate why the signature is considered invalid. | |
| SignatureSigner | String | True |
The GitHub username of the person who signed this commit. | |
| WasSignedByGitHub | Bool | True |
Indicates whether the commit was signed using GitHub's signing key. | |
| SignatureVerifiedAt | Datetime | True |
The date the signature was verified, if valid. | |
| StatusId | String | True |
The unique ID of the commit status associated with this commit. | |
| StatusState | String | True |
The overall status of the commit, combining various checks and statuses. | |
| StatusCheckRollupId | String | True |
The unique ID for the Check and Status rollup associated with this commit. | |
| StatusCheckRollupState | String | True |
The combined state of the Check and Status rollup for this commit. | |
| TreeId | String | True |
The unique ID of the root tree object for this commit. | |
| TreeOid | String | True |
The Git object ID of the tree associated with this commit. | |
| TreeAbbreviatedOid | String | True |
An abbreviated version of the Git object ID of the tree. | |
| TreeCommitUrl | String | True |
The HTTP URL to view the tree object associated with this commit. | |
| TreeCommitResourcePath | String | True |
The HTTP path to access the tree object associated with this commit. |
Pseudo-Columns
Pseudo-columns are fields that can be used in WHERE clauses to filter data, but do not contain data themselves.
| Name | Type | Description |
| ExpectedHeadOid | String |
The git commit oid expected at the head of the branch prior to the commit. |
| FileChangeAdditions | String |
File to add or change. |
| FileChangeDeletions | String |
Files to delete. |