E SrSSKJr SSKJr SSKJr SSKrSSKrSSKJr SSKJ r SSKJ r SS KJ r SS KJr SSKJ r SS KJr SS KJr SSKrS'S jrS(SjrS)SjrS*SjrS)SjrS+SjrS(SjrS,SjrSrSrS'SjrS+Sjr S-Sjr!S.Sjr"Sr#S-Sjr$Sr%Sr&S(Sjr'S+S jr(S!r)S/S"jr*S+S#jr+S0S$jr,S1S%jr-S(S&jr.g)2zHReducer functions to generate instance props from prior state and flags.)absolute_import)division)unicode_literalsN)api_util) constants) exceptions) instances) arg_parsers) properties)filesc0[USLUSLUSLUSLUSL/5nU(dgUR5nUbXlUbXGlUb8URRR UR 55UlU(aX7lUbXWl U$)aGenerates the Active Directory configuration for the instance. Args: sql_messages: module, The messages module that should be used. domain: string, the Active Directory domain value. mode: string, the Active Directory mode value. dns_servers: list of strings, the list of dns servers. admin_credential_secret_key: string, the name of the admin credential secret manager key. organizational_unit: string, the organizational unit value. Returns: sql_messages.SqlActiveDirectoryConfig object. N) anySqlActiveDirectoryConfigdomainadminCredentialSecretNameModeValueValuesEnumlookup_by_nameuppermode dnsServersorganizationalUnit) sql_messagesrr dns_serversadmin_credential_secret_keyorganizational_unitshould_generate_configconfigs 8lib/googlecloudsdk/api_lib/sql/instance_prop_reducers.pyActiveDirectoryConfigr$s. D $!-%     0 0 2& M ,'B$ 77KKZZ FK#$ 3 -cUcUcUcgUR5nUbXlUb[R"U5S-UlUb[R"U5S-UlU$)aiGenerates the Audit configuration for the instance. Args: sql_messages: module, The messages module that should be used. bucket: string, the GCS bucket name. retention_interval: duration, how long to keep generated audit files. upload_interval: duration, how often to upload generated audit files. Returns: sql_messages.SqlServerAuditConfig object. Ns)SqlServerAuditConfigbucketsix text_typeretentionIntervaluploadInterval)rr$retention_intervalupload_intervalrs rr#r#Usn  ^*27N   , , .& M#"}}-?@3FF MM/:S@F -r cU(aURSSS9$UcUcgUR5nUbXlUbX$lU$)abGenerates the Entra ID configuration for the SQL Server instance. Args: sql_messages: module, The messages module that should be used. tenant_id: string, the Entra ID tenant ID. application_id: string, the Entra ID application ID. clear_entraid_config: If true, clear the Entra ID config. Returns: sql_messages.SqlServerEntraIdConfig object. )tenantId applicationIdN)SqlServerEntraIdConfigr-r.)r tenant_idapplication_idclear_entraid_configrs rr/r/ss_$  . . /  N2   . . 0&O) -r c [USLUUSLUSLUSLUSLU(+/5n U (dgU(aURR(dURSSUS9n OURRn U RURR R :Hn U (aU (a[R"S5eUb X;l SU l U(a XKl SU l Ub[U R=(d UR5n URRRU lX}lXl SU l Ub XlSU l U(d-Uc U(dUcUb[R"S5eSU l UbX[lUbXklU R*bUU lU(a8U R&(d'U R((d[R"S 5eU $) aGenerates the backup configuration for the instance. Args: sql_messages: module, The messages module that should be used. instance: sql_messages.DatabaseInstance, the original instance, if the previous state is needed. backup_enabled: boolean, True if backup should be enabled. backup_location: string, location where to store backups by default. backup_start_time: string, start time of backup specified in 24-hour format. enable_bin_log: boolean, True if binary logging should be enabled. enable_point_in_time_recovery: boolean, True if point-in-time recovery (using write-ahead log archiving) should be enabled. retained_backups_count: int, how many backups to keep stored. retained_transaction_log_days: int, how many days of transaction logs to keep stored. patch_request: boolean, True if this is a patch request. Returns: sql_messages.BackupConfiguration object, or None Raises: ToolException: Bad combination of arguments. Nzsql#backupConfigurationz00:00)kind startTimeenabledzZBackup configuration cannot be changed for instances with a BackupDR backup plan attached.TzArgument --no-backup not allowed with --backup-location, --backup-start-time, --retained-backups-count, or --retained-transaction-log-daysFzArgument --retained-transaction-log-days only valid when transaction logs are enabled. To enable transaction logs, use --enable-bin-log for MySQL, and use --enable-point-in-time-recovery for Postgres and SQL Server.)rsettingsbackupConfigurationBackupConfiguration backupTierBackupTierValueValuesEnumENHANCEDsql_exceptions ArgumentErrorlocationr6r5backupRetentionSettingsBackupRetentionSettingsRetentionUnitValueValuesEnumCOUNT retentionUnitretainedBackupstransactionLogRetentionDaysbinaryLogEnabledpointInTimeRecoveryEnabledreplicationLogArchivingEnabled)rinstancebackup_enabledbackup_locationbackup_start_timeenable_bin_logenable_point_in_time_recoveryretained_backups_countretained_transaction_log_days patch_requestr backup_config gcbdr_managedbackup_retention_settingss rr9r9s FT!D #4/D(#4/    **>> 44 &5 M %%99M  ) ) C C L LM }  & & !   , M/ M'-- /,,./;.R.R.o.o.u.u+0F-,E) M".0M- M #'8*%1  ( ( , --"M%3""./L,33? '2$,,66  & & '  r c/nU(aB[UR55H#upVURURXVS95 M% U$U(a/nU$U(a URnU$)apGenerates the database flags for the instance. Args: sql_messages: module, The messages module that should be used. settings: sql_messages.Settings, the original settings, if the previous state is needed. database_flags: dict of flags. clear_database_flags: boolean, True if flags should be cleared. Returns: list of sql_messages.DatabaseFlags objects namevalue)sorteditemsappend DatabaseFlags databaseFlags)rr7database_flagsclear_database_flags updated_flagsrXrYs rr]r]sr - 4 4 67 <5545MN8  M **M r cf/nU(a'UH!nURURUS95 M# U$)zGenerates the tags for the instance. Args: sql_messages: module, The messages module that should be used. tags: list of tags. Returns: list of sql_messages.Tags objects )tag)r\Tags)rtags updated_tagsrcs rrdrd/s:, ,+++45 r cpUnUnUn[XVU/5(dgURSS9nU(a,UR(aURR(d#UcUcUcUb[R "SS5eU(aiURR RURR RURR RS.n XUl U(a7[RRRU5n U S:XaSn XlUbXxlU$)a=Generates the maintenance window for the instance. Args: sql_messages: module, The messages module that should be used. instance: sql_messages.DatabaseInstance, The original instance, if it might be needed to generate the maintenance window. maintenance_release_channel: string, which channel's updates to apply. maintenance_window_day: string, maintenance window day of week. maintenance_window_hour: int, maintenance window hour of day. Returns: sql_messages.MaintenanceWindow or None Raises: argparse.ArgumentError: no maintenance window specified. Nzsql#maintenanceWindow)r4zlThere is currently no maintenance window on the instance. To add one, specify values for both day, and hour.)week5 productionpreviewr)rMaintenanceWindowr7maintenanceWindowargparser>UpdateTrackValueValuesEnumrhstablecanary updateTrackr DayOfWeekDAYSindexdayhour) rrJmaintenance_release_channelmaintenance_window_daymaintenance_window_hourchannelrvrwmaintenance_windownamesday_nums rrlrlAs(* ('# $ gD ! " " #55 "6$ (++    - - ) #/  " " ? @@   * * E E K K  * * E E L L  * * E E L L  E&+^"##((..s3G!|g$ " r cbSnU(acUR(aRURR(a7URRS(aURRSnUR5nU(aLUnU(a[U5 X&lU(a[U5 X6lU(a[ U5 XFlU$U(aU(d[R"SS5e[U5 X&l[U5 X6lU(a[ U5 XFlU$)aGenerates the deny maintenance period for the instance. Args: sql_messages: module, The messages module that should be used. instance: sql_messages.DatabaseInstance, The original instance, if it might be needed to generate the deny maintenance period. deny_maintenance_period_start_date: date, Date when the deny maintenance period begins, i.e., 2020-11-01. deny_maintenance_period_end_date: date, Date when the deny maintenance period ends, i.e., 2021-01-10. deny_maintenance_period_time: Time when the deny maintenance period starts/ends, i.e., 05:00:00. Returns: sql_messages.DenyMaintenancePeriod or None Raises: argparse.ArgumentError: invalid deny maintenance period specified. NrzqThere is no deny maintenance period on the instance. To add one, specify values for both start date and end date.) r7denyMaintenancePeriodsDenyMaintenancePeriod ValidateDate startDateendDate ValidTimetimernr>)rrJ"deny_maintenance_period_start_date deny_maintenance_period_end_datedeny_maintenance_period_timeold_deny_maintenance_perioddeny_maintenance_periods rrrs0!%8$$....q1"*"3"3"J"J1"M(>>@ 9)56*L''34(H%#,-%A"" !  / ,  " " J KK34(J%12&F##,-%A"  r c[RRUS5 g![a [R"SS5ef=f)Nz%H:%M:%Sz2Invalid time value. The format should be HH:mm:SS.datetimestrptime ValueErrorrnr>r"s rrrsJD q*- D   B DDDs #"Ac[RRUS5$![aI [RRUS5s$![a [R"SS5ef=ff=f)Nz%Y-%m-%dz%m-%dz=Invalid date value. The format should be yyyy-mm-dd or mm-dd.rrs rrrs}Q    % %a 44 QQ    ' '7 33 Q  " " O QQQQs " A5A A5"A11A5c[USLUSLUSLUSLUSL/5nU(dgUR5nUbUUlUbX'lUbUUlUbXGlUbXWlU$)aGenerates the insights config for the instance. Args: sql_messages: module, The messages module that should be used. insights_config_query_insights_enabled: boolean, True if query insights should be enabled. insights_config_query_string_length: number, length of the query string to be stored. insights_config_record_application_tags: boolean, True if application tags should be recorded. insights_config_record_client_address: boolean, True if client address should be recorded. insights_config_query_plans_per_minute: number, number of query plans to sample every minute. Returns: sql_messages.InsightsConfig or None N)rInsightsConfigqueryInsightsEnabledqueryStringLengthrecordApplicationTagsrecordClientAddressqueryPlansPerMinute)r&insights_config_query_insights_enabled#insights_config_query_string_length'insights_config_record_application_tags%insights_config_record_client_address&insights_config_query_plans_per_minuterinsights_configs rrrs2,D8)5-T9+47,D8   !//1/+7.((4(K%,8/)*6*O'+7*P' r c(UcgURUS9$)z?Generates the db aligned atomic writes Config for the instance.N)dbAlignedAtomicWrites)DbAlignedAtomicWritesConfig)rdb_aligned_atomic_writess rrrs&%   1 14 2 r c4[USLUSLUSL/5(agU=(d UR5nUbXlUbJ/n[UR 55H#upxUR UR XxS95 M% XelU$U(a/UlU$)z9Generates the connection pooling config for the instance.NrW)allConnectionPoolConfigconnectionPoolingEnabledrZr[r\ConnectionPoolFlagsflags) renable_connection_poolingconnection_pool_flagsclear_connection_pool_flagscurrent_configconnection_pool_configrarXrYs rrrs 4't#!T)  )P\-N-N-P*6O3&M399;<   * * * B=$1  ##% r c [USLUSLUSLUSLUSLUSLUSL/5(agU=(d UR5n UbU(aSU lOURSS9$UbX)lUbX9lUbJ/U lUR 5H/un n U R RURU U S95 M1 UbXYl UbUU l UbUU l U $)z;Generates the read pool auto-scale config for the instance.NTF)r6)metric targetValue) rReadPoolAutoScaleConfigr6 minNodeCount maxNodeCount targetMetricsr[r\ TargetMetricdisableScaleInscaleInCooldownSecondsscaleOutCooldownSeconds) rauto_scale_enabledauto_scale_min_node_countauto_scale_max_node_countauto_scale_target_metricsauto_scale_disable_scale_inauto_scale_in_cooldown_secondsauto_scale_out_cooldown_secondsrread_pool_auto_scale_configrrYs rrr3s? D 4'4'4'!T)$,%-  > <<>#,0!) 1 1% 1 @@*/H,*/H,*02- # ( ( *  !//66  # # $  +!,1L.#/& 6%0' 7 %$r c(SRX5nU$)a!Creates a custom machine type from the CPU and memory specs. Args: cpu: the number of cpu desired for the custom machine type memory_mib: the amount of ram desired in MiB for the custom machine type instance Returns: The custom machine type name for the 'instance create' call zdb-custom-{0}-{1})format)cpu memory_mib machine_types r_CustomMachineTypeStringros%++C<, r cJSnU(aUnU(dU(akU(d[R"SS5eU(d[R"SS5eU(a[R"SS5e[UUS-5nUnU(dU(d[R nU$)aGenerates the machine type for the instance. Adapted from compute. Args: instance: sql_messages.DatabaseInstance, The original instance, if it might be needed to generate the machine type. tier: string, the v1 or v2 tier. memory: string, the amount of memory. cpu: int, the number of CPUs. Returns: A string representing the URL naming a machine-type. Raises: exceptions.RequiredArgumentException when only one of the two custom machine type flags are used, or when none of the flags are used. exceptions.InvalidArgumentException when both the tier and custom machine type flags are used to generate a new instance. Nz--cpuzQBoth [--cpu] and [--memory] must be set to create a custom machine type instance.z--memoryz--tierzFCannot set both [--tier] and [--cpu]/[--memory] for the same instance.i)rRequiredArgumentExceptionInvalidArgumentExceptionrrDEFAULT_MACHINE_TYPE)rJtiermemoryrrcustom_type_strings r MachineTyper~s., L F   0 0 : ;;   0 0 = >>  / / 6 772 5 &L h11L r c@URSSRX5S9$)aMGenerates the external primary configuration for the instance. Args: sql_messages: module, The messages module that should be used. source_ip_address: string, the IP address of the external data source. source_port: number, the port number of the external data source. Returns: sql_messages.OnPremisesConfiguration object. zsql#onPremisesConfigurationz{0}:{1})r4hostPort)OnPremisesConfigurationr)rsource_ip_address source_ports rrrs0  - - ( 1? . AAr c[R"[R5nURR US[ R RRR0SS9nUR5$)zGenerates the self-link of the instance's private network. Args: network: The ID of the network. Returns: string, the URL of the network. projectcompute.networks)params collection) common_api_util SqlClientAPI_VERSION_DEFAULTresource_parserParser VALUEScorer GetOrFailSelfLink)networkclient network_refs rPrivateNetworkUrlrsp  $ $_%H%H I&&&,, Z&&++33==$ -%+    r c.URSUUUR5S9nU(a[R"U5UlU(a[R"U5UlU(a[R"U5UlURSUS9$)aGenerates the config for an external primary replica. Args: sql_messages: module, The messages module that should be used. primary_username: The username for connecting to the external instance. primary_password: The password for connecting to the external instance. primary_dump_file_path: ObjectReference, a wrapper for the URI of the Cloud Storage path containing the dumpfile to seed the replica with. primary_ca_certificate_path: The path to the CA certificate PEM file. client_certificate_path: The path to the client certificate PEM file. client_key_path: The path to the client private key PEM file. Returns: sql_messages.MySqlReplicaConfiguration object. zsql#mysqlReplicaConfiguration)r4usernamepassword dumpFilePathz)sql#demoteMasterMysqlReplicaConfiguration)r4mysqlReplicaConfiguration)MySqlReplicaConfigurationToUrlr ReadFileContents caCertificateclientCertificate clientKeyReplicaConfiguration)rprimary_usernameprimary_passwordprimary_dump_file_pathprimary_ca_certificate_pathclient_certificate_pathclient_key_pathmysql_replica_configurations rrrs,!- F F *)//1 !G!3 !050F0F#1%-494J4J5!1,1,B,B-)  * * 6 ; + ==r cU(aNU(aG[R"U5n[R"U5nX4:wa[R"S5eU(a[R"U5nU$U$)a;Generates the region string for the instance. Args: specified_region: string, the GCE region to create the instance in. gce_zone: string, the GCE zone to create the instance in. secondary_zone: string, the GCE zone to create the standby instance in. Returns: string, the region to create the instance in. zKZones in arguments --zone and --secondary-zone belong to different regions.)rGetRegionFromZonerConflictingArgumentsException)specified_regiongce_zonesecondary_zoneregion_from_zoneregion_from_secondary_zonederived_regions rRegionrsj.11(;!)!;!;N!K5  4 4 ) **//9N  r cxU(a3URRRUR55$gN)PasswordValidationPolicyComplexityValueValuesEnumrr)r complexitys r_ParseComplexityr s3  0 0 J J Y Y  r c [USLUSLUSLUSLUSLUSL/5nU(aU(agUR5n UbXlUb[UU5U lUbX9lUbXIlUb[U5S-U lUbXil U $)a$Generates or clears password policy for the instance. Args: sql_messages: module, The messages module that should be used. password_policy_min_length: int, Minimum number of characters allowed. password_policy_complexity: string, The complexity of the password. password_policy_reuse_interval: int, Number of previous passwords that cannot be reused. password_policy_disallow_username_substring: boolean, True if disallow username as a part of the password. password_policy_password_change_interval: duration, Minimum interval at which password can be changed. enable_password_policy: boolean, True if password validation policy is enabled. clear_password_policy: boolean, True if clear existing password policy. Returns: sql_messages.PasswordValidationPolicy or None Nr") rr minLengthr r reuseIntervaldisallowUsernameSubstringstrpasswordChangeIntervalenablePasswordPolicy) rpassword_policy_min_lengthpassword_policy_complexitypassword_policy_reuse_interval+password_policy_disallow_username_substring(password_policy_password_change_intervalenable_password_policyclear_password_policyshould_generate_policypassword_policys rPasswordPolicyr!s: , ,$D01=.d:D(   #8 !99;/+ :+!1,2L"NO#/$B!0<0[--9-00.247.8O*'+A( r c/nUHnUR5nURS5UlURS5=n(aXTlOY[R "[R 5nURRURSS9nURUlUR(a$UR(aURU5 M[R"SS5e U$)alGenerates PSC auto connections for the instance. Args: sql_messages: module, The messages module that should be used. psc_auto_connections: dict of the allowed consumer projects and networks. Returns: list of sql_messages.PscAutoConnectionConfig objects Raises: exceptions.InvalidArgumentException when there is no valid network or project specified. rrr)rz--psc-auto-connectionsz0PSC auto connection must have network specified.) PscAutoConnectionConfiggetconsumerNetworkconsumerProjectrrrrParseRelativeNamerr\rr)rpsc_auto_connectionsupdated_psc_auto_connections connectioncurrent_psc_auto_connectionrrrs rPscAutoConnectionsr%^s""$(j"."F"F"H2<..2K/..++w+4;1(()L)LMf**<< % 5 5'=k5@4G4G!1 $33 ' 7 7"))*EF  / / "% ))0 &%r c /nU(aUH}nURSS5upVURSS5upxURURUUURRR UR 55S95 M U$U(a/nU$![an [S5U eSn A f[an [S5U eSn A ff=f)a$Generates the database flags for the instance. Args: sql_messages: module, The messages module that should be used. unc_mappings: input unc mappings from the user. clear_unc_mappings: boolean, True if unc mappings should be cleared. Returns: list of sql_messages.UncMapping objects :=)uncPathgcsPathrz=Invalid UNC mapping input. Expected 'unc-path=gcs-path:mode'.Nz;Invalid mode. Expected 'snapshot_read' or 'snapshot_write'.) rsplitsplitr\ UncMappingrrrrKeyError) r unc_mappingsclear_unc_mappingsupdated_mappings mapping_strrestmode_strunc_pathgcs_pathes r UncMappingsr9s# $++C3!ZZQ/  # #  !,,@@OONN$ $  $0   K   I  s$A9B C$ B00 C= C  Cc UcgU=(d UR5nSS0nSSSSSS.n[UR55HpupgXd;a"[X4UUR 5S :H5 M,Xe;a[X5U[ U55 ML[R"S S RU55e U$![ a' [R"S S RXg55ef=f) aGenerates the performance capture config for the instance. Args: sql_messages: module, The messages module that should be used. performance_capture_config: dict of the performance capture config. current_config: sql_messages.PerformanceCaptureConfig, the original performance capture config, if the previous state is needed. Returns: sql_messages.PerformanceCaptureConfig object, or None Raises: exceptions.InvalidArgumentException: If an unknown key is provided in performance_capture_config. Nr6probingIntervalSecondsprobeThresholdrunningThreadsThresholdsecondsBehindSourceThresholdtransactionDurationThreshold)zprobing-interval-secondszprobe-thresholdzrunning-threads-thresholdzseconds-behind-source-thresholdztransaction-duration-thresholdtruez--performance-capture-configz(Invalid integer value for key [{0}]: {1}zUnknown key: {0}) PerformanceCaptureConfigrZr[setattrlowerintrrrr)rperformance_capture_configrr bool_keysint_keyskeyrYs rrArAs* '   D\BBD&)#;)#<)G(F (5;;=>jc  fnekkmv&=>   s5z2  / / (*<*C*CC*H ? - 11 * 6 = =c I   s 5B991C*cd[USLUSL/5nU(dgUb U(dUb[R"S5eU(aURR(dUR 5nOURRnUbX%lUb X5lSUlUbU(dSUlU$)a Generates the Final Backup configuration for the instance. Args: sql_messages: module, The messages module that should be used. instance: sql_messages.DatabaseInstance, the original instance, if the previous state is needed. final_backup_enabled: boolean, True if final backup should be enabled. final_backup_retention_days: int, how many days to retain the final backup. Returns: sql_messages.FinalBackupConfiguration object, or None Raises: sql_exceptions.ArgumentError: Bad combination of arguments. NzPYou cannot set final-backup-retention-days while final-backup field is disabled.T)rr=r>r7finalBackupConfigFinalBackupConfigr6 retentionDays)rrJfinal_backup_enabledfinal_backup_retention_daysrfinal_backup_configs rFinalBackupConfigurationrPs*$&!-  %.B".  ( ( \  **<<&88:"++==%"6 ,(C%"&%.B(,% r )NNNNN)NNN)NNF) NNNNNNNNFr)NNz00:00:00)NNNN)NNNNNNNN)NNNNNNN)NF)NN)/__doc__ __future__rrrrnrgooglecloudsdk.api_lib.sqlrrrrr=r googlecloudsdk.callioper googlecloudsdk.corer googlecloudsdk.core.utilr r%rr#r/r9r]rdrlrrrrrrrrrrrrrr rr%r9rArPr rrXsO''B0C</.**   $ .d!%,0)-@ J"&"&z| !%',8(37-1.2 ;@>B;?7A >!BDQ;?7;;?9=:> 2j# $  H""" $#'$(9%x 5p A  .6:15)- &=R0 $##'04-1:~*&Z%T $6v $ 6r