# -*- coding: utf-8 -*- # # Copyright 2017 Google LLC. All Rights Reserved. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. """Imports data into a Cloud SQL instance from a SQL dump file. Imports data into a Cloud SQL instance from a SQL dump file in Google Cloud Storage. """ import textwrap from googlecloudsdk.api_lib.sql import api_util from googlecloudsdk.calliope import base from googlecloudsdk.command_lib.sql import flags from googlecloudsdk.command_lib.sql import import_util @base.ReleaseTracks(base.ReleaseTrack.GA, base.ReleaseTrack.BETA, base.ReleaseTrack.ALPHA) @base.DefaultUniverseOnly class Sql(base.Command): """Imports data into a Cloud SQL instance from a SQL dump file.""" detailed_help = { 'DESCRIPTION': textwrap.dedent("""\ {command} imports data into a Cloud SQL instance from a SQL dump file in Google Cloud Storage. NOTE: Certain roles and permissions are required to import data into Google Cloud SQL. For more information on importing data into Google Cloud SQL see [Import a SQL dump file](https://cloud.google.com/sql/docs/mysql/import-export/import-export-sql#gcloud_1). For detailed help on importing data into Cloud SQL, refer to this guide: https://cloud.google.com/sql/docs/mysql/import-export/importing """), 'EXAMPLES': textwrap.dedent("""\ To import data from a SQL dump file into a database, `testdb`, on the specified Cloud SQL instance `test-instance-1`, run: $ gcloud sql import sql test-instance-1 gs://test-bucket/test-file.sql.gz --database=testdb """), } @staticmethod def Args(parser): """Args is called by calliope to gather arguments for this command. Args: parser: An argparse parser that you can use to add arguments that go on the command line after this command. Positional arguments are allowed. """ import_util.AddBaseImportFlags(parser, filetype='MySQL dump') flags.AddDatabase(parser, flags.DEFAULT_DATABASE_IMPORT_HELP_TEXT) flags.AddParallelArgument(parser, operation='import') flags.AddThreadsArgument(parser, operation='import') flags.AddCleanImportArgument(parser) flags.AddIfExistsImportsArgument(parser) def Run(self, args): """Runs the command to import into the Cloud SQL instance.""" client = api_util.SqlClient(api_util.API_VERSION_DEFAULT) return import_util.RunSqlImportCommand(args, client)