<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <artifactId>remote-test-resources</artifactId>
  <groupId>dk.nsi.dgws</groupId>
  <name>Resource Bundle for testing DGWS</name>
  <parent>
    <groupId>dk.nsi</groupId>
    <artifactId>dgws</artifactId>
    <version>1.1.4-SNAPSHOT</version>
  </parent>

  <properties>
    <environment-property-file>${basedir}/../environment.properties</environment-property-file>
  </properties>

  <build>
    <plugins>
      <plugin>
        <artifactId>maven-remote-resources-plugin</artifactId>
        <version>1.5</version>
        <executions>
          <execution>
            <goals>
              <goal>bundle</goal>
            </goals>
          </execution>
        </executions>
        <configuration>
          <includes>
            <include>**/*.sql</include>
            <include>**/*.xml</include>
            <include>**/*.jks</include>
          </includes>
        </configuration>
      </plugin>
    </plugins>
  </build>

  <profiles>
    <profile>
      <id>schema-setup</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>properties-maven-plugin</artifactId>
            <version>1.0-alpha-2</version>
            <executions>
              <execution>
                <phase>initialize</phase>
                <goals>
                  <goal>read-project-properties</goal>
                </goals>
                <configuration>
                  <files>
                    <file>${environment-property-file}</file>
                  </files>
                </configuration>
              </execution>
            </executions>
          </plugin>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>sql-maven-plugin</artifactId>
            <version>1.5</version>

            <dependencies>
              <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
              </dependency>
            </dependencies>

            <configuration>
              <driver>com.mysql.jdbc.Driver</driver>
              <url>${database.url}</url>
              <username>${database.user}</username>
              <password>${database.pw}</password>
            </configuration>

            <executions>
              <execution>
                <id>setup-schema</id>
                <phase>initialize</phase>
                <goals>
                  <goal>execute</goal>
                </goals>
                <configuration>
                  <fileset>
                    <basedir>${basedir}/src/main/resources</basedir>
                    <includes>
                      <include>createWhitelistSchema.sql</include>
                    </includes>
                  </fileset>
                </configuration>
              </execution>
              <execution>
                <id>populate-schema</id>
                <phase>initialize</phase>
                <goals>
                  <goal>execute</goal>
                </goals>
                <configuration>
                  <fileset>
                    <basedir>${basedir}/src/main/resources</basedir>
                    <includes>
                      <include>populateWhitelist.sql</include>
                    </includes>
                  </fileset>
                </configuration>
              </execution>
            </executions>
          </plugin>
        </plugins>
      </build>
    </profile>
  </profiles>
</project>
    