'MdZddlmZddlmZddlmZddlmZddlm Z ddlmZ ddlm Z ddlm Z dd lmZddlmZdd lmZdd lmZdd lmZddlm Zdd lmZddlmZddlmZddlmZddlmZddl Z dZ!ddiZ"dZ#dZ$dZ%dZ&ejNejPejRjTGddejVZ,ejPejRjZejNGddejVZ.ejPejRj^ejNGddejVZ0y) !Creates a new Cloud SQL instance.)absolute_import)division)unicode_literals) exceptions)api_util) operations)validate)base) resource_args)flags) instances) labels_util)log) properties) resource_lex)resource_propertyNiEXAMPLESa To create a MySQL 8.0 instance with ID ``prod-instance'' that has 2 CPUs, 4 GB of RAM, and is in the region ``us-central1'' (a zone will be auto-assigned), where the 'root' user has its password set to ``password123'', run: $ {command} prod-instance --database-version=MYSQL_8_0 --cpu=2 --memory=4GB --region=us-central1 --root-password=password123 To create a Postgres 15 instance with ID ``prod-instance'' that has 2 CPUs, 8 GiB of RAM, and is in the zone ``us-central1-a'', where the 'postgres' user has its password set to ``password123'', run: $ {command} prod-instance --database-version=POSTGRES_15 --cpu=2 --memory=8GiB --zone=us-central1-a --root-password=password123 To create a SQL Server 2022 Express instance with ID ``prod-instance'' that has 2 CPUs, 3840MiB of RAM, and is in the zone ``us-central1-a'', where the 'sqlserver' user has its password set to ``password123'', run: $ {command} prod-instance --database-version=SQLSERVER_2022_EXPRESS --cpu=2 --memory=3840MiB --zone=us-central1-a --root-password=password123 ctjj||jj t j t j|t j|t j|t j|t j|t j|t j|t j|dt j|t j |t j"|t j$|dt j&|t j(|t j*||j-dt/j0dt j2|t j4|t j6|t j8|t j:|t j<|t j>|dt j@|t jB|dt jD|dt jF|t jH|t jJ|t jL|t jN|t jP|t jR|t jT|t jV|t jX|t jZ|t j\|t j^|t j`|t jb|t jd|t jf|t jh|dd d d d }tkjl|d| t jn|t jp|t jr|t jt|t jv|t jx|t jz|t|t j~|dt j|t j|t j|t j||j}t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|t j|dt j|dt j|dt j|dt j|dt j|t j|t j|t j|t j|y)z>Declare flag and positional arguments for this command parser.F) allow_empty)show_negated_in_helpinstancezCloud SQL instance ID.)typehelpT--disk-encryption-keyz--disk-encryption-key-keyringz--disk-encryption-key-locationz--disk-encryption-key-project)zkms-keyz kms-keyringz kms-locationz kms-project)flag_overrideshiddenN)^r ASYNC_FLAG AddToParser display_info AddFormatr GetInstanceListFormatAddActivationPolicyAddActiveDirectoryDomain AddAssignIpAddAuthorizedNetworksAddAvailabilityType AddBackupAddBackupStartTimeAddBackupLocationAddCPUAddInstanceCollationAddDatabaseFlagsAddEnableBinLogAddRetainedBackupsCountAddRetainedTransactionLogDaysAddFailoverReplicaName add_argumentcommand_validateInstanceNameRegexpValidatorAddMaintenanceReleaseChannelAddMaintenanceWindowDayAddMaintenanceWindowHour!AddDenyMaintenancePeriodStartDateAddDenyMaintenancePeriodEndDateAddDenyMaintenancePeriodTime%AddInsightsConfigQueryInsightsEnabled"AddInsightsConfigQueryStringLength&AddInsightsConfigRecordApplicationTags$AddInsightsConfigRecordClientAddress$AddInsightsConfigQueryPlansPerMinuteAddMasterInstanceName AddMemoryAddPasswordPolicyMinLengthAddPasswordPolicyComplexityAddPasswordPolicyReuseInterval*AddPasswordPolicyDisallowUsernameSubstring'AddPasswordPolicyPasswordChangeInterval%AddPasswordPolicyEnablePasswordPolicyAddReplicaTypeAddReplication AddRequireSslAddRootPasswordAddStorageAutoIncreaseAddStorageSizeAddStorageTypeAddTier AddEditionkms_resource_argsAddKmsKeyResourceArgAddEnablePointInTimeRecovery AddNetworkAddSqlServerAuditAddDeletionProtectionAddSqlServerTimeZoneAddConnectorEnforcement AddTimeout"_INSTANCE_CREATION_TIMEOUT_SECONDSAddEnableGooglePrivatePathAddThreadsPerCoreAddCascadableReplicaAddEnableDataCache!AddRecreateReplicasOnPrimaryCrash add_groupAddEnablePrivateServiceConnectAddAllowedPscProjects AddCustomSubjectAlternativeNames AddSslModeAddEnableGoogleMLIntegrationAddEnableDataplexIntegrationAddPscAutoConnectionsAddServerCaModeAddTagsAddRetainBackupsOnDeleteAddServerCaPoolAddStorageProvisionedIopsAddStorageProvisionedThroughputAddInstanceType AddNodeCountAddActiveDirectoryMode"AddActiveDirectorySecretManagerKey$AddActiveDirectoryOrganizationalUnitAddActiveDirectoryDNSServersClearActiveDirectoryDNSServersAddForceSqlNetworkArchitectureAddFinalBackupAddFinalbackupRetentionDaysAddEnableConnectionPoolingAddConnectionPoolFlags)parserkms_flag_overridespsc_setup_groups #lib/surface/sql/instances/create.py AddBaseArgsrCs //f% ; ; =>F#  (Ff%F#//&6"&e4,,vV$ U;'%%f-v&  7 7 9 # $$V,'  ())&1''/$$V,--f4P**62.. 4,,V$O,,V4f%//&""6*##F+&&v.226://7--f5vvfv&vv--6(464  (( j);$$V,6&!f%V$'6=>""6F&!V$6"))&1$$&/&&7o.((06$$V,$$V,f%--  (!!&)''/Vvd3**6$?,,VDA$$VD9&&vd;&&v.v##F+""6*v&cTtj|tj|tj|t j |tj |tj|tj|tj|y)zCDeclare beta flag and positional arguments for this command parser.N) r AddExternalMasterGroupAddInstanceResizeLimitAddAllocatedIpRangeNamerAddCreateLabelsFlags&AddReplicationLagMaxSecondsForRecreateAddEnableDbAlignedAtomicWritesAddEnableAcceleratedReplicaModeAddEnableAutoUpgrader{s r~ AddBetaArgsrsrv&v&' ""6*..v6&&v.''/V$rc2tj|dy)z,Declare alpha flags for this command parser.TrN)r AddReadPoolAutoScaleConfigrs r~ AddAlphaArgsrs""6$7rctjtj}|j}|j}t j |jt j||jj|jdtjjjjid}|j!dri|jj|j"dtjjjjid} |j$j'|j)|j|j}|j!d s|jD|_"|j!d s|jFjH|_%|j!d sI|j!ds8|j!ds'|jLr|jLjN|_'|jQdr:|jFjHjSdstUjVd|jXrm|jD|jDk(rt[j\ddnc|j!dst7j^ddt[j\dn&|j!drtUjVd|j!dr|jD|jDk(rt7j`dd|j!drt7j`dd|jQdrA|j!d r0|jJjSdstUjVd|j!d rB|jJjSdr'|j!dst7j^dd |jbs]|j!d!r&|j!ds;tUjVd"|j!d#rtUjVd$|jQd%r&|jQd&stUjVd'|jQd(r&|jQd&stUjVd)|jQd*r&|jQd+stUjVd,|jd:tgd-|jdvd.|jdvgrt/jhd/|j!d0rd|jjd1k(rU|jNxrt[jl|jJ} |j!d s| stUjVd2tZjnjq||||3} d} |j$js|ju| |j4}|jjwd5|jH|j6} |jxrX|j!d7sd8|_=|j|j'|j| j| j9St|jj|| d:|jJz|j;t/j||j$j'|j)|j|j}|S#t*j,$r}t/j0dt3j4|t7j8|} t;j&| j<j>tAjBddd k(rd } t7j8| d}~wwxYw#t*j,$r}t/j0dt3j4| t7j8|} t;j&| j<j>tAjBdddtAjBd=d} t7j8| d}~wwxYw)>aCreates a new Cloud SQL instance. Args: args: argparse.Namespace, The arguments that this command was invoked with. release_track: base.ReleaseTrack, the release track that this was run under. Returns: A dict object representing the operations resource describing the create operation if the create was successful. Raises: HttpException: A http error response was received while executing api request. ArgumentError: An argument supplied by the user was incorrect, such as specifying an invalid CMEK configuration or attempting to create a V1 instance. RequiredArgumentException: A required argument was not supplied by the user, such as omitting --root-password on a SQL Server instance. projectz sql.instances)params collectionmaster_instance_name)rrzoperation : %szerror.errors[0].reasonN notAuthorizedzQYou are either not authorized to access the master instance or it does not exist.regiondatabase_versiontiercpumemoryenable_accelerated_replica_modeMYSQL_z>--enable-accelerated-replica-mode is only supported for MySQL.replicazthe master instancedisk_encryption_keyrzy`--disk-encryption-key` is required when creating a cross-region replica of an instance with customer-managed encryption.zw`--disk-encryption-key` cannot be specified when creating a replica of an instance without customer-managed encryption.cascadable_replicaz--cascadable-replicazt`--cascadable-replica` can only be specified when creating a replica that is in a different region than the primary.zX`--cascadable-replica` can only be specified when `--master-instance-name` is specified. SQLSERVER root_passwordz--root-passwordzA`--root-password` is required when creating SQL Server instances.enable_bin_logzD`--enable-bin-log` cannot be specified when --no-backup is specifiedenable_point_in_time_recoveryzS`--enable-point-in-time-recovery` cannot be specified when --no-backup is specifiedallowed_psc_projectsenable_private_service_connectzD`--allowed-psc-projects` requires `--enable-private-service-connect`psc_auto_connectionszD`--psc-auto-connections` requires `--enable-private-service-connect` custom_subject_alternative_namesserver_ca_modezH`--custom-subject-alternative-names` requires customer managed server CA sync_binloginnodb_flush_log_at_trx_commitzChanging innodb_flush_log_at_trx_commit or sync_binlog may cause data loss. Check https://cloud.google.com/sql/docs/mysql/flags for more details.editionzenterprise-plusz-`--edition=enterprise-plus` requires `--tier`) instance_ref release_track)databaseInstancerzsql.operations) operationrformatdefault)rrz Creating Cloud SQL instance for )max_wait_secondserrorMaxInstancePerLabelz error.message)Ecommon_api_util SqlClientAPI_VERSION_DEFAULT sql_client sql_messagesr ValidateInstanceNamerValidateInstanceLocationresource_parserParserVALUEScorer GetOrFail IsSpecifiedrrGetSqlInstancesGetRequestapitools_exceptions HttpErrorrdebugsix text_typer HttpExceptionrpayloadcontentrParseKeyrdatabaseVersionnamersettingsrIsKnownAndSpecified startswithsql_exceptions ArgumentErrordiskEncryptionConfiguration command_utilShowCmekWarningRequiredArgumentExceptionInvalidArgumentExceptionbackupdatabase_flagsanywarningr1DoesEnterprisePlusReplicaInferTierForDatabaseTypeInstancesV1Beta4ConstructCreateInstanceFromArgsInsertSqlInstancesInsertRequestCreateasync_rr SqlOperationsGetRequestrOperationsV1Beta4WaitForOperationtimeoutCreatedResource)argsrclientrrrmaster_instance_refmaster_instance_resourceerrorexcmsgcan_infer_tierinstance_resource operation_refresult_operation new_resources r~RunBaseCreateCommandrs/&  $ $_%H%H I&  *$$,  . ##D)''-- mm**//77AA B ., ,- 0066 !!:,,1199CCD"7  !+!5!5!9!9  - -"***33 . "0   H %,33dk   . /6FFKKd   V $!!%(D,<,r$sI(&'>BC1/(.M0DG<#*5: &*"  2e'\ %8 J ZD%%(() %T\\ %* % D%%**+==,="D%%++,=$,,=-=r