changeset 2348:8477965674ce

Added a schema dump shell script. flys-backend/trunk@2889 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 05 Oct 2011 08:33:25 +0000 (2011-10-05)
parents 0acf28a3d28a
children 775e316f255b
files flys-backend/ChangeLog flys-backend/contrib/dump-schema.sh flys-backend/pom.xml
diffstat 3 files changed, 28 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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
--- /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
+
--- 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>

http://dive4elements.wald.intevation.org