Database Claner Adapter for Cloud Spanner
Clean your Cloud Spanner databases with Database Cleaner.
See also https://github.com/DatabaseCleaner/database_cleaner for more information.
Motivation
- You cannot use rspec-rails's
use_transactional_fixtures
option for Cloud Spanner because ActiveRecord Cloud Spanner Adapter doesn't support nested transactions. -
database_cleaner-active_record doesn't support Cloud Spanner perfectly.
- Transaction strategy cannot be used for the same reason as the
use_transactional_fixtures
option. - Truncation strategy isn't available because Cloud Spanner doesn't support
TRUNCATE
statement. - Deletion strategy is incompatible with Cloud Spanner because
DELETE FROM <table>
statement executed by the deletion strategy doesn't work on Cloud Spanner.
- Transaction strategy cannot be used for the same reason as the
- Cloud Spanner is sometimes used with Spanner Client instead of ActiveRecord.
- If tables are interleaved, the order of deletion needs to be considered.
- If tables has foreign key constraints, the order of deletion needs to be considered.
The core ideas of database_cleaner-spanner are:
- no dependence on ActiveRecord
- consider deletion orders based on actual schema
NOTE: This gem determines deletion orders based on dependency graph of tables using the topological sort algorithm, which means only
option and except
option don't guarantees removal of as many tables as dependencies allow.
Installation
# Gemfile
group :test do
gem "database_cleaner-spanner"
end
Example
Configuration for RSpec on Rails:
# spec/rails_helper.rb
RSpec.configure do |config|
config.use_transactional_fixtures = false
config.around(:each) do |example|
DatabaseCleaner[:spanner].cleaning do
example.run
end
end
end
Supported strategies
The Cloud Spanner adapter has only the deletion strategy.
Strategy configuration options
-
:batch_deletion
- When set totrue
, batch DML is used for cleaning. Defaults tofalse
. -
:cache_tables
- When set totrue
, the list of tables to delete and the deletion orders will be read from the Cloud Spanner once, otherwise they will be read before each deletion. Defaults totrue
.
Adapter configuration options
You need to specify instance and database, or to pass an instance of Spanner client. If you're using ActiveRecord, you can use database name on ActiveRecord. This adapter tries to get database configurations from ActiveRecord.
# Specify instance and database with default credentials and project ID.
DatabaseCleaner[:spanner].db = {
instance_id: "my-instance",
database_id: "my-database",
}
# In addition, specify project ID and credentials.
DatabaseCleaner[:spanner].db = {
credentials: "/path/to/key.json",
project_id: "my-project",
instance_id: "my-instance",
database_id: "my-database",
}
# ActiveRecord database name
DatabaseCleaner[:spanner].db = "secondary"
# Spanner client object
DatabaseCleaner[:spanner].db =
Google::Cloud::Spanner.new.client("my-instance", "my-database")
See Spanner client reference for more database options.
Development
After checking out the repo, run bin/setup
to install dependencies. Then, run rake spec
to run the tests. You can also run bin/console
for an interactive prompt that will allow you to experiment.
To install this gem onto your local machine, run bundle exec rake install
. To release a new version, update the version number in version.rb
, and then run bundle exec rake release
, which will create a git tag for the version, push git commits and the created tag, and push the .gem
file to rubygems.org.
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/nownabe/database_cleaner-spanner. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the code of conduct.
Code of Conduct
Everyone interacting in the DatabaseCleaner::Spanner project's codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.