Skip to content

Latest commit

 

History

History
59 lines (43 loc) · 2.03 KB

README.md

File metadata and controls

59 lines (43 loc) · 2.03 KB

Build Status

Dockerized Flyway

Example (see test directory):

$ cd test

$ docker-compose up -d postgres
Creating network "test_default" with the default driver
Creating test_postgres_1

$ docker-compose run --rm flyway info
Flyway 4.0.1 by Boxfuse

Database: jdbc:postgresql://postgres:5432/postgres (PostgreSQL 9.5)

+---------+---------------------+---------------------+---------+
| Version | Description         | Installed on        | State   |
+---------+---------------------+---------------------+---------+
| 1       | create person table |                     | Pending |
+---------+---------------------+---------------------+---------+

$ docker-compose run --rm flyway
Flyway 4.0.1 by Boxfuse

Database: jdbc:postgresql://postgres:5432/postgres (PostgreSQL 9.5)
Successfully validated 1 migration (execution time 00:00.010s)
Creating Metadata table: "public"."schema_version"
Current version of schema "public": << Empty Schema >>
Migrating schema "public" to version 1 - create person table
Successfully applied 1 migration to schema "public" (execution time 00:00.081s).

$ docker-compose run --rm flyway info
Flyway 4.0.1 by Boxfuse

Database: jdbc:postgresql://postgres:5432/postgres (PostgreSQL 9.5)

+---------+---------------------+---------------------+---------+
| Version | Description         | Installed on        | State   |
+---------+---------------------+---------------------+---------+
| 1       | create person table | 2016-07-10 15:48:31 | Success |
+---------+---------------------+---------------------+---------+

$ docker-compose run --rm postgres psql -h postgres -p 5432 -U postgres postgres -c "\dt"
             List of relations
 Schema |      Name      | Type  |  Owner
--------+----------------+-------+----------
 public | person         | table | postgres
 public | schema_version | table | postgres
(2 rows)

$ docker-compose down -v

Reference

https://flywaydb.org/getstarted/firststeps/commandline