# Copyright 2016 Google Inc. 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
#
#    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.
"""Spanner database sessions API helper."""

from apitools.base.py import encoding
from apitools.base.py import extra_types
from googlecloudsdk.api_lib.util import apis
from googlecloudsdk.core import resources


def Create(instance, database):
  """Create a database session."""
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')
  ref = resources.REGISTRY.Parse(
      database,
      params={'instancesId': instance},
      collection='spanner.projects.instances.databases')
  req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(
      database=ref.RelativeName())
  return client.projects_instances_databases_sessions.Create(req)


def Delete(session):
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')
  req = msgs.SpannerProjectsInstancesDatabasesSessionsDeleteRequest(
      name=session.name)
  return client.projects_instances_databases_sessions.Delete(req)


def ExecuteSql(session, sql):
  """Execute an SQL command."""
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')

  # TODO(b/33482229): remove this workaround
  def _ToJson(msg):
    return extra_types.JsonProtoEncoder(
        extra_types.JsonArray(entries=msg.entry))
  def _FromJson(data):
    return msgs.ResultSet.RowsValueListEntry(
        entry=extra_types.JsonProtoDecoder(data).entries)
  encoding.RegisterCustomMessageCodec(
      encoder=_ToJson, decoder=_FromJson)(
          msgs.ResultSet.RowsValueListEntry)

  req = msgs.SpannerProjectsInstancesDatabasesSessionsExecuteSqlRequest(
      session=session.name,
      executeSqlRequest=msgs.ExecuteSqlRequest(
          sql=sql))
  resp = client.projects_instances_databases_sessions.ExecuteSql(req)
  return resp

0afa454c48a0412a4103ae3dee0bc2f8cf2c3d30
<mask token>


def Create(instance, database):
    """Create a database session."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    ref = resources.REGISTRY.Parse(database, params={'instancesId':
        instance}, collection='spanner.projects.instances.databases')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(database
        =ref.RelativeName())
    return client.projects_instances_databases_sessions.Create(req)


<mask token>

<mask token>


def Create(instance, database):
    """Create a database session."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    ref = resources.REGISTRY.Parse(database, params={'instancesId':
        instance}, collection='spanner.projects.instances.databases')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(database
        =ref.RelativeName())
    return client.projects_instances_databases_sessions.Create(req)


def Delete(session):
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsDeleteRequest(name=
        session.name)
    return client.projects_instances_databases_sessions.Delete(req)


<mask token>

<mask token>


def Create(instance, database):
    """Create a database session."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    ref = resources.REGISTRY.Parse(database, params={'instancesId':
        instance}, collection='spanner.projects.instances.databases')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(database
        =ref.RelativeName())
    return client.projects_instances_databases_sessions.Create(req)


def Delete(session):
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsDeleteRequest(name=
        session.name)
    return client.projects_instances_databases_sessions.Delete(req)


def ExecuteSql(session, sql):
    """Execute an SQL command."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')

    def _ToJson(msg):
        return extra_types.JsonProtoEncoder(extra_types.JsonArray(entries=
            msg.entry))

    def _FromJson(data):
        return msgs.ResultSet.RowsValueListEntry(entry=extra_types.
            JsonProtoDecoder(data).entries)
    encoding.RegisterCustomMessageCodec(encoder=_ToJson, decoder=_FromJson)(
        msgs.ResultSet.RowsValueListEntry)
    req = msgs.SpannerProjectsInstancesDatabasesSessionsExecuteSqlRequest(
        session=session.name, executeSqlRequest=msgs.ExecuteSqlRequest(sql=sql)
        )
    resp = client.projects_instances_databases_sessions.ExecuteSql(req)
    return resp

<mask token>
from apitools.base.py import encoding
from apitools.base.py import extra_types
from googlecloudsdk.api_lib.util import apis
from googlecloudsdk.core import resources


def Create(instance, database):
    """Create a database session."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    ref = resources.REGISTRY.Parse(database, params={'instancesId':
        instance}, collection='spanner.projects.instances.databases')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(database
        =ref.RelativeName())
    return client.projects_instances_databases_sessions.Create(req)


def Delete(session):
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')
    req = msgs.SpannerProjectsInstancesDatabasesSessionsDeleteRequest(name=
        session.name)
    return client.projects_instances_databases_sessions.Delete(req)


def ExecuteSql(session, sql):
    """Execute an SQL command."""
    client = apis.GetClientInstance('spanner', 'v1')
    msgs = apis.GetMessagesModule('spanner', 'v1')

    def _ToJson(msg):
        return extra_types.JsonProtoEncoder(extra_types.JsonArray(entries=
            msg.entry))

    def _FromJson(data):
        return msgs.ResultSet.RowsValueListEntry(entry=extra_types.
            JsonProtoDecoder(data).entries)
    encoding.RegisterCustomMessageCodec(encoder=_ToJson, decoder=_FromJson)(
        msgs.ResultSet.RowsValueListEntry)
    req = msgs.SpannerProjectsInstancesDatabasesSessionsExecuteSqlRequest(
        session=session.name, executeSqlRequest=msgs.ExecuteSqlRequest(sql=sql)
        )
    resp = client.projects_instances_databases_sessions.ExecuteSql(req)
    return resp

# Copyright 2016 Google Inc. 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
#
#    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.
"""Spanner database sessions API helper."""

from apitools.base.py import encoding
from apitools.base.py import extra_types
from googlecloudsdk.api_lib.util import apis
from googlecloudsdk.core import resources


def Create(instance, database):
  """Create a database session."""
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')
  ref = resources.REGISTRY.Parse(
      database,
      params={'instancesId': instance},
      collection='spanner.projects.instances.databases')
  req = msgs.SpannerProjectsInstancesDatabasesSessionsCreateRequest(
      database=ref.RelativeName())
  return client.projects_instances_databases_sessions.Create(req)


def Delete(session):
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')
  req = msgs.SpannerProjectsInstancesDatabasesSessionsDeleteRequest(
      name=session.name)
  return client.projects_instances_databases_sessions.Delete(req)


def ExecuteSql(session, sql):
  """Execute an SQL command."""
  client = apis.GetClientInstance('spanner', 'v1')
  msgs = apis.GetMessagesModule('spanner', 'v1')

  # TODO(b/33482229): remove this workaround
  def _ToJson(msg):
    return extra_types.JsonProtoEncoder(
        extra_types.JsonArray(entries=msg.entry))
  def _FromJson(data):
    return msgs.ResultSet.RowsValueListEntry(
        entry=extra_types.JsonProtoDecoder(data).entries)
  encoding.RegisterCustomMessageCodec(
      encoder=_ToJson, decoder=_FromJson)(
          msgs.ResultSet.RowsValueListEntry)

  req = msgs.SpannerProjectsInstancesDatabasesSessionsExecuteSqlRequest(
      session=session.name,
      executeSqlRequest=msgs.ExecuteSqlRequest(
          sql=sql))
  resp = client.projects_instances_databases_sessions.ExecuteSql(req)
  return resp
