SKAUL05
diff --git a/Collapse file
‎functions/spanner/README.md‎
Copy file name to clipboard
+11Lines changed: 11 additions & 0 deletions
Display the source diff
Display the rich diff b/Collapse file
‎functions/spanner/README.md‎
Copy file name to clipboard
+11Lines changed: 11 additions & 0 deletions
Display the source diff
Display the rich diff
diff --git a/Collapse file
‎functions/spanner/main.py‎
Copy file name to clipboard
+39Lines changed: 39 additions & 0 deletions b/Collapse file
‎functions/spanner/main.py‎
Copy file name to clipboard
+39Lines changed: 39 additions & 0 deletions
diff --git a/Collapse file
‎functions/spanner/main_test.py‎
Copy file name to clipboard
+31Lines changed: 31 additions & 0 deletions b/Collapse file
‎functions/spanner/main_test.py‎
Copy file name to clipboard
+31Lines changed: 31 additions & 0 deletions
diff --git a/Collapse file
‎functions/spanner/requirements.txt‎
Copy file name to clipboard
+1Lines changed: 1 addition & 0 deletions b/Collapse file
‎functions/spanner/requirements.txt‎
Copy file name to clipboard
+1Lines changed: 1 addition & 0 deletions
@@ -0,0 +1,11 @@
+<img src="https://avatars2.githubusercontent.com/u/2810941?v=3&s=96" alt="Google Cloud Platform logo" title="Google Cloud Platform" align="right" height="96" width="96"/>
+
+# Google Cloud Functions - Cloud Spanner sample
+
+See:
+
+* [Cloud Functions Cloud Spanner tutorial][tutorial]
+* [Cloud Functions Cloud Spanner source code][code]
+
+[tutorial]: https://cloud.google.com/spanner/docs/use-cloud-functions
+[code]: main.py
@@ -0,0 +1,39 @@
+# Copyright 2018 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.
+
+# [START spanner_functions_quickstart]
+from google.cloud import spanner
+
+instance_id = 'test-instance'
+database_id = 'example-db'
+
+client = spanner.Client()
+
+
+def spanner_read_data(request):
+    instance = client.instance(instance_id)
+    database = instance.database(database_id)
+
+    query = 'SELECT * FROM Albums'
+
+    outputs = []
+    with database.snapshot() as snapshot:
+        results = snapshot.execute_sql(query)
+
+        for row in results:
+            output = 'SingerId: {}, AlbumId: {}, AlbumTitle: {}'.format(*row)
+            outputs.append(output)
+
+    return '\n'.join(outputs)
+# [END spanner_functions_quickstart]
@@ -0,0 +1,31 @@
+# Copyright 2018 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.
+
+from unittest.mock import MagicMock
+
+from google.cloud import spanner
+
+spanner.Client = MagicMock()
+
+
+def test_main():
+    import main
+    snapshot_mock = main.client.instance().database().snapshot().__enter__()
+    snapshot_mock.execute_sql.return_value = [('SingerID', 'AlbumID', 'Album')]
+
+    response = main.spanner_read_data(None)
+
+    assert 'SingerID' in response
+    assert 'AlbumID' in response
+    assert 'Album' in response
@@ -0,0 +1 @@
+google-cloud-spanner==1.4.0