feat: add Postgres Import/Export config messages

Google APIs · copybara-github · commit 51d7fa890fa8 · 2024-07-23T11:10:57.000-07:00
PiperOrigin-RevId: 655231833
diff --git a/google/cloud/sql/v1/cloud_sql_resources.proto b/google/cloud/sql/v1/cloud_sql_resources.proto
@@ -349,6 +349,20 @@ message ExportContext {
       google.protobuf.Int32Value master_data = 1;
     }
 
+    // Options for exporting from a Cloud SQL for PostgreSQL instance.
+    message PostgresExportOptions {
+      // Optional. Use this option to include DROP <object> SQL statements.
+      // These statements are used to delete database objects before running the
+      // import operation.
+      google.protobuf.BoolValue clean = 1
+          [(google.api.field_behavior) = OPTIONAL];
+
+      // Optional. Option to include an IF EXISTS SQL statement with each DROP
+      // statement produced by clean.
+      google.protobuf.BoolValue if_exists = 2
+          [(google.api.field_behavior) = OPTIONAL];
+    }
+
     // Tables to export, or that were exported, from the specified database. If
     // you specify tables, specify one and only one database. For PostgreSQL
     // instances, you can specify only one table.
@@ -366,6 +380,10 @@ message ExportContext {
     // Optional. Whether or not the export should be parallel.
     google.protobuf.BoolValue parallel = 5
         [(google.api.field_behavior) = OPTIONAL];
+
+    // Optional. Options for exporting from a Cloud SQL for PostgreSQL instance.
+    PostgresExportOptions postgres_export_options = 6
+        [(google.api.field_behavior) = OPTIONAL];
   }
 
   // Options for exporting BAK files (SQL Server-only)
@@ -433,13 +451,29 @@ message ExportContext {
 // Database instance import context.
 message ImportContext {
   message SqlImportOptions {
+    message PostgresImportOptions {
+      // Optional. The --clean flag for the pg_restore utility. This flag
+      // applies only if you enabled Cloud SQL to import files in parallel.
+      google.protobuf.BoolValue clean = 1
+          [(google.api.field_behavior) = OPTIONAL];
+
+      // Optional. The --if-exists flag for the pg_restore utility. This flag
+      // applies only if you enabled Cloud SQL to import files in parallel.
+      google.protobuf.BoolValue if_exists = 2
+          [(google.api.field_behavior) = OPTIONAL];
+    }
+
     // Optional. The number of threads to use for parallel import.
     google.protobuf.Int32Value threads = 1
         [(google.api.field_behavior) = OPTIONAL];
 
     // Optional. Whether or not the import should be parallel.
     google.protobuf.BoolValue parallel = 2
         [(google.api.field_behavior) = OPTIONAL];
+
+    // Optional. Options for importing from a Cloud SQL for PostgreSQL instance.
+    PostgresImportOptions postgres_import_options = 3
+        [(google.api.field_behavior) = OPTIONAL];
   }
 
   message SqlCsvImportOptions {
