# HG changeset patch # User Felix Wolfsteller # Date 1319805670 0 # Node ID d3a0d55dff63036b91006e3dbdb4b7d0a84269d5 # Parent 205eb6f124a5f581004169ba2cb8326b22f16510 Add static data conf to w-difference / datacage. flys-artifacts/trunk@3113 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 205eb6f124a5 -r d3a0d55dff63 flys-artifacts/ChangeLog --- a/flys-artifacts/ChangeLog Fri Oct 28 12:18:00 2011 +0000 +++ b/flys-artifacts/ChangeLog Fri Oct 28 12:41:10 2011 +0000 @@ -1,3 +1,12 @@ +2011-10-28 Felix Wolfsteller + + Added DC-conf, such that static data can be loaded from w-difference + diagrams datacage. + + * doc/conf/meta-data.xml: Minor "refactoring" (definition of two + macros, allow certain static data to be loaded via datacage to + w-difference diagrams, too. + 2011-10-28 Felix Wolfsteller Load and display annotations in w-differences, minor polishing. diff -r 205eb6f124a5 -r d3a0d55dff63 flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Fri Oct 28 12:18:00 2011 +0000 +++ b/flys-artifacts/doc/conf/meta-data.xml Fri Oct 28 12:41:10 2011 +0000 @@ -8,6 +8,75 @@ WHERE lower(name) LIKE lower(${river}) + + Base-data macros (mostly data imported from wst-files) + + + + + + + SELECT id AS prot_id, + description AS prot_description + FROM wsts WHERE kind = 0 AND river_id = ${river_id} + + + + + + + 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 + + + + + + + + + + + + + + + + + + + + SELECT id AS prot_id, + description AS prot_description + FROM wsts WHERE kind = 1 AND river_id = ${river_id} + + + + + + + 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 + + + + + + + + + + + + + + @@ -16,73 +85,13 @@ - + - + - - - - - SELECT id AS prot_id, - description AS prot_description - FROM wsts WHERE kind = 0 AND river_id = ${river_id} - - - - - - - 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 - - - - - - - - - - - - - - - - - - SELECT id AS prot_id, - description AS prot_description - FROM wsts WHERE kind = 1 AND river_id = ${river_id} - - - - - - - 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 - - - - - - - - - - - - - + +