gvSrSSKJr SSKJr SSKJr SSKJrJr SSKJ r SSKJ r SSK J r SS K r SS KJr SS KJr SS KJr SS KJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r! SSKJ"r" SSKJ#r# SSKJ$r$ "SS\RJ5r&g )zThe BigQuery list CLI command.)absolute_import)division)print_function)DictOptional)app)flags)overrideN)client_connection)client_data_transfer)client_dataset) client_job) client_model)client_project)client_reservation)client_routine)client_row_access_policy) client_table)utils)bigquery_command)bq_cached_client) utils_flags)utils_id)bq_error) bq_id_utils)bq_processor_utilsc^\rSrSrSrS\S\R4U4SjjrS S\S\ \ 4Sjjr \ S\ \\44S j5rS rU=r$) ListCmd)z1ls [(-j|-p|-d)] [-a] [-n ] []namefvc>[[U] X5 [R"SSSSUS9 [R"SSSUS9 [R"SS S S US9 [R "S SS SUS9 [R "SSSUS9 [R "SSSUS9 [R"SS SSUS9 [R"SS SSUS9 [R"SS SSUS9 [R"SS SUS9 [R"SS SUS9 [R "S SS!US9 [R"S"S S#US9 [R"S$S S%US9 [R "S&S'S(US9 [R"S)S S*US9 [R "S+SS,US9 [R "S-SS.S/US9 [R"S0S S1US9 [R"S2S S3US9 [R "S4SS5US9 [R"S6SS7US9 [R"S8SS9US9 [R"S:SS;US9 [R"SSS?US9 [R "S@SSAUS9 [R"SBSSCUS9 [R"SDS SEUS9 URU5 g)FNallzShow all results. For jobs, will show jobs from all users. For datasets, will list hidden datasets.For transfer configs and runs, this flag is redundant and not necessary.a) short_name flag_valuesall_jobszDEPRECATED. Use --all instead)r&jobsFz'Show jobs described by this identifier.j max_resultszMaximum number to list.nmin_creation_timezDTimestamp in milliseconds. Return jobs created after this timestamp.max_creation_timezETimestamp in milliseconds. Return jobs created before this timestamp.projectszShow all projects.pdatasetsz+Show datasets described by this identifier.dmodelszShow all models.mroutineszShow all routines.row_access_policieszShow all row access policies.transfer_locationz7Location for list transfer config (e.g., "eu" or "us").transfer_configzeShow transfer configurations described by this identifier. This requires setting --transfer_location. transfer_runzList the transfer runs. run_attemptLATESTzFor transfer run, respresents which runs should be pulled. See https://cloud.google.com/bigquery/docs/reference/datatransfer/rest/v1/projects.transferConfigs.runs/list#RunAttempt for details transfer_logz%List messages under the run specified message_typezusage:- messageTypes:INFO For transferlog, represents which messages should be listed. See https://cloud.google.com/bigquery/docs/reference/datatransfer/rest/v1/projects.transferConfigs.runs.transferLogs#MessageSeverity for details. page_tokenz#Start listing from this page token.kprint_last_tokenz:If true, also print the next page token for the jobs list.print_unreachablezQIf true, also print unreachable locations for the dataset list and the jobs list.filterarFilters resources based on the filter expression. For datasets, use a space-separated list of label keys and values in the form "labels.key:value". Datasets must match all provided filter expressions. See https://cloud.google.com/bigquery/docs/filtering-labels#filtering_datasets_using_labels for details For transfer configurations, the filter expression, in the form "dataSourceIds:value(s)", will show transfer configurations with the specified dataSourceId. For transfer runs, the filter expression, in the form "states:VALUE(s)", will show transfer runs with the specified states. See https://cloud.google.com/bigquery/docs/reference/datatransfer/rest/v1/TransferState for details. For jobs, the filter expression, in the form "states:VALUE(s)", will show jobs with the specified states. See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobStatus for details. reservationz9List all reservations for the given project and location.capacity_commitmentzOLists all capacity commitments (e.g. slots) for the given project and location.reservation_assignmentz;List all reservation assignments for given project/locationreservation_groupz?List all reservation groups for the given project and location.reservation_group_nameziReservation group name used as a filter when listing reservation. Used in conjunction with --reservation. parent_job_idzfOnly show jobs which are children of this parent job; if omitted, shows all jobs which have no parent. connectionz/List all connections for given project/locationmigration_workflowz@List all migration workflows for the given project and location.) superr__init__r DEFINE_booleanDEFINE_integer DEFINE_string DEFINE_bool_ProcessCommandRc)selfr r! __class__s $platform/bq/frontend/command_list.pyrKListCmd.__init__,so '4!$+      D9r  1   !   N    O   E/CR  5  %+ E/R  '    A     5  8b    /        -   D         %*14  C         E    I      .    /   9    J   2 identifierreturnc P![R"URURUR5(a[ R "S5eUR(aU(a[ R "S5eURbURUl[RR5nU(a[R"X!S9nO[R"X!S9nUR (aK["R$"U["R&R(SU<S[+U5R,<3SS9 O[/U["R&R(5(a[R0"X!S9n["R$"U[+S5["R&R2["R&R44SU<S [+U5R,<3SS9 UR(a9[/U["R&R45(aUR75nUR8nSnSnUR(a["R&R:n[R6"X!S9n["R$"U["R&R2S U<S 3SS9 [<R>"UR@5n[BRD"UUURFURUURHURJUURLS 9 nUROS 5nG O^URP(a["R&RRn[R0"X!S9n[TRV"URY5UURFUS9n SU ;aU SnSU ;a[RZ"U 5 G OUR\(a["R&R^n[R0"X!S9n[`Rb"URe5UURFUUR@S9n SU ;aU SnSU ;a[RZ"U 5 G O%URf(a["R&Rhn[Rj"UU(aUOS[lRnRpSS9n[rRt"URw5UURFURxS9n SU ;aU SnO [{S5 SU ;a[RZ"U 5 G OSUR~(a["R&Rn[R"UU[lRnRpSS9n[rR"URw5UURFURxS9n SU ;aU SnO [{S5 SU ;a[RZ"U 5 GOUR(GafSn ["R&Rn[Rj"UU[lRnRpSS9n[rR"URw5US9n U /nU (a'S U ;a![U S 5n U S!- n [{S"U -5 URb.[R"[lRR5 [rR"URw5UURFURxURS$9n S%U ;aU S%O/nU(d [{S'5 U (aSU ;a[RZ"U 5 GOUR(a["R&Rn[R"UU[lRnRpSS(9n[R"[lRR5 [rR"URw5UURFURxS)9n S*U ;aU S*nO [{S+5 SU ;a[RZ"U 5 GOUR(Ga(["R&Rn[R6"U[R"X!5S9n["R$"U["R&R2S-U<S 3SS9 URc[ R "S.5e[R"UR5UURURFUUR@S/9n URF(a1[U 5S0:Xa"[U S1S29n[RZ"U5 U S3nGOUR(a["R&RnURn[R"X!5n["R&RUS49n[R"UR5UUURFURxUR@S59nURF(a1[U5S0:Xa"[US1S29n[RZ"U5 US3nGOUR(a["R&Rn[R"X!5n["R&RUS69n[R"UR5UURURFURxS79nURF(a1[U5S0:Xa"[US1S29n[RZ"U5 US3nGOUR(a["R&Rn[R"UR5[lRRp[lRnRpURFURxS89nS9U;aUS9nO [{S:5 SU;a[RZ"U5 GO4UR (az["R&Rn[R"UUURFURxS;9n S5eSnURS?S@SA[lRnRp0SB9 GO4UR(a/[R6"X!S9n["R&R4nOUR(dUcW["R&R2nURSCS@5 [R"URURFUSD9nO[/U["R&R25(a["R&R4nOE["R&R(n[R"URUURFUSE9nU["R&R4LaeURSFS@5 [R"URUUURFURUUR@SG9nUROSF5nU(d"UR(dUR(aUce[R"UUUUSH9 gg![Ra SnGNf=f![Ra GNf=f![|a#n [R"SU<SU <35eSn A ff=f![|a#n [R"SU<SU <35eSn A ff=f![Ra G NO[|a#n [R"S#U<SU <35eSn A ff=f![|a#n [R"S&U<SU <35eSn A ff=f![|a#n [R"S,U<SU <35eSn A ff=f)IaYList the objects contained in the named collection. List the objects in the named project or dataset. A trailing : or . can be used to signify a project or dataset. * With -j, show the jobs in the named project. * With -p, show all projects. Examples: bq ls bq ls -j proj bq ls -j --filter:'states:RUNNING,PENDING' proj bq ls -p -n 1000 bq ls mydataset bq ls -a bq ls -m mydataset bq ls --routines mydataset bq ls --row_access_policies mytable (requires whitelisting) bq ls --filter labels.color:red bq ls --filter 'labels.color:red labels.size:*' bq ls --transfer_config --transfer_location='us' --filter='dataSourceIds:play,adwords' bq ls --transfer_run --filter='states:SUCCEEDED,PENDING' --run_attempt='LATEST' projects/p/locations/l/transferConfigs/c bq ls --transfer_log --message_type='messageTypes:INFO,ERROR' projects/p/locations/l/transferConfigs/c/runs/r bq ls --capacity_commitment --project_id=proj --location='us' bq ls --reservation --project_id=proj --location='us' bq ls --reservation_assignment --project_id=proj --location='us' bq ls --reservation_assignment --project_id=proj --location='us' bq ls --reservation_group --project_id=proj --location='us' bq ls --connection --project_id=proj --location=us bq ls --migration_workflow --project_id=proj --location=us z.Cannot specify more than one of -j, -p, or -d.z$Cannot specify an identifier with -pN) id_fallbacksrVzInvalid identifier "z<" for ls, cannot list row access policies on object of type T)is_usage_errorz-" for ls, cannot call list on object of type z)Cannot determine job(s) associated with "") bqclient referencer* all_users state_filterr,r-r=rGresults) model_clientr]r*r=r2 nextPageToken)routines_api_clientr]r*r=filter_expressionr4- )rYrVdefault_locationdefault_reservation_id)clientr] page_sizer= assignmentsz!No reservation assignments found.z(Failed to list reservation assignments 'z': )rYrVrgdefault_capacity_commitment_idcapacityCommitmentszNo capacity commitments found.z%Failed to list capacity commitments ')rir]sizei@zBI Engine reservation: %sGBz Failed to list BI reservations ')rir]rjr=rE reservationszFailed to list reservations 'zNo reservations found.)rYrVrgdefault_reservation_group_id)reservation_group_clientr]rjr=reservationGroupszNo reservation groups found.z#Failed to list reservation groups 'z JobReferencerParseStateFilterExpressionrArListJobsWithTokenAndUnreachabler*r,r-rGpopr3ModelReferencer list_modelsGetModelsApiClientPrintPageTokenr4RoutineReferencer ListRoutinesGetRoutinesApiClientrDReservationAssignmentReferenceGetReservationReferencebq_flagsLOCATIONvaluerListReservationAssignmentsGetReservationApiClientr=print BaseExceptionrCCapacityCommitmentReferenceGetCapacityCommitmentReferenceListCapacityCommitmentsrBReservationReferenceListBiReservationsintBigqueryNotFoundErrorrFrfail_if_not_using_alpha_feature AlphaFeaturesRESERVATION_GROUPSListReservationsrEReservationGroupReferenceGetReservationGroupReferenceListReservationGroupsr7TransferConfigReferencefrontend_id_utilsFormatProjectIdentifierr6r list_transfer_configsGetTransferV1ApiClientlendictr8TransferRunReferencer9FormatDataTransferIdentifierslist_transfer_runsr;TransferLogReferencelist_transfer_logsr<rHConnectionReferencer ListConnectionsGetConnectionV1ApiClient PROJECT_IDRowAccessPolicyReferencer&list_row_access_policies_with_granteesrIDelegateToGcloudAndExitPossiblyDelegateToGcloudAndExitr list_projectsrr list_tablesr #ListDatasetsWithTokenAndUnreachabler?r@PrintObjectsArrayWithMetadata)rQrVrir]r=r`r object_typer_responsee size_in_bytessize_in_gbytestransfer_configsr9formatted_identifierlist_transfer_runs_resultlist_transfer_log_resultlist_connections_resultss rS RunWithArgsListCmd.RunWithArgss J//GG NNK LL vv* NNA BB }} }}df  $ $ ( ( *F!..i#00     % % 4 4 i11  3   I{::II J J %99! )  4j))::)):: i11  3   vv*;..??//1iJG vv//<>k!55i))002&& h X 8$ H $%%h/ //@@k!55i ,,$99;&& KK h x :& H $%%h/ $ $ !11PP #;;%/zS%..44#&  &@@113&&   H $]+' 3 4 h &  ' ' 1  ! ! !11MM #BB!%..44+.  &==113&&   !H ,23' 0 1 h &  ' ' 1    h//DDk!99#,,22!$ i  '::335 (J' (*hv./-(,>?. -> ?   ( ( 4  7 7&&99 (88335!(( $ ; ;  (+9H*Dh~&"  &' o1%%h/  //IIk!>>#,,22'* i  33  " " 5 5 &;;%+%C%C%E&&   ( *01' . / h &  ' ' 1    //GGk!55&>> i    % % 6 6       'nn J  .CC 779))$$++    c"23q8(8(;< %%j1 #g  //DDk$$k.LL --EE1Fi #7"I"I  ' ' )  &&__ #   c";<A(A!(DE %%j1)!,g  //DDk.LL --BB.Ci "6!H!H  ' ' ) ((&&__ "   c":;q@(@(CD %%j1(+g //CCk!2!B!B002((..$$**&&__ " 2 2*=9 %& 4 4%%&>? ! !//HHk)PP#$$__ h  (./ -. H $%%h/    $ $nn G  k ""  +5x7H7H7N7N*O# !55i //@@k 9$//@@k **:t<,,$$&&g I{::KK L L//@@k//>>k(($$&& g k11BBB **:t<'KK$$&&66 KK!$$Z0g$''4+A+A  $$ $22"+ ,BO  # # 2%%   J $$AKQ O   2 $$>H! L   . + +   $$9CQ G   * $$6@! D   @ $$~" B55AA@ B AA*BAA8*~~~~" ,   ?::?@AA@ AA@"AAAAAA AA5AAA0A0AA5A8 AB%BAB B AB%cBS[UR=(d S50$)z+Parses command flags from the command line.r*2)strr*)rQs rS'ParseCommandFlagsSharedWithAllResources/ListCmd.ParseCommandFlagsSharedWithAllResourcess# s4++1r2  rU)r$))r __module__ __qualname____firstlineno__usagerr FlagValuesrKrrrr rr__static_attributes__ __classcell__)rRs@rSrr)sc A%L3LE$4$4L\FCF#FP tCH~ rUr)'__doc__ __future__rrrtypingrrabslrr typing_extensionsr rclientsr r r rrrrrrrrrfrontendrrrrrrrrr BigqueryCmdrrUrSrsn$&%!&%(" "&", ,%%, 2$b **b rU