Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with GitHub.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from GitHub, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for GitHub Stored Procedures
| Name | Description |
| AddCollaborator | Adds a user to a repository with a specified permission level, updating existing access if necessary. Enterprise Managed Users are added directly, while others receive an invitation. |
| CloneTemplateRepository | Duplicates the files and structure of a template repository to create a new repository, streamlining the setup process for consistent project creation. |
| CommitCompare | Compares two commits against one another. You can compare references (branches or tags) and commit SHAs in the same repository, or you can compare references and commit SHAs that exist in different repositories within the same repository network, including fork branches. |
| CreateCommitOnBranch | Appends a commit to the given branch of the procedure's repository as the authenticated user. |
| DeleteCodeScanningAnalysis | Deletes an analysis by Id, or deletes the matched set of analyses in reverse chronological order. Deleting the final remaining analysis in a set requires explicitly confirming the deletion because it removes all associated historical alert data. |
| DeleteRepository | Delete a repository from GitHub. |
| DownloadFile | Facilitates downloading specific files from a GitHub repository for offline access or local reference. |
| GetCurrentlyAuthenticatedUser | Fetches comprehensive details about the currently authenticated GitHub user, including username and account preferences. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to GitHub. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| MergePullRequest | Automates the merging of an open pull request into the target branch, integrating proposed changes into the main codebase. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access token to maintain continuous authenticated access to GitHub resources without requiring reauthorization from the user. |
| RemoveCollaborator | Removes a collaborator from a repository, revoking their access, unstarring repositories, canceling invitations, unassigning issues, denying pull requests, updating related permissions and may delete forks. |
| UpdatePullRequestBranch | Merge or Rebase HEAD from upstream branch into pull request branch. |
| UploadFile | Enables users to upload files directly to a specified GitHub repository for collaborative purposes. |