Sample of using Rumba[rdbm]

This is a set of scripts demonstrate usage of Rumba[rdbm] by DBinvent.

Rumba is a database schema migration tool for PostgreSQL that helps manage, control and deploy database schema changes across various environments and development stages.

It employs the automatic SQL generation and plain-SQL approach in one software. Scripts can be assigned with a version and a certain migration phase, which brings developers true flexibility to perform the action at an exact migration stage.

Every usecase perform migration and YAML & SQL dump to compare with expected result.

Usecases:

1. Baseline Test license and perform a self migration.

2. Create DB Test Create User(role) and Database on demand.

3. Simple migration Simple migration with tracking versioned YAML and SQL script

4. Versioned YAML schemas migration Multiple YAML scripts with limit by defining target version

5. Versioned SQL migration Multiple SQL scripts with limit by defining target version

   comming soon...

6. StoredProc Repeatable migration

7. Complex Mixed YAML Schemas, SQL, Triggers and Pre Deploy SQL

8. Tag and User Add tagging and user info into migration

9. Simple ETL Simple example of Extract (Transform) Load data with the schema migration

10. ETL: mixes SQL and CSV Mixing data sourcing from plain SQL and CSV

11. Dry Run Show generated SQL code without real execution

12. Log DB Copy Deployment history journal to another DB

Get a list of all available test cases:

./test.sh 

Run a test case within a Docker container:

./test.sh baseline # or any other usecase your prefer to run

Run a test case and keep it open with Postgres client:

./test.sh baseline psql

So, you can check generated tables and history journal.

Run a test case and keep it open with Bash client:

./test.sh baseline bash

Very useful to play with preconfigured rdbm app. Try: rdbm help