SBT Task: flywayClean

Drops all objects (tables, views, procedures, triggers, ...) in the configured schemas.

Usage

> sbt flywayClean

Configuration

Parameter Required Default Description
flywayUrl YES The jdbc url to use to connect to the database
flywayDriver NO Auto-detected based on url The fully qualified classname of the jdbc driver to use to connect to the database
flywayUser NO The user to use to connect to the database
flywayPassword NO The password to use to connect to the database
flywaySchemas NO default schema of the connection Case-sensitive list of schemas managed by Flyway.
The schemas will be cleaned in the order of this list.
flywayCallbacks NO Fully qualified class names of FlywayCallback implementations to use to hook into the Flyway lifecycle.
flywaySkipDefaultCallbacks NO false Whether default built-in callbacks (sql) should be skipped. If true, only custom callbacks are used.
flywayCleanDisabled NO false Whether to disable clean. This is especially useful for production environments where running clean can be quite a career limiting move.

Sample configuration

flywayDriver := "org.hsqldb.jdbcDriver"

flywayUrl := "jdbc:hsqldb:file:target/flyway_sample;shutdown=true"

flywayUser := "SA"

flywayPassword := "mySecretPwd"

flywaySchemas := Seq("schema1", "schema2", "schema3")

flywayCallbacks := Seq("com.mycompany.CustomCallback", "com.mycompany.AnotherCallback")

flywaySkipDefaultCallbacks := false

flywayDisabled := false

Sample output

> sbt flywayClean

[info] Cleaned database schema 'PUBLIC' (execution time 00:00.016s)

SBT: info