def test_read(self):
# Setup Expected Response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
# Mock the API response
channel = ChannelStub(responses=[expected_response])
client = spanner_v1.SpannerClient(channel=channel)
# Setup Request
session = client.session_path('[PROJECT]', '[INSTANCE]', '[DATABASE]',
'[SESSION]')
table = 'table110115790'
columns = []
key_set = {}
response = client.read(session, table, columns, key_set)
assert expected_response == response
assert len(channel.requests) == 1
expected_request = spanner_pb2.ReadRequest(session=session,
table=table,
columns=columns,
key_set=key_set)
actual_request = channel.requests[0][1]
assert expected_request == actual_request
def test_read(self, mock_create_stub):
# Mock gRPC layer
grpc_stub = mock.Mock()
mock_create_stub.return_value = grpc_stub
client = spanner_v1.SpannerClient()
# Mock request
session = client.session_path('[PROJECT]', '[INSTANCE]', '[DATABASE]',
'[SESSION]')
table = 'table110115790'
columns = []
key_set = {}
# Mock response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
grpc_stub.Read.return_value = expected_response
response = client.read(session, table, columns, key_set)
self.assertEqual(expected_response, response)
grpc_stub.Read.assert_called_once()
args, kwargs = grpc_stub.Read.call_args
self.assertEqual(len(args), 2)
self.assertEqual(len(kwargs), 1)
self.assertIn('metadata', kwargs)
actual_request = args[0]
expected_request = spanner_pb2.ReadRequest(session=session,
table=table,
columns=columns,
key_set=key_set)
self.assertEqual(expected_request, actual_request)
def test_execute_sql(self, mock_create_stub):
# Mock gRPC layer
grpc_stub = mock.Mock()
mock_create_stub.return_value = grpc_stub
client = spanner_v1.SpannerClient()
# Mock request
session = client.session_path('[PROJECT]', '[INSTANCE]', '[DATABASE]',
'[SESSION]')
sql = 'sql114126'
# Mock response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
grpc_stub.ExecuteSql.return_value = expected_response
response = client.execute_sql(session, sql)
self.assertEqual(expected_response, response)
grpc_stub.ExecuteSql.assert_called_once()
args, kwargs = grpc_stub.ExecuteSql.call_args
self.assertEqual(len(args), 2)
self.assertEqual(len(kwargs), 1)
self.assertIn('metadata', kwargs)
actual_request = args[0]
expected_request = spanner_pb2.ExecuteSqlRequest(session=session,
sql=sql)
self.assertEqual(expected_request, actual_request)
def test_read(self):
# Setup Expected Response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
# Mock the API response
channel = ChannelStub(responses=[expected_response])
patch = mock.patch("google.api_core.grpc_helpers.create_channel")
with patch as create_channel:
create_channel.return_value = channel
client = spanner_v1.SpannerClient()
# Setup Request
session = client.session_path("[PROJECT]", "[INSTANCE]", "[DATABASE]",
"[SESSION]")
table = "table110115790"
columns = []
key_set = {}
response = client.read(session, table, columns, key_set)
assert expected_response == response
assert len(channel.requests) == 1
expected_request = spanner_pb2.ReadRequest(session=session,
table=table,
columns=columns,
key_set=key_set)
actual_request = channel.requests[0][1]
assert expected_request == actual_request
def test_execute_sql(self):
# Setup Expected Response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
# Mock the API response
channel = ChannelStub(responses=[expected_response])
patch = mock.patch("google.api_core.grpc_helpers.create_channel")
with patch as create_channel:
create_channel.return_value = channel
client = spanner_v1.SpannerClient()
# Setup Request
session = client.session_path("[PROJECT]", "[INSTANCE]", "[DATABASE]",
"[SESSION]")
sql = "sql114126"
response = client.execute_sql(session, sql)
assert expected_response == response
assert len(channel.requests) == 1
expected_request = spanner_pb2.ExecuteSqlRequest(session=session,
sql=sql)
actual_request = channel.requests[0][1]
assert expected_request == actual_request
def test_execute_sql(self):
# Setup Expected Response
expected_response = {}
expected_response = result_set_pb2.ResultSet(**expected_response)
# Mock the API response
channel = ChannelStub(responses=[expected_response])
client = spanner_v1.SpannerClient(channel=channel)
# Setup Request
session = client.session_path('[PROJECT]', '[INSTANCE]', '[DATABASE]',
'[SESSION]')
sql = 'sql114126'
response = client.execute_sql(session, sql)
assert expected_response == response
assert len(channel.requests) == 1
expected_request = spanner_pb2.ExecuteSqlRequest(session=session,
sql=sql)
actual_request = channel.requests[0][1]
assert expected_request == actual_request
