ratchet is a simple CLI tool for accessing Cloud Spanner. This tool allows you to
throw queries to the Cloud Spanner (or an emulator of that). If SPANNER_EMULATOR_HOST
env is set, ratchet uses it.
Usage:
ratchet [command]
Available Commands:
describe Show Database DDLs.
drop-all-tables Drop all tables
exec Throw specified SQL(s) to Cloud Spanner.
help Help about any command
load Load applies DDLs to Cloud Spanner using a single transaction. If you apply many DDLs, 'load' would be way much faster than 'exec'.
Flags:
-d, --database SPANNER_DATABASE_ID your-database-id. (you can also set by SPANNER_DATABASE_ID)
-h, --help help for ratchet
-i, --instance SPANNER_INSTANCE_ID your-instance-id. (you can also set by SPANNER_INSTANCE_ID)
-p, --project SPANNER_PROJECT_ID your-project-id. (you can also set by SPANNER_PROJECT_ID)
go install github.com/matope/ratchet
Set env vars.
# you can also set by -p, -i, -d
$ export SPANNER_PROJECT_ID=<your-project-id>
$ export SPANNER_INSTANCE_ID=<your-instance-id>
$ export SPANNER_DATABASE_ID=<your-database-id>
# Set if you use spanner-emulator such like handy-spanner.
$ export SPANNER_EMULATOR_HOST=localhost:9999
$ ratchet exec "SELECT * From Singers; SELECT * FROM Albums"
sql:SELECT * From Singers
+----------+-----------+----------+------------+
| SingerId | FirstName | LastName | SingerInfo |
+----------+-----------+----------+------------+
| 1 | Marc | Richards | |
| 2 | Catalina | Smith | |
| 3 | Alice | Trentor | |
| 4 | Lea | Martin | |
| 5 | David | Lomond | |
+----------+-----------+----------+------------+
5 record(s) found.
sql:SELECT * FROM Albums
+----------+---------+-------------------------+
| SingerId | AlbumId | AlbumTitle |
+----------+---------+-------------------------+
| 1 | 1 | Total Junk |
| 1 | 2 | Go, Go, Go |
| 2 | 1 | Green |
| 2 | 2 | Forever Hold Your Peace |
| 2 | 3 | Terrified |
+----------+---------+-------------------------+
5 record(s) found.
Using exec command, you can throw queries and DDL/DML SQL to Cloud Spanner.
$ ratchet exec "SELECT * From Singers; SELECT * FROM Albums"
You can also specify SQLs from a file specified by -f, --file flag.
$ ratchet exec --file ./testdata/inserts.sql
Using describe command, you can get Database DDL(s). (For now, handy-spanner does not yet implement it)
$ ratchet describe
Found 3 DDL(s)
CREATE TABLE Examples (
ID STRING(1024),
LastUpdateTime TIMESTAMP NOT NULL OPTIONS (
allow_commit_timestamp = true
),
) PRIMARY KEY(ID)
CREATE TABLE Singers (
SingerId INT64 NOT NULL,
FirstName STRING(1024),
LastName STRING(1024),
SingerInfo BYTES(MAX),
) PRIMARY KEY(SingerId)
CREATE TABLE Albums (
SingerId INT64 NOT NULL,
AlbumId INT64 NOT NULL,
AlbumTitle STRING(MAX),
) PRIMARY KEY(SingerId, AlbumId),
INTERLEAVE IN PARENT Singers ON DELETE CASCADE