README.md

sql-maven-plugin

Execute SQL commands during a Maven build. Can be used to create a database for an integration test.

Usage

Add this to your POM to execute your scripts during the verify phase:

<build>
  <plugins>
    <plugin>
      <groupId>com.github.dijkstraj</groupId>
      <artifactId>sql-maven-plugin</artifactId>
      <version>1.0-SNAPSHOT</version>
      <configuration>
        <url>jdbc:mysql://127.0.0.1:3306</url>
        <username>root</username>
        <password>${mysql.root.password}</password>
      </configuration>
      <executions>
        <execution>
          <id>create-databases</id>
          <goals>
            <goal>execute</goal>
          </goals>
          <configuration>
            <fileSet>
              <directory>src/test/sql</directory>
              <includes>
                <include>create-databases.sql</include>
                <include>insert-testdata.sql</include>
              </includes>
            </fileSet>
          </configuration>
        </execution>
      </executions>
    </plugin>
  </plugins>
</build>