Asyncio Client for Google-Spanner, wrapped google-cloud-spanner.
Project description
aspanner
Asyncio Google Cloud Spanner Client, wrapped google-cloud-spanner to support aio calls, provide easy-to-use methods. This project exists because Spanner have no easy-to-use asyncio interface.
References:
- https://github.com/googleapis/python-spanner
- https://googleapis.dev/python/spanner/latest/index.html
- https://cloud.google.com/spanner/docs/samples
- https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1
Quick Start
-
Get the credentials JSON file from Google Cloud - IAM - Service Account - Keys, or run directly from permission granted VM, follow the tutorials from google.
-
Create Spanner instance, create database, and create test table.
CREATE TABLE tb_test_types ( id INT64 NOT NULL, data_str STRING(MAX), data_int INT64, data_float FLOAT64, data_bool BOOL, data_num NUMERIC, data_bytes BYTES(MAX), data_date DATE, data_time TIMESTAMP, data_array ARRAY<INT64>, data_json JSON, ) PRIMARY KEY(id);
-
Code test.py
async def test(): db = aspanner.Aspanner('google cloud project id', 'spanner instance name', 'database') cols = ('id', 'data_int') print(await db.insert('tb_test_types', cols, [(9, 999)])) print(await db.read('tb_test_types', cols, [(9,)])) print(await db.delete('tb_test_types', [(9,)])) print(await db.close()) asyncio.run(test())
-
Run in terminal.
pip install aspanner # if use credentials file export GOOGLE_APPLICATION_CREDENTIALS="/home/user/project-server-1234568-1234567890.json" python3 test.py
TODO
Retry now should be outside transaction with block, like: https://github.com/googleapis/google-cloud-python/blob/92465cbc4d9c0ba251838e9cd17f61d14b470e04/spanner/google/cloud/spanner_v1/session.py#L353
error in sql while JSON is array.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
aspanner-0.6.1.tar.gz
(10.9 kB
view hashes)
Built Distribution
aspanner-0.6.1-py3-none-any.whl
(11.8 kB
view hashes)