<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/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>org.nocrala.tools.database</groupId>
  <artifactId>tartarus</artifactId>
  <version>3.2.7</version>
  <packaging>jar</packaging>

  <name>Tartarus - Database Structure Retriever</name>

  <description>
    This library retrieves the structure of a database schema including tables, views, sequences, 
    primary keys, foreign keys, unique keys, column auto-generation, and more.
  </description>

  <url>https://sourceforge.net/projects/tartarus/</url>

  <licenses>
    <license>
      <name>The Apache Software License, Version 2.0</name>
      <url>http://www.apache.org/licenses/LICENSE-2.0.txt</url>
      <distribution>repo</distribution>
    </license>
  </licenses>

  <developers>
    <developer>
      <id>valarcon</id>
      <name>Vladimir Alarcon</name>
      <email>vladimiralarcon@yahoo.com</email>
      <organization>Empirical Inc.</organization>
      <organizationUrl />
      <roles>
        <role>Programmer</role>
      </roles>
      <timezone>America/New York</timezone>
    </developer>
  </developers>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <project.scm.id>source-forge-git-server</project.scm.id>  <!-- for the release plugin -->
  </properties>

  <dependencies>

    <!-- List Collector -->

    <dependency>
      <groupId>org.nocrala.tools.lang.collector</groupId>
      <artifactId>list-collector</artifactId>
      <version>1.0.5</version>
    </dependency>
    
  </dependencies>

  <scm>
    <developerConnection>scm:git:ssh://git.code.sf.net/p/tartarus/tartarus</developerConnection>
    <url>https://sourceforge.net/p/tartarus/tartarus/ci/master/tree/</url>
    <tag>3.2.7</tag>
  </scm>

  <distributionManagement>
    <snapshotRepository>
      <id>ossrh</id>
      <url>https://oss.sonatype.org/content/repositories/snapshots</url>
    </snapshotRepository>
    <repository>
      <id>ossrh</id>
      <url>https://oss.sonatype.org/service/local/staging/deploy/maven2</url>
    </repository>
  </distributionManagement>

  <build>

    <plugins>
  
      <!-- Set the release tag to the version number only, and single versioning -->

      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-release-plugin</artifactId>
        <version>3.0.0-M1</version><!--$NO-MVN-MAN-VER$-->
        <configuration>
          <tagNameFormat>@{project.version}</tagNameFormat>
          <autoVersionSubmodules>true</autoVersionSubmodules>
        </configuration>
      </plugin>
      
      <!-- Replaces "deploy" step with full Nexus Deploy + Close + Release on Maven Central -->

      <plugin>
        <groupId>org.sonatype.plugins</groupId>
        <artifactId>nexus-staging-maven-plugin</artifactId>
        <version>1.6.13</version>
        <extensions>true</extensions>
        <configuration>
          <serverId>ossrh</serverId>
          <nexusUrl>https://oss.sonatype.org/</nexusUrl>
          <autoReleaseAfterClose>true</autoReleaseAfterClose>
        </configuration>
      </plugin>

    </plugins>

  </build>

  <profiles>

    <profile>
      <id>release</id>
      <build>

        <plugins>

          <!-- Produce sources package - For Maven Central publishing -->

          <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-source-plugin</artifactId>
            <version>3.1.0</version>
            <executions>
              <execution>
                <id>attach-sources</id>
                <goals>
                  <goal>jar</goal>
                </goals>
              </execution>
            </executions>
          </plugin>
 
          <!-- Produce the Javadocs package - For Maven Central publishing -->

          <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-javadoc-plugin</artifactId>
            <version>3.1.0</version>
            <executions>
              <execution>
                <id>attach-javadocs</id>
                <goals>
                  <goal>jar</goal>
                </goals>
              </execution>
            </executions>
          </plugin>

          <!-- Sign components using GPG - For Maven Central publishing -->

          <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-gpg-plugin</artifactId>
            <version>1.5</version>
            <executions>
              <execution>
                <id>sign-artifacts-passphrase</id>
                <phase>verify</phase>
                <goals>
                  <goal>sign</goal>
                </goals>
              </execution>
            </executions>
          </plugin>

        </plugins>

      </build>
    </profile>

    <!-- Oracle execution -->

    <profile>
      <id>run-oracle</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.OracleSurfer</mainClass>
              <arguments>
                <argument>oracle.jdbc.driver.OracleDriver</argument>
                <argument>jdbc:oracle:thin:@192.168.56.95:1521:ORCL</argument>
                <argument>user1</argument>
                <argument>pass1</argument>
                <argument />
                <argument>SCHEMA2</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>com.oracle.ojdbc</groupId>
                <artifactId>ojdbc8</artifactId>
                <version>19.3.0.0</version>
                <scope>runtime</scope>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>


    <profile>
      <id>ora-co</id> <!-- Check Oracle constraints lookup -->
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.other.OraConstraintsSurfer</mainClass>
              <arguments>
                <argument>oracle.jdbc.driver.OracleDriver</argument>
                <argument>jdbc:oracle:thin:@192.168.56.95:1521:ORCL</argument>
                <argument>user1</argument>
                <argument>pass1</argument>
                <argument />
                <argument>USER1</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>com.oracle.ojdbc</groupId>
                <artifactId>ojdbc8</artifactId>
                <version>19.3.0.0</version>
                <scope>runtime</scope>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- DB2 execution -->

    <profile>
      <id>run-db2</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.DB2Surfer</mainClass>
              <arguments>
                <argument>com.ibm.db2.jcc.DB2Driver</argument>
                <argument>jdbc:db2://192.168.56.44:50000/empusa</argument>
                <argument>user1</argument>
                <argument>pass1</argument>
                <argument />
                <argument>USER1</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>com.ibm.db2</groupId>
                <artifactId>jcc</artifactId>
                <version>11.5.0.0</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- PostgreSQL execution -->

    <profile>
      <id>run-postgresql</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.PostgreSQLSurfer</mainClass>
              <arguments>
                <argument>org.postgresql.Driver</argument>
                <argument>jdbc:postgresql://192.168.56.214:5432/hotrod</argument>
                <argument>user1</argument>
                <argument>pass1</argument>
                <argument />
                <argument>public</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>org.postgresql</groupId>
                <artifactId>postgresql</artifactId>
                <version>42.2.9</version>
                <type>jar</type>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <profile>
      <id>run-postgresql-views</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.PostgreSQLViews</mainClass>
              <arguments>
                <argument>org.postgresql.Driver</argument>
                <argument>jdbc:postgresql://192.168.56.213:5432/postgres</argument>
                <argument>postgres</argument>
                <argument>mypassword</argument>
                <argument />
                <argument>public</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>org.postgresql</groupId>
                <artifactId>postgresql</artifactId>
                <version>42.2.9</version>
                <type>jar</type>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- SQLServer execution -->

    <profile>
      <id>run-sqlserver</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.SQLServerSurfer</mainClass>
              <arguments>
                <argument>com.microsoft.sqlserver.jdbc.SQLServerDriver</argument>
                <argument>jdbc:sqlserver://192.168.56.51:1433</argument>
                <argument>admin</argument>
                <argument>admin</argument>
                <argument>master</argument>
                <argument>dbo</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>com.microsoft.sqlserver</groupId>
                <artifactId>mssql-jdbc</artifactId>
                <version>7.4.1.jre8</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- MySQL execution -->

    <profile>
      <id>run-mysql</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.MySQLSurfer</mainClass>
              <arguments>
                <argument>com.mysql.cj.jdbc.Driver</argument>
                <argument>jdbc:mysql://192.168.56.29:3306/hotrod?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC&amp;useSSL=false</argument>
                <argument>user1</argument>
                <argument>pass1</argument>
                <argument>hotrod</argument>
                <argument />
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.18</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- Sybase ASE execution -->

    <profile>
      <id>run-sybasease</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.SybaseASESurfer</mainClass>
              <arguments>
                <argument>com.sybase.jdbc4.jdbc.SybDriver</argument>
                <argument>jdbc:sybase:Tds:192.168.56.52:5000</argument>
                <argument>sa</argument>
                <argument>pass12</argument>
                <argument>master</argument>
                <argument>dbo</argument>
                <argument>lib/jconn4.jar</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
          </plugin>
        </plugins>
      </build>

    </profile>
    
    <!-- H2 execution -->

    <profile>
      <id>run-h2</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.H2Surfer</mainClass>
              <arguments>
                
                <argument>org.h2.Driver</argument>
                <argument>jdbc:h2:mem:EXAMPLEDB;INIT=runscript from 'src/main/database/h2/schema.sql';DB_CLOSE_DELAY=-1</argument>
                <argument>sa</argument>
                <argument>""</argument>
                <argument />
                <argument>PUBLIC</argument>
                
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>com.h2database</groupId>
                <artifactId>h2</artifactId>
                <version>2.1.214</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- HyperSQL execution -->

    <profile>
      <id>run-hypersql</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.HyperSQLSurfer</mainClass>
              <arguments>
                <argument>org.hsqldb.jdbcDriver</argument>
                <argument>jdbc:hsqldb:hsql://localhost:9001/xdb</argument>
                <argument>SA</argument>
                <argument />
                <argument>PUBLIC</argument>
                <argument>PUBLIC</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>org.hsqldb</groupId>
                <artifactId>hsqldb</artifactId>
                <version>2.5.0</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

    <!-- Derby execution -->

    <profile>
      <id>run-derby</id>
      <build>
        <plugins>
          <plugin>
            <groupId>org.codehaus.mojo</groupId>
            <artifactId>exec-maven-plugin</artifactId>
            <version>1.4.0</version>
            <configuration>
              <mainClass>tests.surfer.DerbySurfer</mainClass>
              <arguments>
                <argument>org.apache.derby.jdbc.ClientDriver</argument>
                <argument>jdbc:derby://192.168.56.26:1527/hotrod</argument>
                <argument>SCHEMA1</argument>
                <argument>b</argument>
                <argument />
                <argument>SCHEMA1</argument>
              </arguments>
              <includePluginDependencies>true</includePluginDependencies>
              <classpathScope>test</classpathScope>
              <cleanupDaemonThreads>false</cleanupDaemonThreads>
            </configuration>
            <dependencies>
              <dependency>
                <groupId>org.apache.derby</groupId>
                <artifactId>derbyclient</artifactId>
                <version>10.13.1.1</version>
              </dependency>
            </dependencies>
          </plugin>
        </plugins>
      </build>
    </profile>

  </profiles>

</project>
