CommitFiles
Lists up to three hundred files for each gist at every revision, including up to one megabyte of content per file.
View-Specific Information
Select
The server uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- GistName supports the '=' comparison operator.
- GistSha supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [CommitFiles]
SELECT * FROM [CommitFiles] WHERE [GistName] = 'Val1'
SELECT * FROM [CommitFiles] WHERE [GistSha] = 'Val1'
The server processes other filters client-side within the server.
Columns
| Name | Type | References | OrderBySupport | Description |
| GistName [KEY] | String |
Gists.Name | The gist identifier. | |
| GistSha [KEY] | String |
Commits.Sha | The SHA of the gist revision. | |
| Name [KEY] | String | The file name. | ||
| Size | Int | The file size in bytes. | ||
| Type | String | The type of the file. | ||
| Language | String | The programming language of the file. | ||
| Encoding | String | The character encoding of the file. | ||
| Truncated | Bool | Indicates whether the file content has been truncated. If truncated, only up to one megabyte of content is returned. | ||
| Content | String | The file content. | ||
| RawUrl | String | The raw content URL of the file. | ||
| UserLogin | String | The username of the user who created the revision. | ||
| OwnerLogin | String | The username of the gist owner. |