JDBC Driver for GitHub

Build 22.0.8462

Watchers

A list of users watching the repository.

View-Specific Information

You must specify the UserLogin when executing a SELECT query against this view. You can specify the values in the WHERE clause or as connection properties. A value specified in the WHERE clause takes precedence over the connection property.

If you do not specify a UserLogin value, the driver will use the login name of the authenticated user.

Select

The driver uses the GitHub API to restrict results to the specified UserLogin and RepositoryName values.

The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

  • UserLogin and RepositoryName support the following operator: =
For example, the following queries are processed server side:
SELECT * FROM Watchers WHERE RepositoryName = 'MyRepo'

SELECT * FROM Watchers WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo'

Columns

Name Type OrderBySupport Description
Id [KEY] String The ID of the user.
UserLogin String The login name of the user.
RepositoryName [KEY] String The name of the repository.
Name String The user's public profile name.
Company String The user's public profile company.
CompanyHTML String The user's public profile company as HTML.
CreatedAt Datetime Identifies the date and time when the object was created.
Email String The user's publicly visible profile email.
IsBountyHunter Bool Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert Bool Whether or not this user is a participant in the GitHub Campus Experts Program.
IsDeveloperProgramMember Bool Whether or not this user is a GitHub Developer Program member.
IsEmployee Bool Whether or not this user is a GitHub employee.
IsHireable Bool Whether or not the user has marked themselves as for hire.
IsSiteAdmin Bool Whether or not this user is a site administrator.
IsViewer Bool Whether or not this user is the viewing user.
Location String The user's public profile location.
PinnedItemsRemaining Integer Returns how many more items this profile owner can pin to their profile.
ProjectsUrl String The HTTP URL listing user's projects.
ResourcePath String The HTTP path for this user.
TwitterUsername String The user's Twitter username.
UpdatedAt Datetime Identifies the date and time when the object was last updated.
URL String The HTTP URL for this user.
ViewerCanChangePinnedItems Bool Can the viewer pin repositories and gists to the profile?.
ViewerCanCreateProjects Bool Can the current viewer create new projects on this owner.
ViewerCanFollow Bool Whether or not the viewer is able to follow the user.
ViewerIsFollowing Bool Whether or not this user is followed by the viewer.
WebsiteUrl String A URL pointing to the user's public website/blog.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462