db-manager-plugin

Maven plugin to drop/create/dump databases

License	Apache 2
Categories	Maven Build Tools
GroupId	com.vecna.maven
ArtifactId	db-manager-plugin
Last Version	1.8
Release Date	Jul 31, 2017
Type	maven-plugin
Description	db-manager-plugin Maven plugin to drop/create/dump databases
Project Organization	Vecna Technologies
Source Code Management	https://github.com/vecnatechnologies/db-manager-plugin

Download db-manager-plugin

Filename	Size
db-manager-plugin-1.8.pom
db-manager-plugin-1.8.jar	16 KB
db-manager-plugin-1.8-sources.jar	12 KB
db-manager-plugin-1.8-javadoc.jar	66 KB

How to add to project

Apache Maven

<plugin>
    <groupId>com.vecna.maven</groupId>
    <artifactId>db-manager-plugin</artifactId>
    <version>1.8</version>
</plugin>

Dependencies

compile (2)

Group / Artifact	Type	Version
org.codehaus.plexus : plexus-utils	jar	1.5.1
com.google.guava : guava	jar	13.0.1

provided (4)

Group / Artifact	Type	Version
org.apache.maven.plugin-tools : maven-plugin-annotations	jar	3.2
org.apache.maven : maven-plugin-api	jar	2.0
postgresql : postgresql	jar	9.3-1102.jdbc41
mysql : mysql-connector-java	jar	5.1.43

test (1)

Group / Artifact	Type	Version
junit : junit	jar	3.8.1

Project Modules

There are no modules declared in this project.

db-manager-plugin

About

This is a very simple Maven plugin that can create, drop, and dump PostgreSQL and MySql databases.

Usage

The plugin requires the JDBC url, username, and password to be specified. Add the appropriate version of the JDBC driver as a dependency.

<plugin>
  <groupId>com.vecna</groupId>
  <artifactId>db-manager-plugin</artifactId>
  <configuration>
	<url>jdbc:postgresql://localhost/mydb</url>
	<username>user</username>
	<password>mypass</password>
  </configuration>
  <dependencies>
    <dependency>
      <groupId>postgresql</groupId>
      <artifactId>postgresql</artifactId>
      <version>9.3-1102.jdbc41</version>
    </dependency>
  </dependencies>
</plugin>

<plugin>
  <groupId>com.vecna</groupId>
  <artifactId>db-manager-plugin</artifactId>
  <configuration>
	<url>jdbc:mysql://localhost/mydb</url>
	<username>user</username>
	<password>mypass</password>
  </configuration>
  <dependencies>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.43</version>
    </dependency>
  </dependencies>
</plugin>

Goals

• create: creates the database (by running "create database ...").
• drop: drops the database (by running "drop database ...").
• dump: dumps the database to a file (requires pg_dump or mysqldump).

Other DBs

The plugin only works with PostgreSQL and MySql. To support another database, create a new implementation of the DbStrategy interface.

Vecna Technologies, Inc.

Versions

Version
1.8 Jul 31, 2017
1.7 Jul 28, 2017
1.5 Aug 31, 2014