diff options
| author | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
|---|---|---|
| committer | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
| commit | 1dfdccb8118aeaa3cd844ac8de2a672c93312166 (patch) | |
| tree | 4b19e7f816ab1019f180a46b68572af4b66fe4bc /slips/build/project.database.build | |
| parent | 42d66bcab8262c7b8b2452615df535e694a3ec1c (diff) | |
git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219
Diffstat (limited to 'slips/build/project.database.build')
| -rw-r--r-- | slips/build/project.database.build | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/slips/build/project.database.build b/slips/build/project.database.build new file mode 100644 index 0000000..9c48dba --- /dev/null +++ b/slips/build/project.database.build @@ -0,0 +1,53 @@ +<project name="">
+ <property name="build.sql.dir" value="${build.dir}\sql" />
+ <property name="build.sql.data.dir" value="${build.sql.dir}\data" />
+ <property name="build.sql.ddl.dir" value="${build.sql.dir}\ddl" />
+
+ <fileset id="sql.ddl.files">
+ <include name="${build.sql.ddl.dir}\database.sql" asis="true" />
+ <include name="${build.sql.ddl.dir}\tables.sql" asis="true" />
+ <include name="${build.sql.ddl.dir}\security.sql" asis="true" />
+ </fileset>
+
+ <fileset id="sql.data.files">
+ <include name="${build.sql.data.dir}\location.sql" asis="true" />
+ <include name="${build.sql.data.dir}\dock.sql" asis="true" />
+ <include name="${build.sql.data.dir}\slip.sql" asis="true" />
+ <include name="${build.sql.data.dir}\leasetype.sql" asis="true" />
+ <include name="${build.sql.data.dir}\customer.sql" asis="true" />
+ <include name="${build.sql.data.dir}\boat.sql" asis="true" />
+ <include name="${build.sql.data.dir}\authorize.sql" asis="true" />
+ <include name="${build.sql.data.dir}\lease.sql" asis="true" />
+ </fileset>
+
+ <target name="run.sql.file">
+ <echo message="Executing... ${target}" />
+ <exec program="${sqlcmd.exe}"
+ workingdir="${base.dir}"
+ commandline="${sqlcmd.connectionstring} -b -i ${target}" />
+ </target>
+
+ <target name="run.sql.template" depends="expand.template.file, run.sql.file"/>
+
+ <target name="build.db">
+ <foreach item="File" property="target">
+ <in>
+ <items refid="sql.ddl.files"/>
+ </in>
+ <do>
+ <call target="run.sql.template"/>
+ </do>
+ </foreach>
+ </target>
+
+ <target name="load.data" depends="build.db">
+ <foreach item="File" property="target">
+ <in>
+ <items refid="sql.data.files"/>
+ </in>
+ <do>
+ <call target="run.sql.template"/>
+ </do>
+ </foreach>
+ </target>
+</project>
\ No newline at end of file |