in spanner/spanner_samples.rb [2605:2696]
def usage
puts <<~USAGE
Usage: bundle exec ruby spanner_samples.rb [command] [arguments]
Commands:
create_instance <instance_id> Create Instance
create_database <instance_id> <database_id> Create Database
create_database_with_encryption_key <instance_id> <database_id> Create Database with encryption
create_database_with_multiple_kms_keys <instance_id> <database_id> Create Database with multiple KMS keys
create_table_with_timestamp_column <instance_id> <database_id> Create table Performances with commit timestamp column
insert_data <instance_id> <database_id> Insert Data
insert_data_with_timestamp_column <instance_id> <database_id> Inserts data into Performances table containing the commit timestamp column
query_data <instance_id> <database_id> Query Data
read_data <instance_id> <database_id> Read Data
delete_data <instance_id> <database_id> Delete Data
read_stale_data <instance_id> <database_id> Read Stale Data
create_index <instance_id> <database_id> Create Index
create_storing_index <instance_id> <database_id> Create Storing Index
add_column <instance_id> <database_id> Add Column
add_timestamp_column <instance_id> <database_id> Alters existing Albums table, adding a commit timestamp column
add_numeric_column <instance_id> <database_id> Alters existing Venues table, adding a numeric column
update_data <instance_id> <database_id> Update Data
update_data_with_timestamp_column <instance_id> <database_id> Updates two records in the altered table where the commit timestamp column was added
update_data_with_numeric_column <instance_id> <database_id> Updates three records in the altered table where the numeric column was added
query_data_with_new_column <instance_id> <database_id> Query Data with New Column
query_data_with_timestamp_column <instance_id> <database_id> Queries data from altered table where the commit timestamp column was added
write_struct_data <instance_id> <database_id> Inserts sample data that can be used for STRUCT queries
query_with_struct <instance_id> <database_id> Queries data using a STRUCT paramater
query_with_array_of_struct <instance_id> <database_id> Queries data using an array of STRUCT values as parameter
query_struct_field <instance_id> <database_id> Queries data by accessing field from a STRUCT parameter
query_nested_struct_field <instance_id> <database_id> Queries data by accessing field from nested STRUCT parameters
query_data_with_index <instance_id> <database_id> <start_title> <end_title> Query Data with Index
read_write_transaction <instance_id> <database_id> Read-Write Transaction
read_data_with_index <instance_id> <database_id> Read Data with Index
read_data_with_storing_index <instance_id> <database_id> Read Data with Storing Index
read_only_transaction <instance_id> <database_id> Read-Only Transaction
spanner_batch_client <instance_id> <database_id> Use Spanner batch query with a thread pool
insert_using_dml <instance_id> <database_id> Insert Data using a DML statement.
update_using_dml <instance_id> <database_id> Update Data using a DML statement.
delete_using_dml <instance_id> <database_id> Delete Data using a DML statement.
update_using_dml_with_timestamp <instance_id> <database_id> Update the timestamp value of specifc records using a DML statement.
write_and_read_using_dml <instance_id> <database_id> Insert data using a DML statement and then read the inserted data.
update_using_dml_with_struct <instance_id> <database_id> Update data using a DML statement combined with a Spanner struct.
write_using_dml <instance_id> <database_id> Insert multiple records using a DML statement.
query_with_parameter <instance_id> <database_id> Query record inserted using DML with a query parameter.
query_with_numeric_parameter <instance_id> <database_id> Query record inserted using DML with a numeric query parameter.
write_with_transaction_using_dml <instance_id> <database_id> Update data using a DML statement within a read-write transaction.
update_using_partitioned_dml <instance_id> <database_id> Update multiple records using a partitioned DML statement.
delete_using_partitioned_dml <instance_id> <database_id> Delete multiple records using a partitioned DML statement.
update_using_batch_dml <instance_id> <database_id> Updates sample data in the database using Batch DML.
create_table_with_datatypes <instance_id> <database_id> Create table Venues with supported datatype columns.
write_datatypes_data <instance_id> <database_id> Inserts sample data that can be used for datatype queries.
query_with_array <instance_id> <database_id> Queries data using an ARRAY parameter.
query_with_bool <instance_id> <database_id> Queries data using a BOOL parameter.
query_with_bytes <instance_id> <database_id> Queries data using a BYTES parameter.
query_with_date <instance_id> <database_id> Queries data using a DATE parameter.
query_with_float <instance_id> <database_id> Queries data using a FLOAT64 parameter.
query_with_int <instance_id> <database_id> Queries data using a INT64 parameter.
query_with_string <instance_id> <database_id> Queries data using a STRING parameter.
query_with_timestamp <instance_id> <database_id> Queries data using a TIMESTAMP parameter.
query_with_query_options <instance_id> <database_id> Queries data with query options.
create_client_with_query_options <instance_id> <database_id> Create a client with query options.
write_read_bool_array <instance_id> <database_id> Writes and read BOOL array.
write_read_empty_int64_array <instance_id> <database_id> Writes empty INT64 array and read.
write_read_null_int64_array <instance_id> <database_id> Writes nil to INT64 array and read.
write_read_int64_array <instance_id> <database_id> Writes INT64 array and read.
write_read_empty_float64_array <instance_id> <database_id> Writes empty FLOAT64 array and read.
write_read_null_float64_array <instance_id> <database_id> Writes nil to FLOAT64 array and read.
write_read_float64_array <instance_id> <database_id> Writes FLOAT64 array and read.
create_backup <instance_id> <database_id> <backup_id> <version_time> Create a backup.
create_backup_with_encryption_key <instance_id> <database_id> <backup_id> <kms_key_name> Create a backup using encryption key.
create_backup_with_multiple_kms_keys <instance_id> <database_id> <backup_id> "<kms_key_name>,<kms_key_name>" Create a backup using multiple KMS keys.
restore_backup <instance_id> <database_id> <backup_id> Restore a database.
restore_database_with_encryption_key <instance_id> <database_id> <backup_id> <kms_key_name> Restore a database using encryption key.
restore_database_with_multiple_kms_keys <instance_id> <database_id> <backup_id> "<kms_key_name>,<kms_key_name>" Restore a database using multiple KMS keys
create_backup_cancel <instance_id> <database_id> <backup_id> Cancel a backup.
list_backup_operations <instance_id> List backup operations.
list_database_operations <instance_id> List database operations.
list_backups <instance_id> <backup_id> <database_id> List and filter backups.
delete_backup <instance_id> <backup_id> Delete a backup.
update_backup <instance_id> <backup_id> Update the backup.
copy_backup <instance_id> <backup_id> <source_backup> Copies a backup
copy_backup_with_multiple_kms_keys <instance_id> <backup_id> <source_backup> "<kms_key_name>,<kms_key_name>" Copies a backup with multiple KMS keys
set_custom_timeout_and_retry <instance_id> <database_id> Set custom timeout and retry settings.
commit_stats <instance_id> <database_id> Get commit stats.
Environment variables:
GOOGLE_CLOUD_PROJECT must be set to your Google Cloud project ID
USAGE
end