DBMS_CLOUD_REPO Overview
The DBMS_CLOUD_REPO package provides easy access
to files in Cloud Code (Git) Repositories, including: GitHub, AWS CodeCommit, and
Azure Repos.
This package is a single interface for access to Multicloud Code repositories and allows you to upload SQL files to Git repositories or install SQL scripts directly from Cloud Code Repositories. This package also allows you to use a Cloud Code Repository to manage code versions for SQL scripts and to install or patch application code from Git repositories.
Concepts
-
Git Version Control System: Git is software for tracking changes in any set of files, usually used for coordinating work among programmers collaboratively developing source code during software development. Its goals include speed, data integrity, and support for distributed, non-linear workflows.
-
Git Repository: A Git repository is a virtual storage of your project. It allows you to save versions of your code, which you can access when needed.
Architecture
DBMS_CLOUD_REPO package provides four
feature areas:
-
Repository Initialization with Generic Cloud Code Repository Handle
-
Initialize a GitHub Code Repository
-
Initialize an AWS CodeCommit Code Repository
-
Initialize an Azure Repos Code Repository
-
-
Repository Management Operations
-
Create a repository
-
Update a repository
-
List repositories
-
Delete a repository
-
-
Repository File Management Operations
-
Upload a file to Code Repository from Oracle Database.
-
Download a file from Code Repository to Oracle Database.
-
Delete files from Code Repository.
-
List files from Code Repository.
-
-
SQL Install Operations
- Export Database object metadata DDL to repository.
-
Install SQL statements from a file in the Code Repository in Oracle Database.
-
Install SQL statements from a buffer.
- DBMS_CLOUD_REPO Data Structures
TheDBMS_CLOUD_REPOpackage defines record types and a generic JSON object typerepo. - DBMS_CLOUD_REPO Initialization Operations
Lists the subprograms for initialization operations within theDBMS_CLOUD_REPOpackage. - DBMS_CLOUD_REPO Repository Management Operations
Shows the subprograms for repository management operations within theDBMS_CLOUD_REPOpackage. - DBMS_CLOUD_REPO Repository Branch Management Operations
Lists the subprograms for repository branch management operations within theDBMS_CLOUD_REPOpackage. - DBMS_CLOUD_REPO File Operations
Lists the subprograms for file operations within theDBMS_CLOUD_REPOpackage. - DBMS_CLOUD_REPO SQL Install Operations
Lists the subprograms for SQL install operations within theDBMS_CLOUD_REPOpackage.
Parent topic: DBMS_CLOUD_REPO Package Reference
DBMS_CLOUD_REPO Data Structures
The DBMS_CLOUD_REPO package defines record types
and a generic JSON object type repo.
REPO JSON Object
A DBMS_CLOUD_REPO
REPO is an opaque JSON object to represent a Cloud Code Repository of a specific cloud
provider. A REPO object can be passed to different DBMS_CLOUD_REPO
APIs. This opaque object ensures that DBMS_CLOUD_REPO procedures
and functions are multicloud compatible; you do not have to change
any code when you migrate from one Cloud Code Repository provider to another Cloud Code Repository.
Parent topic: DBMS_CLOUD_REPO Overview
DBMS_CLOUD_REPO Initialization Operations
Lists the subprograms for initialization operations within the DBMS_CLOUD_REPO package.
| Subprogram | Description |
|---|---|
| This function initializes an AWS repository handle and returns an opaque type. | |
| This function initializes an Azure repository handle and returns an opaque type. | |
| This function initializes a GitHub repository handle and returns an opaque type. | |
| This function initializes a Cloud Code Repository handle and returns an opaque JSON object. |
Parent topic: DBMS_CLOUD_REPO Overview
DBMS_CLOUD_REPO Repository Management Operations
Shows the subprograms for repository management operations within the DBMS_CLOUD_REPO package.
| Subprogram | Description |
|---|---|
This procedure creates a Cloud Code Repository identified by the repo handle argument.
|
|
This procedure deletes the Cloud Code Repository identified by the repo handle argument.
|
|
This function lists all the Cloud Code Repositories identified by the repo handle argument.
|
|
This procedure updates a Cloud Code repository identified by the repo handle argument. The procedure supports updating the name, description, or private visibility status, as supported by the Cloud Code repository.
|
Parent topic: DBMS_CLOUD_REPO Overview
DBMS_CLOUD_REPO Repository Branch Management Operations
Lists the subprograms for repository branch management operations within the DBMS_CLOUD_REPO package.
| Subprogram | Description |
|---|---|
This procedure creates a branch in a Cloud Code Repository identified by the repo handle argument.
|
|
This procedure deletes a branch in a Cloud Code Repository identified by the repo handle argument.
|
|
This function lists all the Cloud Code Repository branches identified by the repo handle argument.
|
|
This function lists all the commits in a Cloud Code Repository branch identified by the repo handle argument.
|
|
This procedure merges a Cloud Code Repository branch into another specified branch in a Cloud Code Repository identified by the repo handle argument.
|
Parent topic: DBMS_CLOUD_REPO Overview
DBMS_CLOUD_REPO File Operations
Lists the subprograms for file operations within the DBMS_CLOUD_REPO package.
| Subprogram | Description |
|---|---|
This procedure deletes a file from the Cloud Code repository identified by the repo handle argument.
|
|
| The function downloads the contents of a file from the Cloud Code repository. The procedure allows you to download the contents of a file from the Cloud Code repository and save the file in a directory. | |
| This function downloads a file from Cloud Code repository. Optionally, file content can be accessed from either a specific branch, tag or commit name. By default, the file is accessed from the default repository branch. | |
This procedure uploads a file to the Cloud Code repository identified by the repo handle argument. The procedure is overloaded to support either uploading a file from a directory object or uploading the contents from a CLOB to the repository file.
|
Parent topic: DBMS_CLOUD_REPO Overview
DBMS_CLOUD_REPO SQL Install Operations
Lists the subprograms for SQL
install operations within the DBMS_CLOUD_REPO
package.
| Subprogram | Description |
|---|---|
This procedure uploads the DDL metadata of a database object to the Cloud Code repository identified by the repo handle argument.
|
|
This procedure exports metadata of all objects in a schema to a Cloud Code Repository branch identified by the repo handle argument.
|
|
This procedure installs SQL statements from a file in the Cloud Code repository identified by the repo handle argument.
|
|
| This procedure installs SQL statements from a buffer given as input. |
Parent topic: DBMS_CLOUD_REPO Overview