!4SrSSKJr SSKJr SSKJr SSKJr SSKJr SSK J r SSK J r SS K J r SS KJr SS KJr SS KJr SS KJr SSKJr SSKJr SS0rSSjrSrSr\ R8\ R:"SS\ R<555rg)z$Command for spanner databases query.)absolute_import)division)unicode_literals)database_sessions)apis) arg_parsers)base) exceptions) resource_args)sql) QueryHasDml) arg_utils)log) resourcesEXAMPLESz To execute a SQL SELECT statement against example-database under example-instance, run: $ {command} example-database --instance=example-instance --sql='SELECT * FROM MyTable WHERE MyKey = 1' Nc[R"URRR 5U5n[ R RURSS9$)aCreates a session. Args: args: an argparse namespace. All the arguments that were provided to the command invocation. database_role: Cloud Spanner database role which owns this session. Returns: A session reference to be used to execute the sql. z-spanner.projects.instances.databases.sessions) relative_name collection) rCreateCONCEPTSdatabaseParserREGISTRYParseRelativeNamename)args database_role session_names ,lib/surface/spanner/databases/execute_sql.py CreateSessionr -sX#))$--*@*@*F*F*H*79,    - - %%@ . BBc[R"US5 URSSSS9 SSSS S S .nURS S SUSS9 URSSSS9 URS[R"5SSS9 [ R "SS5n[U5RRU5 URSSS9nURSSSS9 URSS S!S"9 URS#S$S%9 g&)'zyParses provided arguments to add base arguments used for both Beta and GA. Args: parser: an argparse argument parser. z to execute the SQL query againstz--sqlTz|The SQL query to issue to the database. Cloud Spanner SQL is described at https://cloud.google.com/spanner/docs/query-syntax)requiredhelpzLReturns only the query result, without any information about the query plan.zYReturns only the query plan, without any result rows or execution statistics information.zvReturns the query plan, overall execution statistics, operator-level execution statistics, along with the result rows.zYReturns the overall (but not operator-level) execution statistics along with the results.zfReturns the query plan, overall (but not operator-level) execution statistics, along with the results.)NORMALPLANPROFILE WITH_STATSWITH_PLAN_AND_STATSz --query-moder%c"UR5$N)upper)xs rAddBaseArgs..gs QWWYr!z*Mode in which the query must be processed.)defaulttypechoicesr$z--enable-partitioned-dml store_truez+Execute DML statement using Partitioned DML)actionr$z --timeout10mzuMaximum time to wait for the SQL query to complete. See $ gcloud topic datetimes for information on duration formats.)r1r0r$spannerv1zuRead-only query timestamp bound. The default is --strong. See https://cloud.google.com/spanner/docs/timestamp-bounds.)mutexr$--strongzPerform a strong query.--read-timestamp TIMESTAMPz'Perform a query at the given timestamp.)metavarr$z--database-rolez8Database role user assumes while accessing the database.)r$N) r AddDatabaseResourceArg add_argumentrDurationrGetMessagesModuleGetRequestPriorityMapper choice_arg AddToParseradd_argument_group)parserquery_mode_choicesmsgstimestamp_bound_groups r AddBaseArgsrI?so &&v'IK  HI  . M $ 0%.   7 9   8:      ! B C    4 0$4 ++77? 33  E4F$$  $%&$$ 4%6  EGr!c b[R"SURRSSSSS.SS9$) Nz --prioritylowmediumhigh unspecified) PRIORITY_LOWPRIORITY_MEDIUM PRIORITY_HIGHPRIORITY_UNSPECIFIEDz)The priority for the execute SQL request.)custom_mappingshelp_str)rChoiceEnumMapperRequestOptionsPriorityValueValuesEnum)messagess rrArAs=  # #55%!"/  ;  r!c>\rSrSrSr\r\S5rSr Sr Sr Sr g) Queryz6Executes a SQL query against a Cloud Spanner database.c[U5 g)zSee base class.N)rI)rEs rArgs Query.Argss r!c [R"SS5nUR[U5R UR 5S9nUR U5n[XR5n[R"URURUUUURUR5[R"U5 $![R"U5 f=f)zRuns this command. Args: args: an argparse namespace. All the arguments that were provided to this command invocation. Returns: Some value that we want to have printed later. r6r7)priority)rr@rVrAGetEnumForChoicer`ParseReadOnlyOptionsr rr ExecuteSqlr query_modeenable_partitioned_dmltimeoutDelete)selfrrGrequest_optionsread_only_optionssessions rRun Query.Runs  ! !)T 2D)))$/@@O*O11$7D"4"45G (  ) ) (( //     % % ,,w'w's 0AC C"c0[UR5(a[URS5(a[R"SS5eURS5(a[R"SS5eg[ R "SS5nURS5(aURURS 9$URS5(a7UR(d[R"SS 5eURS S 9$URS S 9$) zParses the options for a read-only request from command line arguments. Args: args: Command line arguments. Returns: A ReadOnly message if the query is read-only (not DML), otherwise None. strongr9z:A timestamp bound cannot be specified for a DML statement.read_timestampr:Nr6r7) readTimestampzW`--strong` cannot be set to false. Instead specify a different type of timestamp bound.T)ro) r r IsSpecified c_exceptionsInvalidArgumentExceptionrr@ReadOnlyrpro)rhrrGs rrbQuery.ParseReadOnlyOptionss488  ( # #33  H     * + +33  H    # #It 4d  * + +}}4+>+>}??   H % %{{55E  d+ +}}D}))r!c0URS:H=(d% URS:H=(d URS:HnURS:gn[R"U5(a9[R"URR [ R5 U(a%[R"U[ R5 U(aE[R"X!RS:Xa[ RO[ R5 gg)aDisplays the server response to a query. This is called higher up the stack to over-write default display behavior. What gets displayed depends on the mode in which the query was run. 'NORMAL': query result rows 'PLAN': query plan without execution statistics 'PROFILE': query result rows and the query plan with execution statistics Args: args: The arguments originally passed to the command. result: The output of the command before display. r&r'r)N) rdr QueryHasAggregateStatsDisplayQueryAggregateStatsstats queryStatsroutDisplayQueryPlanDisplayQueryResultsstatus)rhrresult display_plandisplay_resultss rDisplay Query.Displays 6! 4 ??i ' 4 ??3 3 oo/O !!&)) $$V\\%<%rs+&'<,/(><2>:#)  B$IGX eDLLeer!