# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1318947950 0
# Node ID 6068b6c90a19ed87aada3a70d6b3a6e38e3cc97a
# Parent  cee5a292754f7c551e290b5207d36e02d815ddac
Adjusted datacage-configuration to present flood-protections in certain case.


flys-artifacts/trunk@3012 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r cee5a292754f -r 6068b6c90a19 flys-artifacts/ChangeLog
--- a/flys-artifacts/ChangeLog	Tue Oct 18 14:20:37 2011 +0000
+++ b/flys-artifacts/ChangeLog	Tue Oct 18 14:25:50 2011 +0000
@@ -1,3 +1,11 @@
+2011-10-18  Felix Wolfsteller	<felix.wolfsteller@intevation.de>
+
+	Adjusted Datacage-Configuration to fetch flood-protections when
+	waterlevels are requested (in system-part).
+
+	* doc/conf/meta-data.xml: Adjusted to present flood-protections with
+	  staticwkms factory in certain case.
+
 2011-10-18  Felix Wolfsteller	<felix.wolfsteller@intevation.de>
 
 	Register staticwkms factory.
diff -r cee5a292754f -r 6068b6c90a19 flys-artifacts/doc/conf/meta-data.xml
--- a/flys-artifacts/doc/conf/meta-data.xml	Tue Oct 18 14:20:37 2011 +0000
+++ b/flys-artifacts/doc/conf/meta-data.xml	Tue Oct 18 14:25:50 2011 +0000
@@ -11,6 +11,44 @@
         <river>
           <dc:attribute name="name" value="${river_name}"/>
           <dc:attribute name="db-id" value="${river_id}"/>
+          <dc:if test="dc:contains($artifact-outs, 'waterlevels')">
+            <flood-protections>
+              <dc:attribute name="id" value="flood-protections-${river_id}"/>
+              <dc:context>
+                <dc:statement>
+                  SELECT id          AS prot_id,
+                         description AS prot_description
+                  FROM wsts WHERE kind = 5 AND river_id = ${river_id}
+                </dc:statement>
+                <dc:elements>
+                  <flood-protection>
+                    <dc:attribute name="name" value="${prot_description}"/>
+                    <dc:attribute name="db-id" value="${prot_id}"/>
+                    <dc:attribute name="factory" value="staticwkms"/>
+                    <columns>
+                      <dc:context>
+                        <dc:statement>
+                          SELECT id       AS prot_column_id,
+                                 name     AS prot_column_name,
+                                 position AS prot_rel_pos
+                          FROM wst_columns WHERE wst_id = ${prot_id}
+                          ORDER by position
+                        </dc:statement>
+                        <dc:elements>
+                          <column>
+                            <dc:attribute name="name" value="${prot_column_name}"/>
+                            <dc:attribute name="id" value="flood_protection-wstv-${prot_rel_pos}-${prot_id}"/>
+                            <dc:attribute name="db-id" value="flood_protection-wstv-${prot_rel_pos}-${prot_id}"/>
+                            <dc:attribute name="factory" value="staticwkms"/>
+                          </column>
+                        </dc:elements>
+                      </dc:context>
+                    </columns>
+                  </flood-protection>
+                </dc:elements>
+              </dc:context>
+            </flood-protections>
+          </dc:if>
           <dc:if test="dc:contains($artifact-outs, 'computed_discharge_curve')">
               <discharge-table-nn>
                 <discharge-table-gauge>
@@ -69,7 +107,8 @@
                             <dc:elements>
                               <column>
                                 <dc:attribute name="name" value="${fix_column_name}"/>
-                                <dc:attribute name="db-id" value="${fix_column_id}"/></column>
+                                <dc:attribute name="db-id" value="${fix_column_id}"/>
+                              </column>
                             </dc:elements>
                           </dc:context>
                         </columns>
@@ -100,7 +139,9 @@
                             <dc:elements>
                               <column>
                                 <dc:attribute name="name" value="${prot_column_name}"/>
-                                <dc:attribute name="db-id" value="${prot_column_id}"/></column>
+                                <dc:attribute name="db-id" value="${prot_column_id}"/>
+                                <dc:attribute name="factory" value="staticwkms"/>
+                              </column>
                             </dc:elements>
                           </dc:context>
                         </columns>