-
Notifications
You must be signed in to change notification settings - Fork 6.5k
/
Copy pathquickstart.py
59 lines (49 loc) · 2.08 KB
/
quickstart.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
# Copyright 2020 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# https://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
# [START bigqueryreservation_quickstart]
import argparse
from google.cloud import bigquery_reservation_v1
def main(
project_id: str = "your-project-id", location: str = "US", transport: str = "grpc"
) -> None:
# Constructs the client for interacting with the service.
client = bigquery_reservation_v1.ReservationServiceClient(transport=transport)
report_reservations(client, project_id, location)
def report_reservations(
client: bigquery_reservation_v1.ReservationServiceClient,
project_id: str,
location: str,
) -> None:
"""Prints details and summary information about reservations defined within
a given admin project and location.
"""
print("Reservations in project {} in location {}".format(project_id, location))
req = bigquery_reservation_v1.ListReservationsRequest(
parent=client.common_location_path(project_id, location)
)
total_reservations = 0
for reservation in client.list_reservations(request=req):
print(
f"\tReservation {reservation.name} "
f"has {reservation.slot_capacity} slot capacity."
)
total_reservations = total_reservations + 1
print(f"\n{total_reservations} reservations processed.")
if __name__ == "__main__":
parser = argparse.ArgumentParser()
parser.add_argument("--project_id", type=str)
parser.add_argument("--location", default="US", type=str)
args = parser.parse_args()
main(project_id=args.project_id, location=args.location)
# [END bigqueryreservation_quickstart]