Skip to content
This repository was archived by the owner on Jun 8, 2026. It is now read-only.

feat(dbapi): manual commit sample #187

Closed
IlyaFaer wants to merge 14 commits into from
Closed

feat(dbapi): manual commit sample #187

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
14 commits
Select commit Hold shift + click to select a range
beb5bdf
feat: autocommit sample
AlisskaPie Nov 19, 2020
adc05b0
remove unused imports
AlisskaPie Nov 19, 2020
1659802
Merge branch 'master' into autocommit_samples
c24t Nov 23, 2020
1de5c29
Remove samples/samples init
c24t Nov 24, 2020
85885f5
No package-relative imports in samples
c24t Nov 24, 2020
f8a6c80
fix check errors, rename test file
AlisskaPie Nov 25, 2020
1fb7019
move ResultsChecksum() to test
AlisskaPie Nov 30, 2020
09c5246
use connection.Cursor in patch
AlisskaPie Nov 30, 2020
f8d4d4c
Merge branch 'master' into autocommit_samples
AVaksman Dec 3, 2020
0e1e66c
Merge branch 'master' into autocommit_samples
c24t Dec 7, 2020
cab9f08
Apply suggestions from code review
Dec 9, 2020
f1353a2
Update samples/samples/autocommit_test.py
Dec 9, 2020
4e5465b
lint fix
Dec 9, 2020
8c3dff3
feat(dbapi): manual commit sample
Dec 10, 2020
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
move ResultsChecksum() to test
  • Loading branch information
@AlisskaPie
AlisskaPie committed Nov 30, 2020
commit 1fb70190968286ed99caa5e346caadb4583d81a3
2 changes: 0 additions & 2 deletions samples/samples/autocommit.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,14 +12,12 @@
def enable_autocommit_mode(instance_id, database_id):
"""Enables autocommit mode."""
# [START spanner_enable_autocommit_mode]
from google.cloud.spanner_dbapi.checksum import ResultsChecksum

connection = connect(instance_id, database_id)
connection.autocommit = True
print("Autocommit mode is enabled.")

cursor = connection.cursor()
cursor._checksum = ResultsChecksum()

cursor.execute(
"""CREATE TABLE Singers (
Expand Down
15 changes: 11 additions & 4 deletions samples/samples/autocommit_test.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -48,7 +48,14 @@ def database(spanner_instance):


def test_enable_autocommit_mode(capsys, database):
autocommit.enable_autocommit_mode(INSTANCE_ID, DATABASE_ID)
out, _ = capsys.readouterr()
assert "Autocommit mode is enabled." in out
assert "SingerId: 13, AlbumId: Russell, AlbumTitle: Morales" in out
import mock
from google.cloud.spanner_dbapi.checksum import ResultsChecksum

with mock.patch(
"google.cloud.spanner_dbapi.cursor.Cursor._checksum",
new_callable=ResultsChecksum(),
):
autocommit.enable_autocommit_mode(INSTANCE_ID, DATABASE_ID)
out, _ = capsys.readouterr()
assert "Autocommit mode is enabled." in out
assert "SingerId: 13, AlbumId: Russell, AlbumTitle: Morales" in out