Created
November 12, 2019 08:44
-
-
Save kennethteh90/23638d48fdba9b27e4e25565e7ee83c2 to your computer and use it in GitHub Desktop.
Function for exporting GCP Postgres database to Google Cloud Storage
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const {google} = require("googleapis"); | |
| const {auth} = require("google-auth-library"); | |
| var sqladmin = google.sqladmin("v1beta4"); | |
| exports.exportDatabase = (_req, res) => { | |
| async function doIt() { | |
| const authRes = await auth.getApplicationDefault(); | |
| let authClient = authRes.credential; | |
| var request = { | |
| // Project ID of the project that contains the instance to be exported. | |
| project: "my-project-name", | |
| // Cloud SQL instance ID. This does not include the project ID. | |
| instance: "my-cloud-sql-db-name", | |
| resource: { | |
| // Contains details about the export operation. | |
| exportContext: { | |
| // This is always sql#exportContext. | |
| kind: "sql#exportContext", | |
| // The file type for the specified uri (e.g. SQL or CSV) | |
| fileType: "SQL", // CSV | |
| /** | |
| * The path to the file in GCS where the export will be stored. | |
| * The URI is in the form gs://bucketName/fileName. | |
| * If the file already exists, the operation fails. | |
| * If fileType is SQL and the filename ends with .gz, the contents are compressed. | |
| */ | |
| uri: `gs://my-database-backups/backup-${Date.now()}.gz`, | |
| /** | |
| * Databases from which the export is made. | |
| * If fileType is SQL and no database is specified, all databases are exported. | |
| * If fileType is CSV, you can optionally specify at most one database to export. | |
| * If csvExportOptions.selectQuery also specifies the database, this field will be ignored. | |
| */ | |
| databases: ["myDatabase"] | |
| // Options for exporting data as SQL statements. | |
| // sqlExportOptions: { | |
| // /** | |
| // * Tables to export, or that were exported, from the specified database. | |
| // * If you specify tables, specify one and only one database. | |
| // */ | |
| // tables: config.tables, | |
| // // Export only schemas? | |
| // schemaOnly: config.schemaOnly | |
| // } | |
| } | |
| }, | |
| // Auth client | |
| auth: authClient | |
| }; | |
| // Kick off export with requested arguments. | |
| sqladmin.instances.export(request, function(err, result) { | |
| if (err) { | |
| console.log(err); | |
| } else { | |
| console.log(result); | |
| } | |
| res.status(200).send("Command completed", err, result); | |
| }); | |
| } | |
| doIt(); | |
| }; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment