This folder contains samples for how to use common Spanner features with SQLAlchemy. The samples use a shared data model and can be executed as a standalone application. The samples automatically start the Spanner Emulator in a Docker container when they are executed. You must therefore have Docker installed on your system to run a sample.
You can run a sample with nox:
nox -s hello_worldChange hello_world to run any of the other sample names. The runnable samples all end with
_sample.py. Omit the _sample.py part of the file name to run the sample.
| Sample name | Description |
|---|---|
| bit_reversed_sequence | Use a bit-reversed sequence for primary key generation. |
| date_and_timestamp | Map Spanner DATE and TIMESTAMP columns to SQLAlchemy. |
| default_column_value | Create and use a Spanner DEFAULT column constraint in SQLAlchemy. |
| generated_column | Create and use a Spanner generated column in SQLAlchemy. |
| hello_world | Shows how to connect to Spanner with SQLAlchemy and execute a simple query. |
| insert_data | Insert multiple rows to Spanner with SQLAlchemy. |
| interleaved_table | Create and use an interleaved table (INTERLEAVE IN PARENT) with SQLAlchemy. |
| transaction | Execute a read/write transaction on Spanner with SQLAlchemy. |