<?xml version="1.0"?>
<!--

    Copyright (c) 2018 Oracle and/or its affiliates. All rights reserved.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->

<project name="SecurityAPI Database Initialization" basedir="." default="init.javadb">

    <property file="${ts.home}/ts.jte"/>    
    <property name="sql.base.dir" value="${ts.home}/sql"/>   
    
    <target name="init.derby">
        <antcall target="configure.backend">
            <param name="db.delimiter" value=";"/>            
        </antcall>    
    </target>
   
	<target name="init.javadb" >
      <antcall target="init.derby"/>
    </target>

    <target name="init.db2">
        <antcall target="configure.backend">
            <param name="db.delimiter" value="!"/>            
        </antcall>
    </target>

    <target name="init.mssqlserver">
        <antcall target="configure.backend">
            <param name="db.delimiter" value="!"/>           
        </antcall>
    </target>

    <target name="init.mysql">
        <antcall target="configure.backend">
            <param name="db.delimiter" value="!"/>            
        </antcall>
    </target>
	
    <target name="init.oracle">
        <antcall target="configure.backend">
            <param name="db.delimiter" value="!"/>            
        </antcall>
    </target>

    <target name="init.postgresql" >
        <antcall target="configure.backend" >
            <param name="db.delimiter" value=";"/>            
        </antcall>
    </target>

    <target name="init.pointbase">
        <antcall target="configure.backend">
            <param name="db.delimiter" value=";"/>            
        </antcall>
    </target>

    <target name="init.sybase">
        <antcall target="configure.backend">
            <param name="db.delimiter" value="!"/>
        </antcall>
    </target>
    
    <target name="configure.backend">
        <echo message="db.driver is ${db.driver}"/>
        <echo message="db.url is ${db.url}"/>
        <echo message="db.lib is ${db.lib}"/>
        <echo message="db.delimiter is ${db.delimiter}"/>
        <echo message="db.user is ${db.user}"/>
        <sql driver="${db.driver}"
             url="${db.url}"
             userid="${db.user}"
             password="${db.password}"
             classpath="${db.lib}"
             delimiter="${db.delimiter}"
             autocommit="true"
             onerror="continue">            
            <transaction
                src="${ts.home}/sql/${jdbc.db}/${jdbc.db}.ddl.securityapi.sql"/>            
        </sql>
    </target>       

</project>
