sgruhier/capistrano-db-tasks

# CapistranoDbTasks | [![Gem Downloads](http://img.shields.io/gem/dt/capistrano-db-tasks.svg)](https://rubygems.org/gems/capistrano-db-tasks) [![Code Climate](https://codeclimate.com/github/sgruhier/capistrano-db-tasks/badges/gpa.svg)](https://codeclimate.com/github/sgruhier/capistrano-db-tasks) [![Gem Version](https://badge.fury.io/rb/capistrano-db-tasks.svg)](http://badge.fury.io/rb/capistrano-db-tasks)

Add database AND assets tasks to capistrano to a Rails project. It only works with capistrano 3. Older versions until 0.3 works with capistrano 2.

Currently

* It only supports mysql and postgresql (both side remote and local)
* Synchronize assets remote to local and local to remote

Commands mysql, mysqldump (or pg\_dump, psql), bzip2 and unbzip2 (or gzip) must be in your PATH

Feel free to fork and to add more database support or new tasks.

## Install

Add it as a gem:

```ruby
gem "capistrano-db-tasks", require: false
```

Add to config/deploy.rb:

```ruby
require 'capistrano-db-tasks'

# if you haven't already specified
set :rails_env, "production"

# if you want to remove the local dump file after loading
set :db_local_clean, true

# if you want to remove the dump file from the server after downloading
set :db_remote_clean, true

# if you want to exclude table from dump
set :db_ignore_tables, []

# if you want to exclude table data (but not table schema) from dump
set :db_ignore_data_tables, []

# configure location where the dump file should be created
set :db_dump_dir, "./db"

# If you want to import assets, you can change default asset dir (default = system)
# This directory must be in your shared directory on the server
set :assets_dir, %w(public/assets public/att)
set :local_assets_dir, %w(public/assets public/att)

# if you want to work on a specific local environment (default = ENV['RAILS_ENV'] || 'development')
set :locals_rails_env, "production"

# if you are highly paranoid and want to prevent any push operation to the server
set :disallow_pushing, true

# if you prefer bzip2/unbzip2 instead of gzip
set :compressor, :bzip2
```

Add to .gitignore

```yml
/db/*.sql
```

[How to install bzip2 on Windows](http://stackoverflow.com/a/25625988/3324219)

## Available tasks

```
app:local:sync      || app:pull     # Synchronize your local assets AND database using remote assets and database
app:remote:sync     || app:push     # Synchronize your remote assets AND database using local assets and database

assets:local:sync   || assets:pull  # Synchronize your local assets using remote assets
assets:remote:sync  || assets:push  # Synchronize your remote assets using local assets

db:local:sync       || db:pull      # Synchronize your local database using remote database data
db:remote:sync      || db:push      # Synchronize your remote database using local database data
```

## Example

#### Replace your local database with the production database

This use case allows you to have the same data on your machine as your production.
You then can reproduce or test things before to apply to your production.

```bash
cap db:pull
cap production db:pull # if you are using capistrano-ext to have multistages
```

#### Replace your local database using a dump file stored on your machine

In case you have a dump file on your machine (you used `db:pull` and kept some files)
and you want to replay one of them, you can use the `db:local:load`:

```
cap development db:local:load DUMP_FILE=db/myapp_production_2018-01-10-150434.sql
```
(You have to create a `config/deploy/development.rb` file containing
`set :stage, :development` at least in order to get this working)

## Contributors

* tilsammans (http://github.com/tilsammansee)
* bigfive    (http://github.com/bigfive)
* jakemauer  (http://github.com/jakemauer)
* tjoneseng  (http://github.com/tjoneseng)
* numbata    (http://github.com/numbata)
* rafaelsales (http://github.com/rafaelsales)
* rdeshpande (http://github.com/rdeshpande)

## TODO

* May be change project's name as it's not only database tasks now :)
* Add tests

Copyright (c) 2009 [Sébastien Gruhier - XILINUS], released under the MIT license