forked from googleapis/python-spanner-django
-
Notifications
You must be signed in to change notification settings - Fork 1
/
autocommit.py
70 lines (58 loc) · 2.1 KB
/
autocommit.py
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
# Copyright 2020 Google LLC
#
# Use of this source code is governed by a BSD-style
# license that can be found in the LICENSE file or at
# https://developers.google.com/open-source/licenses/bsd
import argparse
from google.cloud import spanner_dbapi
from google.cloud.spanner_dbapi import connect
def enable_autocommit_mode(instance_id, database_id):
"""Enables autocommit mode."""
# [START spanner_enable_autocommit_mode]
connection = connect(instance_id, database_id)
connection.autocommit = True
print("Autocommit mode is enabled.")
cursor = connection.cursor()
cursor.execute(
"""CREATE TABLE Singers (
SingerId INT64 NOT NULL,
FirstName STRING(1024),
LastName STRING(1024),
SingerInfo BYTES(MAX)
) PRIMARY KEY (SingerId)"""
)
cursor.execute(
"""INSERT INTO Singers (SingerId, FirstName, LastName) VALUES
(12, 'Melissa', 'Garcia'),
(13, 'Russell', 'Morales'),
(14, 'Jacqueline', 'Long'),
(15, 'Dylan', 'Shaw')"""
)
cursor.execute("""SELECT * FROM Singers WHERE SingerId = 13""")
print(
u"SingerId: {}, AlbumId: {}, AlbumTitle: {}".format(*cursor.fetchone())
)
connection.close()
# [END spanner_enable_autocommit_mode]
if __name__ == "__main__":
parser = argparse.ArgumentParser(
description=__doc__,
formatter_class=argparse.RawDescriptionHelpFormatter,
)
parser.add_argument("instance_id", help="Your Cloud Spanner instance ID.")
parser.add_argument(
"--database-id",
help="Your Cloud Spanner database ID.",
default="example_db",
)
subparsers = parser.add_subparsers(dest="command")
subparsers.add_parser(
"enable_autocommit_mode", help=enable_autocommit_mode.__doc__
)
args = parser.parse_args()
if args.command == "enable_autocommit_mode":
enable_autocommit_mode(args.instance_id, args.database_id)
else:
print(
"Command {} did not match expected commands.".format(args.command)
)