Mercurial > dive4elements > river
annotate backend/README @ 6087:47775e3a8cf6
Datacage: Introduced <dc:virtual-column name="colname" type="type" expr="XPath">
dc:virtual-column can be used to virtual add or replace a column named 'colname' to
the current result set. The value is determined by evaluating "XPath", the type is
determined by "type" (possible values: number, bool, node, nodeset, string. defaults to string).
Usage:
<dc:virtual-column name="c" type="number" expr="$a+$b">
<dc:for-each>
<dc:message>{$a} + {$b} = {$c}</dc:message>
</dc:for-each>
</dc:virtual-column>
table
a | b
--+--
1 | 2
3 | 4
will result in:
1 + 2 = 3
3 + 4 = 7
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Fri, 24 May 2013 12:19:25 +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 |