Mercurial > dive4elements > river
annotate backend/README @ 6110:5ba28b563614
Fix datacage for user data by adding facet filtering.
Now the facets are joined in the user data select statement
and afterwards we just filter on the facet name where previously
new queryies were created.
Grouping also fixes the repeating folders caused by the change
in the statements during the large perfomance cleanup.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Mon, 27 May 2013 15:36:56 +0200 |
parents | 5aa05a7a34b7 |
children |
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 |
5331
95af0f3aabfb
AtFileParser, README: Added main-method for AT-File-Parsing debugging, doc.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5054
diff
changeset
|
24 Some importer allow standalone usage: |
95af0f3aabfb
AtFileParser, README: Added main-method for AT-File-Parsing debugging, doc.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5054
diff
changeset
|
25 mvn -e -Dexec.mainClass=de.intevation.flys.importer.parsers.AtFileParser -Dexec.args=/home/felix/.bashrc exec:java |