Mercurial > dive4elements > river
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 |
| 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>