forked from googleapis/python-spanner
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest_table.py
More file actions
124 lines (103 loc) · 4.88 KB
/
test_table.py
File metadata and controls
124 lines (103 loc) · 4.88 KB
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
# Copyright 2021 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
#
# 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 unittest
from google.cloud.exceptions import NotFound
import mock
from google.cloud.spanner_v1.types import (
StructType,
Type,
TypeCode,
)
class _BaseTest(unittest.TestCase):
TABLE_ID = "test_table"
def _make_one(self, *args, **kwargs):
return self._get_target_class()(*args, **kwargs)
class TestTable(_BaseTest):
def _get_target_class(self):
from google.cloud.spanner_v1.table import Table
return Table
def test_ctor(self):
from google.cloud.spanner_v1.database import Database
db = mock.create_autospec(Database, instance=True)
table = self._make_one(self.TABLE_ID, db)
self.assertEqual(table.table_id, self.TABLE_ID)
def test_exists_executes_query(self):
from google.cloud.spanner_v1.database import Database, SnapshotCheckout
from google.cloud.spanner_v1.snapshot import Snapshot
from google.cloud.spanner_v1.table import _EXISTS_TEMPLATE
db = mock.create_autospec(Database, instance=True)
checkout = mock.create_autospec(SnapshotCheckout, instance=True)
snapshot = mock.create_autospec(Snapshot, instance=True)
db.snapshot.return_value = checkout
checkout.__enter__.return_value = snapshot
snapshot.execute_sql.return_value = [[False]]
table = self._make_one(self.TABLE_ID, db)
exists = table.exists()
self.assertFalse(exists)
snapshot.execute_sql.assert_called_with(
_EXISTS_TEMPLATE.format("WHERE TABLE_NAME = @table_id"),
params={"table_id": self.TABLE_ID},
param_types={"table_id": Type(code=TypeCode.STRING)},
)
def test_schema_executes_query(self):
from google.cloud.spanner_v1.database import Database, SnapshotCheckout
from google.cloud.spanner_v1.snapshot import Snapshot
from google.cloud.spanner_v1.table import _GET_SCHEMA_TEMPLATE
db = mock.create_autospec(Database, instance=True)
checkout = mock.create_autospec(SnapshotCheckout, instance=True)
snapshot = mock.create_autospec(Snapshot, instance=True)
db.snapshot.return_value = checkout
checkout.__enter__.return_value = snapshot
table = self._make_one(self.TABLE_ID, db)
schema = table.schema
self.assertIsInstance(schema, list)
expected_query = _GET_SCHEMA_TEMPLATE.format(self.TABLE_ID)
snapshot.execute_sql.assert_called_with(expected_query)
def test_schema_returns_cache(self):
from google.cloud.spanner_v1.database import Database
db = mock.create_autospec(Database, instance=True)
table = self._make_one(self.TABLE_ID, db)
table._schema = [StructType.Field(name="col1")]
schema = table.schema
self.assertEqual(schema, [StructType.Field(name="col1")])
def test_reload_raises_notfound(self):
from google.cloud.spanner_v1.database import Database, SnapshotCheckout
from google.cloud.spanner_v1.snapshot import Snapshot
db = mock.create_autospec(Database, instance=True)
checkout = mock.create_autospec(SnapshotCheckout, instance=True)
snapshot = mock.create_autospec(Snapshot, instance=True)
db.snapshot.return_value = checkout
checkout.__enter__.return_value = snapshot
snapshot.execute_sql.return_value = [[False]]
table = self._make_one(self.TABLE_ID, db)
with self.assertRaises(NotFound):
table.reload()
def test_reload_executes_queries(self):
from google.cloud.spanner_v1.database import Database, SnapshotCheckout
from google.cloud.spanner_v1.snapshot import Snapshot
from google.cloud.spanner_v1.streamed import StreamedResultSet
db = mock.create_autospec(Database, instance=True)
checkout = mock.create_autospec(SnapshotCheckout, instance=True)
snapshot = mock.create_autospec(Snapshot, instance=True)
results = mock.create_autospec(StreamedResultSet, instance=True)
db.snapshot.return_value = checkout
checkout.__enter__.return_value = snapshot
results.fields = [StructType.Field(name="col1")]
snapshot.execute_sql.side_effect = [
[[True]],
results,
]
table = self._make_one(self.TABLE_ID, db)
table.reload()
self.assertEqual(table.schema, [StructType.Field(name="col1")])