<?xml version="1.0" encoding="UTF-8"?>
<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>

    <parent>
        <groupId>com.atlassian.jira</groupId>
        <artifactId>jira-email-processor-test-parent</artifactId>
        <version>4.4.0-REL-0004</version>
    </parent>

    <artifactId>jira-email-processor-integration-test-parent</artifactId>
    <packaging>pom</packaging>

    <modules>
        <module>integration-test-dbsetup</module>
    </modules>

    <properties>
        <db.host>localhost</db.host>
        <xvfb.enable>true</xvfb.enable>
        <dbconfig.path>src/db</dbconfig.path>
    </properties>

    <profiles>
        <!-- Database profiles -->
        <profile>
            <id>Postgres</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>postgres</value>
                </property>
            </activation>
            <properties>
                <db.artifactGroup>org.postgresql</db.artifactGroup>
                <db.artifactId>postgresql</db.artifactId>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>9.4.1212</db.artifactVersion>
                <db.ofBizFieldType>postgres72</db.ofBizFieldType>
                <db.schema>public</db.schema>
                <db.url>${jdbc.url}</db.url>
                <db.username>postgres</db.username>
                <db.password>postgres</db.password>
                <db.instance>jiradb</db.instance>
                <db.name>${db.instance}</db.name>
                <db.port>5432</db.port>
                <jdbc.url>jdbc:postgresql://${db.host}:${db.port}/${db.instance}</jdbc.url>
                <jdbc.driver>org.postgresql.Driver</jdbc.driver>
                <database.poolsize>10</database.poolsize>
                <database.type>database-type-standard</database.type>
                <database.validation>select version();</database.validation>
                <database.delegator>default</database.delegator>
            </properties>
        </profile>
        <profile>
            <id>Oracle</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>oracle</value>
                </property>
            </activation>
            <properties>
                <db.artifactGroup>com.oracle</db.artifactGroup>
                <db.artifactId>ojdbc8-atlassian-hosted</db.artifactId>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>12.2.0.1</db.artifactVersion>
                <db.ofBizFieldType>oracle10g</db.ofBizFieldType>
                <db.username>SERVICEDESK</db.username>
                <db.password>SERVICEDESK</db.password>
                <db.admin.username>oracle</db.admin.username>
                <db.admin.password>oracle</db.admin.password>
                <jdbc.url>jdbc:oracle:thin:@${db.host}:${db.port}:${db.instance}</jdbc.url>
                <!--<db.admin.username>system</db.admin.username>-->
                <!--<db.admin.password>oracle</db.admin.password>-->
                <!--<jdbc.url>jdbc:oracle:thin:@localhost:1521:xe</jdbc.url>-->
                <jdbc.driver>oracle.jdbc.OracleDriver</jdbc.driver>
                <db.url>${jdbc.url}</db.url>
                <db.port>1521</db.port>
                <db.connectionPoolCN>oracle.jdbc.pool.OracleConnectionPoolDataSource</db.connectionPoolCN>
                <db.schema/>
                <db.instance>TEST</db.instance>
                <db.name>Oracle12c</db.name>
                <db.provider>Oracle12c</db.provider>
                <database.type>database-type-standard</database.type>
                <database.validation>select 1 from dual</database.validation>
                <database.delegator>default</database.delegator>
                <database.poolsize>10</database.poolsize>
            </properties>
        </profile>
        <profile>
            <id>MySQL</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>mysql</value>
                </property>
            </activation>
            <properties>
                <!-- MySQL needs its own dbconfig.xml that omits the schema-name element -->
                <dbconfig.path>src/db/mysql</dbconfig.path>
                <db.artifactGroup>mysql</db.artifactGroup>
                <db.artifactId>mysql-connector-java</db.artifactId>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>5.1.31</db.artifactVersion>
                <db.ofBizFieldType>mysql</db.ofBizFieldType>
                <db.name>MySQL</db.name>
                <db.provider>${db.name}</db.provider>
                <db.port>3307</db.port>
                <db.instance>jira</db.instance>
                <db.username>mysql</db.username>
                <db.password>mysql</db.password>
                <db.admin.username>root</db.admin.username>
                <db.admin.password/>
                <db.url>${jdbc.url}/${db.instance}?useUnicode=true&amp;amp;useServerPrepStmts=false&amp;amp;characterEncoding=UTF-8&amp;amp;sessionVariables=default_storage_engine=InnoDB</db.url>
                <db.connectionPoolCN>com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</db.connectionPoolCN>
                <db.schema>jira</db.schema>
                <jdbc.driver>com.mysql.jdbc.Driver</jdbc.driver>
                <jdbc.url>jdbc:mysql://${db.host}:${db.port}</jdbc.url>
                <database.type>database-type-standard</database.type>
                <database.validation>select 1</database.validation>
                <database.delegator>default</database.delegator>
                <database.poolsize>10</database.poolsize>
            </properties>
        </profile>
        <profile>
            <id>MSSQL</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>mssql</value>
                </property>
            </activation>
            <properties>
                <db.artifactGroup>com.microsoft.sqlserver</db.artifactGroup>
                <db.artifactId>mssql-jdbc</db.artifactId>
                <db.ofBizFieldType>mssql</db.ofBizFieldType>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>7.2.1.jre8</db.artifactVersion>
                <db.admin.username>sa</db.admin.username>
                <db.admin.password>@!1234abc</db.admin.password>
                <db.instance>jiradb</db.instance>
                <db.name>${db.instance}</db.name>
                <db.username>jira</db.username>
                <db.password>jira</db.password>
                <db.schema>jiraschema</db.schema>
                <db.port>1433</db.port>
                <db.url>${jdbc.url};databaseName=${db.instance}</db.url>
                <jdbc.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc.driver>
                <jdbc.url>jdbc:sqlserver://localhost:${db.port};autoCommit=false</jdbc.url>
                <setup.type>custom</setup.type>
                <acceptance.test.dbname>greenhopper</acceptance.test.dbname>
                <sqlserver.database.user>${db.admin.username}</sqlserver.database.user>
                <sqlserver.database.password>${db.admin.password}</sqlserver.database.password>
                <database.name>Microsoft SQL Server</database.name>
                <database.type>database-type-standard</database.type>
                <database.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</database.driver>
                <database.url>jdbc:sqlserver://localhost:${db.port};databaseName=${acceptance.test.dbname};autoCommit=false</database.url>
                <database.user>${sqlserver.database.user}</database.user>
                <database.password>${sqlserver.database.password}</database.password>
                <database.path>C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA</database.path>
                <database.poolsize>10</database.poolsize>
                <database.dialect>net.sf.hibernate.dialect.SQLServerIntlDialect</database.dialect>
                <database.validation>select 1</database.validation>
                <database.delegator>default</database.delegator>
            </properties>
        </profile>
        <profile>
            <id>MSSQL2016</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>mssql2016</value>
                </property>
            </activation>
            <properties>
                <db.artifactGroup>com.microsoft.sqlserver</db.artifactGroup>
                <db.artifactId>mssql-jdbc</db.artifactId>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>7.2.1.jre8</db.artifactVersion>
                <db.ofBizFieldType>mssql</db.ofBizFieldType>
                <db.admin.username>sa</db.admin.username>
                <db.admin.password>@!1234abc</db.admin.password>
                <db.instance>jiradb</db.instance>
                <db.name>${db.instance}</db.name>
                <db.username>jira</db.username>
                <db.password>jira</db.password>
                <db.schema>jiraschema</db.schema>
                <db.port>1433</db.port>
                <db.url>${jdbc.url};databaseName=${db.instance}</db.url>
                <jdbc.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc.driver>
                <jdbc.url>jdbc:sqlserver://localhost:${db.port};autoCommit=false</jdbc.url>
                <setup.type>custom</setup.type>
                <acceptance.test.dbname>greenhopper</acceptance.test.dbname>
                <sqlserver.database.user>${db.admin.username}</sqlserver.database.user>
                <sqlserver.database.password>${db.admin.password}</sqlserver.database.password>
                <database.name>Microsoft SQL Server 2016</database.name>
                <database.type>database-type-standard</database.type>
                <database.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</database.driver>
                <database.url>jdbc:sqlserver://localhost:${db.port};databaseName=${acceptance.test.dbname};autoCommit=false</database.url>
                <database.user>${sqlserver.database.user}</database.user>
                <database.password>${sqlserver.database.password}</database.password>
                <database.path>C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA</database.path>
                <database.poolsize>10</database.poolsize>
                <database.dialect>net.sf.hibernate.dialect.SQLServerIntlDialect</database.dialect>
                <database.validation>select 1</database.validation>
                <database.delegator>default</database.delegator>
            </properties>
        </profile>
        <profile>
            <id>MSSQL2017</id>
            <activation>
                <property>
                    <name>db</name>
                    <value>mssql2017</value>
                </property>
            </activation>
            <properties>
                <db.artifactGroup>com.microsoft.sqlserver</db.artifactGroup>
                <db.artifactId>mssql-jdbc</db.artifactId>
                <!-- This version is specified here for the usage in maven sql plugin's dependency for db-setup.
                    Ideally the pom dependency should consume the artifact from jira-project dependencyManagement -->
                <db.artifactVersion>7.2.1.jre8</db.artifactVersion>
                <db.ofBizFieldType>mssql</db.ofBizFieldType>
                <db.admin.username>sa</db.admin.username>
                <db.admin.password>@!1234abc</db.admin.password>
                <db.instance>jiradb</db.instance>
                <db.name>${db.instance}</db.name>
                <db.username>jira</db.username>
                <db.password>jira</db.password>
                <db.schema>jiraschema</db.schema>
                <db.port>1433</db.port>
                <db.url>${jdbc.url};databaseName=${db.instance}</db.url>
                <jdbc.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc.driver>
                <jdbc.url>jdbc:sqlserver://localhost:${db.port};autoCommit=false</jdbc.url>
                <setup.type>custom</setup.type>
                <acceptance.test.dbname>greenhopper</acceptance.test.dbname>
                <sqlserver.database.user>${db.admin.username}</sqlserver.database.user>
                <sqlserver.database.password>${db.admin.password}</sqlserver.database.password>
                <database.name>Microsoft SQL Server 2017</database.name>
                <database.type>database-type-standard</database.type>
                <database.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</database.driver>
                <database.url>jdbc:sqlserver://localhost:${db.port};databaseName=${acceptance.test.dbname};autoCommit=false</database.url>
                <database.user>${sqlserver.database.user}</database.user>
                <database.password>${sqlserver.database.password}</database.password>
                <database.poolsize>10</database.poolsize>
                <database.dialect>net.sf.hibernate.dialect.SQLServerIntlDialect</database.dialect>
                <database.validation>select 1</database.validation>
                <database.delegator>default</database.delegator>
            </properties>
        </profile>
    </profiles>
</project>
