caputomarcos / dbtrolls

dbtrolls - A simple tool to make Dev's life happy.

dbtrolls

A simple tool to make Dev's life happy.

License

Licensed under the GNU General Public License (GPL).

Install

Follow the steps below to get everything up and running.

pip

Package Index > dbtrolls > 1.1 pip.

1. Create project folder:

   $ mkdir dbtrolls && cd dbtrolls

2. Create virtualenv in the normal way:

   $ virtualenv env --python=python

3. Active your new virtualenv:

   $ source env/bin/activate

4. Install dbtrolls:

   $ pip install dbtrolls

Git

1. Clone repository:

   $ git clone [email protected]:caputomarcos/dbtrolls.git

2. Go to dbtrolls source folder:

   $ cd dbtrolls/

3. Create virtualenv in the normal way:

   $ virtualenv env --python=python

4. Active your new virtualenv:

   $ source env/bin/activate

5. Create dev environment:

   $ make develop

Usage

1. Create config file:

   $ dbtrolls -c --database_source=<DATABASE_SOURCE> --database_target=<DATABASE_TARGET>

2. Execute a single SQL file:

   $ dbtrolls -s <SQL_FILE> --fix --preload

3. Execute a collection of SQL files:

   $ dbtrolls -m