Source code for

# Copyright 2017 The Forseti Security Authors. All rights reserved.
# 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
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# See the License for the specific language governing permissions and
# limitations under the License.

"""Wrapper for SQL API client."""
from builtins import object
from googleapiclient import errors
from httplib2 import HttpLib2Error

from import _base_repository
from import api_helpers
from import errors as api_errors
from import repository_mixins
from import logger

LOGGER = logger.get_logger(__name__)
API_NAME = 'sqladmin'

[docs]class CloudSqlRepositoryClient(_base_repository.BaseRepositoryClient): """Cloud SQL Admin API Respository.""" def __init__(self, quota_max_calls=None, quota_period=1.0, use_rate_limiter=True): """Constructor. Args: quota_max_calls (int): Allowed requests per <quota_period> for the API. quota_period (float): The time period to track requests over. use_rate_limiter (bool): Set to false to disable the use of a rate limiter for this service. """ if not quota_max_calls: use_rate_limiter = False self._instances = None super(CloudSqlRepositoryClient, self).__init__( API_NAME, versions=['v1beta4'], quota_max_calls=quota_max_calls, quota_period=quota_period, use_rate_limiter=use_rate_limiter) # Turn off docstrings for properties. # pylint: disable=missing-return-doc, missing-return-type-doc @property def instances(self): """Returns a _CloudSqlInstancesRepository instance.""" if not self._instances: self._instances = self._init_repository( _CloudSqlInstancesRepository) return self._instances
# pylint: enable=missing-return-doc, missing-return-type-doc
[docs]class _CloudSqlInstancesRepository( repository_mixins.ListQueryMixin, _base_repository.GCPRepository): """Implementation of CloudSql Instances repository.""" def __init__(self, **kwargs): """Constructor. Args: **kwargs (dict): The args to pass into GCPRepository.__init__() """ super(_CloudSqlInstancesRepository, self).__init__( component='instances', **kwargs)
[docs]class CloudsqlClient(object): """CloudSQL Client.""" def __init__(self, global_configs, **kwargs): """Initialize. Args: global_configs (dict): Global configurations. **kwargs (dict): The kwargs. """ max_calls, quota_period = api_helpers.get_ratelimiter_config( global_configs, API_NAME) self.repository = CloudSqlRepositoryClient( quota_max_calls=max_calls, quota_period=quota_period, use_rate_limiter=kwargs.get('use_rate_limiter', True))
[docs] def get_instances(self, project_id): """Gets all CloudSQL instances for a project. Args: project_id (int): The project id for a GCP project. Returns: list: A list of database Instance resource dicts for a project_id. [{"kind": "sql#instance", "name": "sql_instance1", ...} {"kind": "sql#instance", "name": "sql_instance2", ...}, {...}] Raises: ApiExecutionError: ApiExecutionError is raised if the call to the GCP ClodSQL API fails """ try: paged_results = self.repository.instances.list(project_id) flattened_results = api_helpers.flatten_list_results( paged_results, 'items') LOGGER.debug('Getting all the cloudsql instances of a project,' ' project_id = %s, flattened_results = %s', project_id, flattened_results) return flattened_results except (errors.HttpError, HttpLib2Error) as e: api_exception = api_errors.ApiExecutionError( 'instances', e, 'project_id', project_id) LOGGER.exception(api_exception) raise api_exception