Gists

Lists gists at their most recent revisions.

Table-Specific Information

Select

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

Name supports the '=' comparison operator.
UpdatedAt supports the '>=,>' comparison operators.
OwnerLogin supports the '=' comparison operator.

For example, the following queries are processed server-side:

SELECT * FROM [Gists]
SELECT * FROM [Gists] WHERE [Name] = 'Val1'
SELECT * FROM [Gists] WHERE [UpdatedAt] >= '2023-01-01 11:10:00'
SELECT * FROM [Gists] WHERE [OwnerLogin] = 'Val1'

The cmdlet processes other filters client-side within the cmdlet.

Insert

You can use the following columns to create (insert) a new record:

Public
Description

You can use the following pseudo-column to create a new record: Files (references Files)

INSERT INTO [Gists] ([Description], [Public], [Files]) VALUES ('Test description.', false, '[{"Name":"A.txt","Content":"TextA"},{"Name":"B.txt","Content":"TextB"}]')

INSERT INTO [Files#TEMP] ([Name],[Content]) VALUES ('A.txt','TextA')
INSERT INTO [Files#TEMP] ([Name],[Content]) VALUES ('B.txt','TextB')
INSERT INTO [Gists] ([Description], [Public], [Files]) VALUES ('Test description.', false, 'Files#TEMP')

Files Temporary Table Columns


Column Name	Type	Description
Name	String	The file name.
Content	String	The file content.

Update

You can use the following column to update a record:

Description

UPDATE [Gists] SET [Description] = 'Text' WHERE [Name] = 'd7e43b9c1a285c14f62af9803e1d47c8'

Delete

You can specify the following column to delete a record: Name

DELETE FROM [Gists] WHERE [Name] = 'd7e43b9c1a285c14f62af9803e1d47c8'

Columns


Name	Type	ReadOnly	References	Description
Id	String	True		The node ID of the gist.
Name [KEY]	String	True		The gist identifier.
Public	Bool	False		Indicates whether the gist is public.
Description	String	False		The gist description.
Url	String	True		The API URL of the gist.
HtmlUrl	String	True		The HTML URL of the gist.
GitPullUrl	String	True		The git pull URL of the gist.
GitPushUrl	String	True		The git push URL of the gist.
CommitsUrl	String	True		The API URL for the gist commits.
ForksUrl	String	True		The API URL for the gist forks.
CommentsUrl	String	True		The API URL for the gist comments.
CommentsEnabled	Bool	True		Indicates whether comments are enabled for the gist.
Comments	Int	True		The number of comments on the gist.
CreatedAt	Datetime	True		The date and time when the gist was created.
UpdatedAt	Datetime	True		The date and time when the gist was last updated.
OwnerLogin	String	True		The username of the gist owner.
OwnerId	Int	True		The ID of the gist owner.
OwnerNodeId	String	True		The node ID of the gist owner.
OwnerAvatarUrl	String	True		The avatar URL of the gist owner.
OwnerGravatarId	String	True		The Gravatar ID of the gist owner.
OwnerUrl	String	True		The API URL of the gist owner.
OwnerHtmlUrl	String	True		The HTML URL of the gist owner.
OwnerFollowersUrl	String	True		The API URL for the gist owner's followers.
OwnerFollowingUrl	String	True		The API URL for the gist owner's following.
OwnerGistsUrl	String	True		The API URL for the gist owner's gists.
OwnerStarredUrl	String	True		The API URL for the gist owner's starred repositories.
OwnerSubscriptionsUrl	String	True		The API URL for the gist owner's subscriptions.
OwnerOrganizationsUrl	String	True		The API URL for the gist owner's organizations.
OwnerReposUrl	String	True		The API URL for the gist owner's repositories.
OwnerEventsUrl	String	True		The API URL for the gist owner's events.
OwnerReceivedEventsUrl	String	True		The API URL for the gist owner's received events.
OwnerType	String	True		The type of the gist owner.
OwnerSiteAdmin	Bool	True		Indicates whether the gist owner is a site administrator.
OwnerUserViewType	String	True		The user view type of the gist owner.

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
Files	String	Set to an aggregate of the names and content of the files to create a gist.

Cmdlets for GitHub