# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1317803605 0
# Node ID 8477965674cee1266232a81cc126ecaaeaf7c0fa
# Parent  0acf28a3d28aaaf66135341e0c01be71394bf992
Added a schema dump shell script.

flys-backend/trunk@2889 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 0acf28a3d28a -r 8477965674ce flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Tue Oct 04 15:28:19 2011 +0000
+++ b/flys-backend/ChangeLog	Wed Oct 05 08:33:25 2011 +0000
@@ -1,3 +1,10 @@
+2011-10-05  Ingo Weinzierl <ingo@intevation.de>
+
+	* contrib/dump-schema.sh: New. A small shell script that dumps the
+	  database schema of a given database to SQL.
+
+	* pom.xml: Added dependency for hibernate-spatial-oracle stuff.
+
 2011-10-04  Ingo Weinzierl <ingo@intevation.de>
 
 	* doc/schema/postgresql.sql: Removed unit column from wsts; added a
diff -r 0acf28a3d28a -r 8477965674ce flys-backend/contrib/dump-schema.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/contrib/dump-schema.sh	Wed Oct 05 08:33:25 2011 +0000
@@ -0,0 +1,16 @@
+#!/bin/bash
+
+DB_URL=jdbc:postgresql://czech-republic.atlas.intevation.de:5432/flys3
+DB_USER=flys
+DB_PASS=flys
+DB_DIALECT=org.hibernatespatial.oracle.OracleSpatial10gDialect
+
+mvn compile package -e \
+    -Dlog4j.configuration=file://`readlink -f contrib/log4j.properties` \
+    -Dflys.backend.user=$DB_USER \
+    -Dflys.backend.password=$DB_PASS \
+    -Dflys.backend.dialect=$DB_DIALECT \
+    -Dflys.backend.url=$DB_URL \
+    -Dexec.mainClass=de.intevation.flys.App \
+    exec:java
+
diff -r 0acf28a3d28a -r 8477965674ce flys-backend/pom.xml
--- a/flys-backend/pom.xml	Tue Oct 04 15:28:19 2011 +0000
+++ b/flys-backend/pom.xml	Wed Oct 05 08:33:25 2011 +0000
@@ -84,6 +84,11 @@
         <version>1.1</version>
     </dependency>
     <dependency>
+        <groupId>org.hibernatespatial</groupId>
+        <artifactId>hibernate-spatial-oracle</artifactId>
+        <version>1.1</version>
+    </dependency>
+    <dependency>
         <groupId>org.postgis</groupId>
         <artifactId>postgis-jdbc</artifactId>
         <version>1.3.3</version>