JDBC Driver for GitHub

Build 22.0.8462

Projects

Lists information about projects.

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, RepositoryName, Number, and State support the following operator: =
For example, the following queries are processed server side:
SELECT * FROM Projects WHERE UserLogin = 'MyUserLogin' AND RepositoryName = 'MyRepo'

SELECT * FROM Projects WHERE Number=2

SELECT * FROM Projects WHERE State = 'all'

Columns

Name Type OrderBySupport Description
Id [KEY] String The project ID.
UserLogin String The login name of the user.
RepositoryName String The name of the repository.
Body String The project's description body.
BodyHTML String The projects description body rendered to HTML.
Closed Boolean true if the object is closed (definition of closed may depend on type).
ClosedAt Datetime Identifies the date and time when the object was closed.
CreatedAt Datetime True Identifies the date and time when the object was created.
Creator String The actor's login name who originally created the project.
Name String True The project's name.
Number Integer The project's number.
ResourcePath String The HTTP path for this project.
State String Whether the project is open or closed.

The allowed values are OPEN, CLOSED.

UpdatedAt Datetime True Identifies the date and time when the object was last updated.
Url String The HTTP URL for this project.
ViewerCanUpdate Boolean Check if the current viewer can update this object.

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