Geeks With Blogs
Tom Stickel Thoughts on Software Engineering

<?xml version="1.0"?>

<project name="schemaspy" default="main" basedir=".">

                <property name="src.dir" value="src"/>

                <property name="build.dir" value="${src.dir}/build"/>

                <property name="metadata.dir" value="${build.dir}/metadata"/>

                <property name="kb.dir" value="${build.dir}/kb"/>

                <property name="program.dir" value="${build.dir}/program"/>

                <property name="project.dir" value="${build.dir}/project"/>

                <property name="account.dir" value="${build.dir}/account"/>

                <property name="enterprise.dir" value="${build.dir}/enterprise"/>

                <property name="transactions.dir" value="${build.dir}/transactions"/>

                <property name="notification.dir" value="${build.dir}/notification"/>

                <property name="reconciliation.dir" value="${build.dir}/reconciliation"/>

                <property name="people.dir" value="${build.dir}/people"/>

                <property file="build.properties"/>

               

                <target name="clean">

                                <delete dir="${build.dir}"/>

                </target>

 

                <target name="compile">

                                <!-- Compile the java code -->

                                <mkdir dir="${src.dir}"/>

                                <mkdir dir="${metadata.dir}"/>

                                <mkdir dir="${kb.dir}"/>

                                <mkdir dir="${program.dir}"/>

                                <mkdir dir="${project.dir}"/>

                                <mkdir dir="${account.dir}"/>

                                <mkdir dir="${enterprise.dir}"/>

                                <mkdir dir="${transactions.dir}"/>

                                <mkdir dir="${notification.dir}"/>

                                <mkdir dir="${reconciliation.dir}"/>

                                <mkdir dir="${people.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${metadata.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${kb.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${program.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${project.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${account.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${enterprise.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${transactions.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${notification.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${reconciliation.dir}"/>

                                <javac srcdir="${src.dir}" destdir="${people.dir}"/>

                               

                </target>

               

                <target name="metadata" depends="compile">

                                <echo>starting to generate metadata schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${metadata.dir}/output.log" error="${metadata.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (ELEMENT_CATALOG)|(ELEMENT_TYPE)|(MODULE_CATALOG)|(FORM_CATALOG)|(FORM_ELEMENT)|(GROUP_FORM_ELEMENT)|(OBJECT_CATALOG)|(OBJECT_TYPE)|(MESSAGE_CATALOG)|(MESSAGE_CONTENT)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${metadata.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="kb" depends="compile">

                                <echo>starting to generate kb schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${kb.dir}/output.log" error="${kb.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (RULE_TYPE)|(RULE_CATALOG)|(RULE_SEVERITY)|(KNOWLEDGE_BASE)|(KB_ACTION_TYPE)|(VALIDATION_RULE_CATALOG)|(RESPONSE_CATALOG)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${kb.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="program" depends="compile">

                                <echo>starting to generate program schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${program.dir}/output.log" error="${program.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (ACCT_TYPE)|(ACCT_TYPE_PROGRAM)|(ACCOUNT)|(PROGRAM)|(PROGRAM_TYPE_CATEGORY_CODE)|(PROGRAM_TYPE_CODE)|(PEOPLE_RELATIONSHIP)|(PROGRAM_PARAMETER)|(PEOPLE)|(PROGRAM_STATUS_CODE)|(PROGRAM_RELATIONSHIP_TRANSFER)|(PROJECT)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${program.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

               

                <target name="project" depends="compile">

                                <echo>starting to generate project schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${project.dir}/output.log" error="${project.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (PEOPLE)|(PROJECT.*)|(ALLOW_VINTAGE)|(CREDIT_PERIOD_TYPE)|(LULUCF)|(COUNTRY)|(BLOCK_TYPE)|(ENTERPRISE)|(PEOPLE_RELATIONSHIP)|(JI_TRACK_TYPE_CODE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${project.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="account" depends="compile">

                                <echo>starting to generate account schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${account.dir}/output.log" error="${account.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (ALLOWANCE_HOLD)|(TRANSACTION)|(ACCT_CATEGORY)|(ACCOUNT_ENTERPRISE)|(ACCOUNT)|(ACCT_TYPE)|(ENTERPRISE)|(ACCT_STATUS)|(ACCT_TYPE_PROGRAM)|(ACCOUNT_FLOWBACK)|(ACCOUNT_COMPLIANCE)|(ACCT_ENTERPRISE_STATUS_CODE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${account.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="enterprise" depends="compile">

                                <echo>starting to generate enterprise schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${enterprise.dir}/output.log" error="${enterprise.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (PEOPLE)|(PEOPLE_RELATIONSHIP)|(ADDRESS_RELATIONSHIP)|(PROJECT)|(ENTERPRISE)|(PROJECT_ENTERPRISE)|(PARTY)|(ENTERPRISE_ROLE)|(ACCOUNT)|(ACCOUNT_ENTERPRISE)|(ENTERPRISE_TYPE_CODE)|(ENTERPRISE_GROUP_CODE)|(ENTERPRISE_TYPE_CATEGORY_CODE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${enterprise.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="transactions" depends="compile">

                                <echo>starting to generate transactions schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${transactions.dir}/output.log" error="${transactions.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (TRANSACTION_RE.*)|(TRANSACTION_STATUS_CODE)|(TRANSACTION_STATUS_CATEGORY)|(TRANSACTION_SCRATCH)|(TRANSACTION_BLOCK_RECEIVED)|(TRANSACTION_STATUS)|(TRANSACTION)|(ACCOUNT)|(RECON_LOG)|(NOTIFICATION)|(TRANSACTION_TYPE)|(TRANSACTION_BLOCK)|(TRANSACTION_CATEGORY)|(PEOPLE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${transactions.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

 

               

                <target name="notification" depends="compile">

                                <echo>starting to generate notification schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${notification.dir}/output.log" error="${notification.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (ACCOUNT_NOTIFICATION)|(NOTIFICATION)|(NOTIFICATION_STATUS)|(NOTIFICATION_STATUS_CODE)|(NOTIFICATION_DISPLAY_LEVEL)|(NOTIFICATION_TYPE)|(LULUCF)|(ALLOW_VINTAGE)|(NOTIFICATION_BLOCK)|(PROJECT)|(BLOCK_TYPE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${notification.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="reconciliation" depends="compile">

                                <echo>starting to generate reconciliation schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${reconciliation.dir}/output.log" error="${reconciliation.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (RECON.*)|(TRANSACTION)|(SNAPSHOT_LOG)|(SNAPSHOT_TOTAL)|(SNAPSHOT_BLOCK)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${reconciliation.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="people" depends="compile">

                                <echo>starting to generate people schema</echo>

                                <java jar="schemaSpy_4.1.1.jar" output="${people.dir}/output.log" error="${people.dir}/error.log" fork="true">

                                  <arg line="-t mssql05-jtds"/>

                                  <arg line="-host rapidan"/>

                                  <arg line="-port 3006"/>

                                  <arg line="-db eats_nz"/>

                                  <arg line="-u eats"/>

                                  <arg line="-p eats"/>

                                  <arg line="-norows"/>

                                  <arg line="-s dbo"/>

                                  <arg line="-noimplied"/>

                                  <arg line="-i (PEOPLE.*)|(PROGRAM)|(PROJECT)|(ENTERPRISE)|(ACCOUNT)|(RELATIONSHIP_TYPE)"/>

                                  <arg line="-hq"/>

                                  <arg line="-o ${people.dir}"/>

                                </java>

                                <echo>done with schema</echo>

                </target>

               

                <target name="main" depends="clean,metadata,kb,program,project,account,enterprise,transactions,notification,reconciliation,people"/>

               

               

</project>

Posted on Thursday, February 2, 2012 12:29 AM | Back to top


Comments on this post: My ANT File for SchemaSpy

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © TomStickel | Powered by: GeeksWithBlogs.net