Mercurial > dive4elements > river
annotate flys-backend/README @ 5158:a9658d43b621
added missing constraints in schema (mostly for Oracle)
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Mar 2013 13:28:45 +0100 |
parents | 790353fadf30 |
children | 95af0f3aabfb |
rev | line source |
---|---|
164
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 For the artifact database |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 # su - postgres |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 $ createuser --no-createrole --no-superuser --pwprompt --no-createdb artifacts |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 $ createdb --encoding=UTF-8 --owner artifacts artifactsdb |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 For the flys database |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
7 |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
8 # su - postgres |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
9 $ createuser --no-createrole --no-superuser --pwprompt --no-createdb flys |
324e12ab7a05
Converted schema to be PostgreSQL compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
10 $ createdb --encoding=UTF-8 --owner flys flystest1 |
4765
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
11 |
5054
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
12 |
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
13 Build an importer package: |
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
14 mvn -f pom.xml clean compile assembly:single |
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
15 Alternatively with oracle: |
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
16 mvn -f pom-oracle.xml clean compile assembly:single |
790353fadf30
Add minimal documenation how to build the single jar
Andre Heinecke <aheinecke@intevation.de>
parents:
4765
diff
changeset
|
17 |
4765
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
18 Standalone DateGuesser testing example: |
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
19 |
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
20 mvn -e -Dexec.mainClass=de.intevation.flys.utils.DateGuesser -Dexec.args="110803" exec:java <<EOF |
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
21 110803 |
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
22 EOF |
90142c839fe5
README: Add instruction to do a simple standalone DateGuesser execution.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
164
diff
changeset
|
23 |