kaxil commented on a change in pull request #4097: [AIRFLOW-3231] Basic operators for Google Cloud SQL URL: https://github.com/apache/incubator-airflow/pull/4097#discussion_r228672581
########## File path: airflow/contrib/hooks/gcp_sql_hook.py ########## @@ -0,0 +1,173 @@ +# -*- coding: utf-8 -*- +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you 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 +# +# http://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. + +import time +from googleapiclient.discovery import build + +from airflow import AirflowException +from airflow.contrib.hooks.gcp_api_base_hook import GoogleCloudBaseHook + +# Number of retries - used by googleapiclient method calls to perform retries +# For requests that are "retriable" +NUM_RETRIES = 5 + +# Time to sleep between active checks of the operation results +TIME_TO_SLEEP_IN_SECONDS = 1 + + +class CloudSqlOperationStatus: + PENDING = "PENDING" + RUNNING = "RUNNING" + DONE = "DONE" + UNKNOWN = "UNKNOWN" + + +# noinspection PyAbstractClass +class CloudSqlHook(GoogleCloudBaseHook): + """ + Hook for Google Cloud SQL APIs. + """ + _conn = None + + def __init__(self, + api_version, + gcp_conn_id='google_cloud_default', + delegate_to=None): + super(CloudSqlHook, self).__init__(gcp_conn_id, delegate_to) + self.api_version = api_version + + def get_conn(self): + """ + Retrieves connection to Cloud SQL. + + :return: Google Cloud SQL services object. + :rtype: dict + """ + if not self._conn: + http_authorized = self._authorize() + self._conn = build('sqladmin', self.api_version, + http=http_authorized, cache_discovery=False) + return self._conn + + def get_instance(self, project_id, instance): + """ + Retrieves a resource containing information about a Cloud SQL instance. + + :param project_id: Project ID of the project that contains the instance. + :type project_id: str + :param instance: Database instance ID. This does not include the project ID. + :type instance: str + :return: A Cloud SQL instance resource. + :rtype: dict + """ + return self.get_conn().instances().get( + project=project_id, + instance=instance + ).execute(num_retries=NUM_RETRIES) + + def insert_instance(self, project_id, body): Review comment: I know the api call's it `insert` but can we not call it `create` which is more easy to understand as we have in bigquery? cc @fenglu-g ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
