Skip to main content
summaryrefslogtreecommitdiffstats
path: root/plugins/org.eclipse.osee.framework.database/support
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/org.eclipse.osee.framework.database/support')
-rw-r--r--plugins/org.eclipse.osee.framework.database/support/dbrelease.xml174
-rw-r--r--plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml168
2 files changed, 171 insertions, 171 deletions
diff --git a/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml b/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml
index 84fd5bb354d..91863b01f87 100644
--- a/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml
+++ b/plugins/org.eclipse.osee.framework.database/support/dbrelease.xml
@@ -1,88 +1,88 @@
-<project name="DBRelease" default="dbrelease" basedir="..">
-
- <property name="ECLIPSE_HOME" value="C:\Program Files\OSEE" />
- <property name="release" value="dbrelease/" />
- <property name="targetzip" value="${release}../oseeDatabase.zip" />
- <property name="manifestname" value="RELEASE.MF" />
- <property name="antdir" value="ant/" />
- <property name="derby" value="${ECLIPSE_HOME}\plugins\org.apache.derby.core_10.1.2.1" />
-
- <property name="eclipseruntimejar" value="org.eclipse.core.runtime_3.1.2.jar"/>
- <property name="eclipseJFacejar" value="org.eclipse.jface_3.1.1.jar" />
- <property name="eclipseRuntime" value="${ECLIPSE_HOME}\plugins\${eclipseruntimejar}" />
- <property name="eclipseJFace" value="${ECLIPSE_HOME}\plugins\${eclipseJFacejar}" />
-
- <property name="oseecore" value="osee.jdk.core/bin/" />
- <property name="oseedb" value="osee.database/bin/" />
- <property name="oseejini" value="osee.jini/bin/" />
- <property name="oseeats2" value="osee.ats2/bin/" />
- <property name="oseedefine" value="osee.define/bin/" />
-
- <target name="clean">
- <delete file="${manifestname}" />
- <delete dir="${release}" />
- </target>
-
- <target name="createrelease">
- <echo message="createrelease PATH=${PATH}" />
- <mkdir dir="${PATH}" />
- <manifest file="RELEASE.MF">
- <attribute name="Main-Class" value="osee/database/core/OseeDbLauncher" />
- <attribute name="Class-Path" value="oseecore.jar oseejini.jar oseedefine.jar oseeats2.jar derby.jar derbyclient.jar derbynet.jar derbytools.jar ${eclipseruntimejar} ${eclipseJFacejar}" />
- <section name="common">
- <attribute name="Specification-Title" value="Example" />
- <attribute name="Specification-Version" value="${version}" />
- <attribute name="Specification-Vendor" value="Example Organization" />
- <attribute name="Implementation-Title" value="common" />
- <attribute name="Implementation-Version" value="${version} ${TODAY}" />
- <attribute name="Implementation-Vendor" value="Example Corp." />
- </section>
- </manifest>
-
- <jar jarfile="${PATH}/oseedb.jar" basedir="../${oseedb}" manifest="RELEASE.MF" />
- <jar jarfile="${PATH}/oseecore.jar" basedir="../${oseecore}" />
- <jar jarfile="${PATH}/oseejini.jar" basedir="../${oseejini}" />
- <jar jarfile="${PATH}/oseeats2.jar" basedir="../${oseeats2}" />
- <jar jarfile="${PATH}/oseedefine.jar" basedir="../${oseedefine}" />
-
- <copy toDir="${PATH}/">
- <fileset file="${eclipseRuntime}"/>
- <fileset file="${eclipseJFace}" />
- </copy>
-
- <copy toDir="${PATH}/">
- <fileset dir="${derby}" includes="*.jar" />
- </copy>
-
- <copy toDir="${PATH}/DatabaseSchemaDump">
- <fileset dir="DatabaseSchemaDump"/>
- </copy>
-
- <copy toDir="${PATH}/excelFiles">
- <fileset dir="excelFiles"/>
- </copy>
-
- <copy toDir="${PATH}/support/">
- <fileset file="../${oseecore}/../support/oseeSiteConfig.xml" />
- </copy>
- <delete file="${manifestname}" />
- </target>
-
- <target name="dbrelease">
- <antcall target="createrelease">
- <param name="PATH" value="dbrelease/" />
- </antcall>
- </target>
-
- <target name="dbreleasezip">
- <antcall target="createrelease">
- <param name="PATH" value="temp/" />
- </antcall>
- <zip destfile="${targetzip}">
- <fileset dir="temp/" />
- </zip>
-
- <delete dir="temp/" />
- </target>
-
+<project name="DBRelease" default="dbrelease" basedir="..">
+
+ <property name="ECLIPSE_HOME" value="C:\Program Files\OSEE" />
+ <property name="release" value="dbrelease/" />
+ <property name="targetzip" value="${release}../oseeDatabase.zip" />
+ <property name="manifestname" value="RELEASE.MF" />
+ <property name="antdir" value="ant/" />
+ <property name="derby" value="${ECLIPSE_HOME}\plugins\org.apache.derby.core_10.1.2.1" />
+
+ <property name="eclipseruntimejar" value="org.eclipse.core.runtime_3.1.2.jar"/>
+ <property name="eclipseJFacejar" value="org.eclipse.jface_3.1.1.jar" />
+ <property name="eclipseRuntime" value="${ECLIPSE_HOME}\plugins\${eclipseruntimejar}" />
+ <property name="eclipseJFace" value="${ECLIPSE_HOME}\plugins\${eclipseJFacejar}" />
+
+ <property name="oseecore" value="osee.jdk.core/bin/" />
+ <property name="oseedb" value="osee.database/bin/" />
+ <property name="oseejini" value="osee.jini/bin/" />
+ <property name="oseeats2" value="osee.ats2/bin/" />
+ <property name="oseedefine" value="osee.define/bin/" />
+
+ <target name="clean">
+ <delete file="${manifestname}" />
+ <delete dir="${release}" />
+ </target>
+
+ <target name="createrelease">
+ <echo message="createrelease PATH=${PATH}" />
+ <mkdir dir="${PATH}" />
+ <manifest file="RELEASE.MF">
+ <attribute name="Main-Class" value="osee/database/core/OseeDbLauncher" />
+ <attribute name="Class-Path" value="oseecore.jar oseejini.jar oseedefine.jar oseeats2.jar derby.jar derbyclient.jar derbynet.jar derbytools.jar ${eclipseruntimejar} ${eclipseJFacejar}" />
+ <section name="common">
+ <attribute name="Specification-Title" value="Example" />
+ <attribute name="Specification-Version" value="${version}" />
+ <attribute name="Specification-Vendor" value="Example Organization" />
+ <attribute name="Implementation-Title" value="common" />
+ <attribute name="Implementation-Version" value="${version} ${TODAY}" />
+ <attribute name="Implementation-Vendor" value="Example Corp." />
+ </section>
+ </manifest>
+
+ <jar jarfile="${PATH}/oseedb.jar" basedir="../${oseedb}" manifest="RELEASE.MF" />
+ <jar jarfile="${PATH}/oseecore.jar" basedir="../${oseecore}" />
+ <jar jarfile="${PATH}/oseejini.jar" basedir="../${oseejini}" />
+ <jar jarfile="${PATH}/oseeats2.jar" basedir="../${oseeats2}" />
+ <jar jarfile="${PATH}/oseedefine.jar" basedir="../${oseedefine}" />
+
+ <copy toDir="${PATH}/">
+ <fileset file="${eclipseRuntime}"/>
+ <fileset file="${eclipseJFace}" />
+ </copy>
+
+ <copy toDir="${PATH}/">
+ <fileset dir="${derby}" includes="*.jar" />
+ </copy>
+
+ <copy toDir="${PATH}/DatabaseSchemaDump">
+ <fileset dir="DatabaseSchemaDump"/>
+ </copy>
+
+ <copy toDir="${PATH}/excelFiles">
+ <fileset dir="excelFiles"/>
+ </copy>
+
+ <copy toDir="${PATH}/support/">
+ <fileset file="../${oseecore}/../support/oseeSiteConfig.xml" />
+ </copy>
+ <delete file="${manifestname}" />
+ </target>
+
+ <target name="dbrelease">
+ <antcall target="createrelease">
+ <param name="PATH" value="dbrelease/" />
+ </antcall>
+ </target>
+
+ <target name="dbreleasezip">
+ <antcall target="createrelease">
+ <param name="PATH" value="temp/" />
+ </antcall>
+ <zip destfile="${targetzip}">
+ <fileset dir="temp/" />
+ </zip>
+
+ <delete dir="temp/" />
+ </target>
+
</project> \ No newline at end of file
diff --git a/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml b/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml
index 9363f690fc2..96fb53be7d0 100644
--- a/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml
+++ b/plugins/org.eclipse.osee.framework.database/support/sqlAnt.xml
@@ -1,84 +1,84 @@
-<project name="SQLAnt" default="query" basedir=".">
-
- <!-- LOCAL DERBY PROPERTIES -->
- <property name="driver" value="org.apache.derby.jdbc.ClientDriver"/>
- <property name="url" value="jdbc:derby://localhost:1621/DerbyDatabase;create=true"/>
- <property name="userid" value="osee"/>
- <property name="password" value="osee"/>
- <property name="driverpath" value="C:\Program Files\OSEE\plugins\org.apache.derby.core_10.1.2.1\derbyclient.jar" />
-
- <target name="query" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- select * from OSEE_DEFINE_ATTRIBUTE_TYPE
- </sql>
- </target>
-
- <target name="getAllOseeInfo" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- select * from OSEE_INFO
- </sql>
- </target>
-
- <target name="insertderbyTestScriptOutputFalse" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- insert into OSEE_INFO (OSEE_VALUE, OSEE_KEY) values ('FALSE', 'SAVE_OUTFILE_IN_DB')
- </sql>
- </target>
-
- <target name="saveTestScriptOutputTrue" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- UPDATE OSEE_INFO SET OSEE_VALUE = 'TRUE'
- WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
- </sql>
- </target>
-
- <target name="saveTestScriptOutputFalse" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- UPDATE OSEE_INFO SET OSEE_VALUE = 'FALSE'
- WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
- </sql>
- </target>
-
- <target name="testskynet" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT attr_type_id FROM OSEE_DEFINE_valid_attributes WHERE art_type_id = 20 AND gamma_id &lt;= 100000
- </sql>
- </target>
-
-
- <target name="testskynet2" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT OSEE_DEFINE_attr_base_type.attribute_class,
- OSEE_DEFINE_attribute_type.attr_type_id,
- OSEE_DEFINE_attribute_type.name,
- OSEE_DEFINE_attribute_type.default_value,
- OSEE_DEFINE_attribute_type.validity_xml,
- OSEE_DEFINE_attribute_type.min_occurence,
- OSEE_DEFINE_attribute_type.max_occurence,
- OSEE_DEFINE_attribute_type.user_viewable,
- OSEE_DEFINE_attribute_type.tip_text
- FROM OSEE_DEFINE_attribute_type, OSEE_DEFINE_attr_base_type,transaction_gamma_view
- WHERE OSEE_DEFINE_attr_base_type.attr_base_type_id=OSEE_DEFINE_attribute_type.attr_base_type_id
- AND transaction_gamma_view.transaction_id=179
- AND OSEE_DEFINE_attribute_type.gamma_id&lt;=transaction_gamma_view.largest_gamma_id
- </sql>
- </target>
-
-
- <target name="getseqtable" >
- <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
- <classpath><pathelement location="${driverpath}"/></classpath>
- SELECT * FROM OSEE_DEFINE_SEQUENCE
- </sql>
- </target>
-
-</project>
-
-
+<project name="SQLAnt" default="query" basedir=".">
+
+ <!-- LOCAL DERBY PROPERTIES -->
+ <property name="driver" value="org.apache.derby.jdbc.ClientDriver"/>
+ <property name="url" value="jdbc:derby://localhost:1621/DerbyDatabase;create=true"/>
+ <property name="userid" value="osee"/>
+ <property name="password" value="osee"/>
+ <property name="driverpath" value="C:\Program Files\OSEE\plugins\org.apache.derby.core_10.1.2.1\derbyclient.jar" />
+
+ <target name="query" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ select * from OSEE_DEFINE_ATTRIBUTE_TYPE
+ </sql>
+ </target>
+
+ <target name="getAllOseeInfo" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ select * from OSEE_INFO
+ </sql>
+ </target>
+
+ <target name="insertderbyTestScriptOutputFalse" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ insert into OSEE_INFO (OSEE_VALUE, OSEE_KEY) values ('FALSE', 'SAVE_OUTFILE_IN_DB')
+ </sql>
+ </target>
+
+ <target name="saveTestScriptOutputTrue" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ UPDATE OSEE_INFO SET OSEE_VALUE = 'TRUE'
+ WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
+ </sql>
+ </target>
+
+ <target name="saveTestScriptOutputFalse" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ UPDATE OSEE_INFO SET OSEE_VALUE = 'FALSE'
+ WHERE OSEE_KEY = 'SAVE_OUTFILE_IN_DB'
+ </sql>
+ </target>
+
+ <target name="testskynet" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ SELECT attr_type_id FROM OSEE_DEFINE_valid_attributes WHERE art_type_id = 20 AND gamma_id &lt;= 100000
+ </sql>
+ </target>
+
+
+ <target name="testskynet2" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ SELECT OSEE_DEFINE_attr_base_type.attribute_class,
+ OSEE_DEFINE_attribute_type.attr_type_id,
+ OSEE_DEFINE_attribute_type.name,
+ OSEE_DEFINE_attribute_type.default_value,
+ OSEE_DEFINE_attribute_type.validity_xml,
+ OSEE_DEFINE_attribute_type.min_occurence,
+ OSEE_DEFINE_attribute_type.max_occurence,
+ OSEE_DEFINE_attribute_type.user_viewable,
+ OSEE_DEFINE_attribute_type.tip_text
+ FROM OSEE_DEFINE_attribute_type, OSEE_DEFINE_attr_base_type,transaction_gamma_view
+ WHERE OSEE_DEFINE_attr_base_type.attr_base_type_id=OSEE_DEFINE_attribute_type.attr_base_type_id
+ AND transaction_gamma_view.transaction_id=179
+ AND OSEE_DEFINE_attribute_type.gamma_id&lt;=transaction_gamma_view.largest_gamma_id
+ </sql>
+ </target>
+
+
+ <target name="getseqtable" >
+ <sql driver="${driver}" url="${url}" userid="${userid}" password="${password}" print="true" >
+ <classpath><pathelement location="${driverpath}"/></classpath>
+ SELECT * FROM OSEE_DEFINE_SEQUENCE
+ </sql>
+ </target>
+
+</project>
+
+

Back to the top