;5XSrSSKJr SSKJr SSKJr SSKJr SSKJ r SSKJr SSKJ r SSKJ r SS K J r SS K Jr SS KJr SS KJr SS KJr SSKJr SrSrSr\\S.r\\\-S.rSrSrSrSrSrSr \RB\RD"\RFRH\RFRJ5"SS\RL555r'\RB\RD"\RFRP5"SS\RL555r)g)Clones a Cloud SQL instance.)absolute_import)division)unicode_literals) exceptions)api_util) operations)validate) arg_parsers)base)flags) instances)log) propertiesai *{command}* creates a clone of a Cloud SQL instance. The clone is an independent copy of the source instance with the same data and settings. Source and destination instances must be in the same project. An instance can be cloned from its current state, or from an earlier point in time. For MySQL: The binary log coordinates or timestamp (point in time), if specified, act as the point in time the source instance is cloned from. If not specified, the current state of the instance is cloned. For PostgreSQL: The point in time, if specified, defines a past state of the instance to clone. If not specified, the current state of the instance is cloned. For SQL Server: The point in time, if specified, defines a past state of the instance to clone. If not specified, the current state of the instance is cloned. a  To clone an instance from its current state (most recent binary log coordinates): $ {command} my-source-instance my-cloned-instance To clone a MySQL instance from an earlier point in time (past binary log coordinates): $ {command} my-source-instance my-cloned-instance --bin-log-file-name mysql-bin.000020 --bin-log-position 170 To clone a MySQL source instance at a specific point in time: $ {command} my-source-instance my-cloned-instance --point-in-time '2012-11-15T16:19:00.094Z' To clone a PostgreSQL source instance at a specific point in time: $ {command} my-source-instance my-cloned-instance --point-in-time '2012-11-15T16:19:00.094Z' To clone a SQL Server source instance at a specific point in time: $ {command} my-source-instance my-cloned-instance --point-in-time '2012-11-15T16:19:00.094Z' To clone a deleted instance, include the name and deletion time of the source instance: $ {command} my-source-instance my-cloned-instance --source-instance-deletion-time '2012-11-15T16:19:00.094Z' z To specify the allocated IP range for the private IP target Instance (reserved for future use): $ {command} my-source-instance my-cloned-instance --allocated-ip-range-name cloned-instance-ip-range ) DESCRIPTIONEXAMPLESc[R"UR5 [R"UR5 URR URS[ RRRR0SS9nURR URS[ RRRR0SS9n[X#5 X#4$)zAGet validated refs to source and destination instances from args.projectz sql.instances)params collection) r ValidateInstanceNamesource destinationresource_parserParserVALUEScorer GetOrFail_CheckSourceAndDestination)argsclientsource_instance_refdestination_instance_refs "lib/surface/sql/instances/clone.py_GetInstanceRefsFromArgsr%fs  ,  0 01..44 kk**//77AA B 5"$3399 **//77AA B :" 0K  66cURUR:wa8[R"SRURURS95eg)zBVerify that the source and destination instance ids are different.zWThe source and the clone instance must belong to the same project: "{src}" != "{dest}".)srcdestN)rr ArgumentErrorformat)r"r#s r$rrxsX  $<$D$DD  " " &#++)11!'!3 44Er&c&URSSSS9 g)z,Declare alpha flags for this command parser.z--allocated-ip-range-nameFa0 The name of the IP range allocated for the destination instance with private network connectivity. For example: 'google-managed-services-default'. If set, the destination instance IP is created in the allocated range represented by this name. Reserved for future use. requiredhelpN) add_argumentparsers r$ AddAlphaArgsr3s !   r&cURRnUR(a;UR(a*UR URURS9UlO1UR (a UR RS5UlUR (a+UR(aUR/URSS&UR(aURUl UR(aURUlUR(a URRS5UlU["R$R&:Xa$UR((aUR(Ulggg)z"Update request with clone options.)binLogFileNamebinLogPositionz%Y-%m-%dT%H:%M:%S.%fZN)instancesCloneRequest cloneContextbin_log_file_namebin_log_positionBinLogCoordinatesbinLogCoordinates point_in_timestrftime pointInTimerestore_database_name databaseNamespreferred_zone preferredZonepreferred_secondary_zonepreferredSecondaryZonesource_instance_deletion_timesourceInstanceDeletionTimer ReleaseTrackALPHAallocated_ip_range_nameallocatedIpRange)requestr sql_messages release_track clone_contexts r$_UpdateRequestFromArgsrPs-//<<-  5 5&2&D&D--,,'E'.M#  $ 2 2 ; ;!!M D66&*&@&@%AM" "&"5"5M ""+/+H+HM( '' **334KL,d''--- ##'+'C'Cm$$.r&c [R"[R5nURnURn[ X5upVUR URURURURSURS9S9S9n[XpXA5 URRURURURS95nUR(a[ R""SS5 URR)U5n UR*R-SU R.URS 9n UR0(aZUR3S 5(dS UlUR6RUR9U RU R:S 95$[6R<R?X:S 5 [@RB"U5 URRURURURS95n SU l"U $![$R&a GNHf=f)a{Clones a Cloud SQL instance. Args: args: argparse.Namespace, The arguments used to invoke this command. release_track: base.ReleaseTrack, the release track that this was run under. Returns: A dict object representing the operations resource describing the clone operation if the clone was successful. Raises: ArgumentError: The arguments are invalid for some reason. zsql#cloneContext)kinddestinationInstanceName)r8)rinstancer7)rrTclonezthe source instancezsql.operations) operationrr+default)rrVzCloning Cloud SQL instanceN)#r SqlClientAPI_VERSION_DEFAULT sql_clientrMr%SqlInstancesCloneRequestrrTInstancesCloneRequest CloneContextrPrGetSqlInstancesGetRequestdiskEncryptionConfiguration command_utilShowCmekWarningapitools_exceptions HttpErrorClonerCreatenameasync_ IsSpecifiedr+r SqlOperationsGetRequestrVOperationsV1Beta4WaitForOperationrCreatedResourcerR) r rNr!rZrMr"r#rLsource_instance_resourceresult operation_refrsources r$RunBaseCloneCommandrrs>   h:: ;&  *$$,t,0  1 1!))"++(>>#00%&>&G&G1I?J 2 K' D  )3377++'//(11 , 3 4 ;;""7,AB    % %g .&((// &..00-  [[   H % %dk  $ $,,!))]5L5L - N OO // 0LN./  $ $))*22+44*6 7'', .3  & &  s!A%H77IIc[RRU5 URR [ R "55 URS[ RSS9 URSSS9 URSSS 9nURSSS S 9nURS SS S9 URS[SSS9 URSSS 9nURS[RRSSS9 URSSSS9 URSSSS9 URSSSS9 URS[RRSSS9 g)z0Add args common to all release tracks to parser.rz$Cloud SQL instance ID of the source.) completerr/rz#Cloud SQL instance ID of the clone.)r/TF)mutexr.z2Binary log coordinates for point-in-time recovery.)rur.r/z--bin-log-file-nameaI The name of the binary log file. Enable point-in-time recovery on the source instance to create a binary log file. If specified with <--bin-log-position> to form a valid binary log coordinate, it defines an earlier point in time to clone a source instance from. For example, mysql-bin.000001. r-z--bin-log-positiona; Represents the state of an instance at any given point in time inside a binary log file. If specified along with <--bin-log-file-name> to form a valid binary log coordinate, it defines an earlier point in time to clone a source instance from. For example, 123 (a numeric value). )typer.r/z--point-in-timea Represents the state of an instance at any given point in time inside a transaction log file. For MySQL, the binary log file is used for transaction logs. For PostgreSQL, the write-ahead log file is used for transaction logs. For SQL Server, the log backup file is used for such purpose. To create a transaction log, enable point-in-time recovery on the source instance. Instance should have transaction logs accumulated up to the point in time they want to restore up to. Uses RFC 3339 format in UTC timezone. If specified, defines a past state of the instance to clone. For example, '2012-11-15T16:19:00.094Z'. z--restore-database-namez The name of the database to be restored for a point-in-time restore. If set, the destination instance will only restore the specified database. z--preferred-zonez The preferred zone for the cloned instance. If you specify a value for this flag, then the destination instance uses the value as the primary zone. z--preferred-secondary-zonez The preferred secondary zone for the cloned regional instance. If you specify a value for this flag, then the destination instance uses the value as the secondary zone. The secondary zone can't be the same as the primary zone. z--source-instance-deletion-timezq The time the source instance was deleted. This is required if cloning from a deleted instance. N)r ASYNC_FLAG AddToParser display_info AddFormatr GetInstanceListFormatr0InstanceCompleter add_groupintr Datetimer)r2pitr_options_group bin_log_grouppoint_in_time_groups r$ AddBaseArgsrs//f% ; ; =>'' 13 m*OP''dU'C$..  ?/A-       +44 E5#""    % % # "" #     "   '    % %  r&c2\rSrSrSr\r\S5rSr Sr g)reiKrcl[U5 URR[R5 g)z=Declare flag and positional arguments for the command parser.N)rryAddCacheUpdaterr r|)clsr2s r$Args Clone.ArgsRs& ''(?(?@r&c4[XR55$NrrrHselfr s r$Run Clone.RunX t%6%6%8 99r&N) __name__ __module__ __qualname____firstlineno____doc__ DETAILED_HELP detailed_help classmethodrr__static_attributes__rr&r$rereKs%%-AA :r&rec2\rSrSrSr\rSr\S5r Sr g) CloneAlphai\rc4[XR55$rrrs r$rCloneAlpha.Runcrr&c[U5 [U5 URR[R 5 g)z@Args is called by calliope to gather arguments for this command.N)rr3ryrr r|r1s r$rCloneAlpha.Argsfs. ''(?(?@r&rN) rrrrrDETAILED_APLHA_HELPrr staticmethodrrrr&r$rr\s'%%-:AAr&rN)*r __future__rrrapitools.base.pyrrcgooglecloudsdk.api_lib.sqlrr r googlecloudsdk.callioper r googlecloudsdk.command_lib.sqlr rragooglecloudsdk.corerrr EXAMPLES_GAEXAMPLES_ALPHArrr%rr3rPrrrDefaultUniverseOnly ReleaseTracksrHGABETA CreateCommandrerIrrr&r$rs/#&'>/11//(0D#* * 8 n, 7$4  D@@FT nD%%(($*;*;*@*@A :D   :B :D%%++, A## A- Ar&