JSrSSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SSK J r SS K J r SS KJr S rS r\\S .r\ R&"\ R(R*\ R(R,5\ R."SS\ R0555rg)-Executes a statement on a Cloud SQL instance.)absolute_import)division)unicode_literals)api_util)validate)base)flags) properties)filesa Executes a statement on a Cloud SQL instance. It will use the credentials of the specified Google Cloud account to connect to the instance, so an IAM user with the same name must exist in the instance. It doesn't support DQL or DML statements yet. WARNING: The requests and responses might transit through intermediate locations between your client and the location of the target instance. z To execute a statement on a Cloud SQL instance, run: $ {command} instance-foo --sql="ALTER TABLE employees RENAME TO personnel;" --database=db1 ) DESCRIPTIONEXAMPLESc2\rSrSrSr\r\S5rSr Sr g) ExecuteSql1rcURS[RSS9 URSSSS9 URS[S S S 9 URS S SSS.S SSS9 [R"US5 g)zArgs 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. instancezCloud SQL instance ID.) completerhelpz--sqlTzSQL statement(s) to execute. It supports multiple statements as well. When it starts with the character '@', the rest should be a filepath to read the SQL statement(s) from.)requiredrz --row_limitFz;Maximum number of rows to return. The default is unlimited.)typerrz--partial_result_modez@Unspecified mode, effectively the same as `FAIL_PARTIAL_RESULT`.zYThrow an error if the complete result can't be returned. Don't return the partial result.zReturn the partial result and mark the field partial_result to true if the complete result can't be returned. Don't throw an error.)PARTIAL_RESULT_MODE_UNSPECIFIEDFAIL_PARTIAL_RESULTALLOW_PARTIAL_RESULTNzControls how the API should respond when the SQL execution result is incomplete due to size limit or other reasons. The default mode is to throw an error instead of returning the partial result.)choicesrdefaultrz,Database on which the statement is executed.) add_argumentr InstanceCompleterint AddDatabase)parsers (lib/surface/sql/instances/execute_sql.pyArgsExecuteSql.Args8s )) %   ;    J   *4  )4 6cP[R"[R5nURnURn[ R "UR5 URRURS[RRRR0SS9nURR!S5(a$["R$"URSS5nO URnUR&(a0UR(R*R-UR&5nOSnUR)UUR.UR0USS9nUR2R5UR7URURUS 95$) zExecutes a statement on a Cloud SQL instance. Args: args: argparse.Namespace, The arguments that this command was invoked with. Returns: A dict object representing the execution result. projectz sql.instances)params collection@NT) sqlStatementdatabaserowLimitpartialResultMode autoIamAuthn)rr'executeSqlPayload)r SqlClientAPI_VERSION_DEFAULT sql_client sql_messagesrValidateInstanceNamerresource_parserParser VALUEScorer' GetOrFailsql startswithr ReadFileContentspartial_result_modeExecuteSqlPayload PartialResultModeValueValuesEnumlookup_by_namer- row_limit instancesrSqlInstancesExecuteSqlRequest) selfargsclientr4r5 instance_refr<r?req_bodys r"RunExecuteSql.Runssg   < < =F""J&&L !!$--0))// :,,1199CCD"0L  xx3  " "488AB< 0c HHc (::[[jj  " "!--- .H    * *22!** ((& 3  r%N) __name__ __module__ __qualname____firstlineno____doc__ DETAILED_HELP detailed_help staticmethodr#rK__static_attributes__rMr%r"rr1s$6-88t+r%rN)rR __future__rrrgooglecloudsdk.api_lib.sqlrrgooglecloudsdk.callioper googlecloudsdk.command_lib.sqlr googlecloudsdk.corer googlecloudsdk.core.utilr r rrS ReleaseTracks ReleaseTrackALPHABETADefaultUniverseOnlyCommandrrMr%r"rcs4&'//(0**   D%%++T->->-C-CDkkEkr%