Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle-drop.sql @ 5509:627584bc0586
Datacage: Added <dc:filter> element. This allows cleaner way to narrow the datasets.
Example:
<dc:context>
<dc:statement>
SELECT DISTINCT
name AS hws_name,
official AS hws_official,
kind_id AS hws_kind
FROM hws_lines
WHERE river_id = ${river_id}
</dc:statement>
<dc:if test="dc:has-result()">
<lines>
<dc:macro name="hws-lines">
<dc:elements>
<hws factory="hwsfactory" name="{$hws_name}"/>
</dc:elements>
</dc:macro>
<dc:filter expr="$hws_official=1">
<dc:if test="dc:has-result()">
<official>
<dc:filter expr="$hws_kind=1">
<dc:if test="dc:has-result()">
<Durchlass><dc:call-macro name="hws-lines"></Durchlass>
</dc:if>
</dc:filter>
<dc:filter expr="$hws_kind=2">
<dc:if test="dc:has-result()">
<Damm><dc:call-macro name="hws-lines"></Damm>
</dc:if>
</dc:filter>
<dc:filter expr="$hws_kind=3">
<dc:if test="dc:has-result()">
<Graben><dc:call-macro name="hws-lines"></Graben>
</dc:if>
</dc:filter>
</official>
</dc:if>
</dc:filter>
</lines>
</dc:if>
</dc:context>
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 28 Mar 2013 16:51:15 +0100 |
parents | dac7723fb502 |
children |
line wrap: on
line source
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsRanges; ALTER TABLE annotations DROP CONSTRAINT cAnnotationsEdges; ALTER TABLE annotations DROP CONSTRAINT cAnnotationsPositions; ALTER TABLE annotations DROP CONSTRAINT cAnnotationsAttributes; ALTER TABLE annotations DROP CONSTRAINT cAnnotationsTypes; ALTER TABLE cross_section_lines DROP CONSTRAINT cQPSLinesCrossSections; ALTER TABLE cross_section_points DROP CONSTRAINT cQPSPointsCrossSectionLines; ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsRivers; ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsTimeIntervals; ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesTime_intervals; ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesGauges; ALTER TABLE gauges DROP CONSTRAINT cGaugesRivers; ALTER TABLE gauges DROP CONSTRAINT cGaugesRanges; ALTER TABLE hyk_entries DROP CONSTRAINT cHykEntriesHyks; ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFormations; ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFlowZoneTypes; ALTER TABLE hyks DROP CONSTRAINT cHyksRivers; ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries; ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals; ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges; ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues; ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes; ALTER TABLE ranges DROP CONSTRAINT cRangesRivers; ALTER TABLE rivers DROP CONSTRAINT cRiversUnits; ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums; ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges; ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns; ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals; ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds; DROP TABLE annotation_types; DROP TABLE annotations; DROP TABLE attributes; DROP TABLE cross_section_lines; DROP TABLE cross_section_points; DROP TABLE cross_sections; DROP TABLE discharge_table_values; DROP TABLE discharge_tables; DROP TABLE edges; DROP TABLE gauges; DROP TABLE hyk_entries; DROP TABLE hyk_flow_zone_types; DROP TABLE hyk_flow_zones; DROP TABLE hyk_formations; DROP TABLE hyks; DROP TABLE main_value_types; DROP TABLE main_values; DROP TABLE named_main_values; DROP TABLE positions; DROP TABLE ranges; DROP TABLE rivers; DROP TABLE time_intervals; DROP TABLE units; DROP TABLE wst_column_q_ranges; DROP TABLE wst_column_values; DROP TABLE wst_columns; DROP TABLE wst_q_ranges; DROP TABLE wsts; DROP TABLE wst_kinds; DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; DROP SEQUENCE ANNOTATIONS_ID_SEQ; DROP SEQUENCE ATTRIBUTES_ID_SEQ; DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ; DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; DROP SEQUENCE CROSS_SECTIONS_ID_SEQ; DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ; DROP SEQUENCE EDGES_ID_SEQ; DROP SEQUENCE GAUGES_ID_SEQ; DROP SEQUENCE HYK_ENTRIES_ID_SEQ; DROP SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ; DROP SEQUENCE HYK_FLOW_ZONES_ID_SEQ; DROP SEQUENCE HYK_FORMATIONS_ID_SEQ; DROP SEQUENCE HYKS_ID_SEQ; DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; DROP SEQUENCE MAIN_VALUES_ID_SEQ; DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; DROP SEQUENCE POSITIONS_ID_SEQ; DROP SEQUENCE RANGES_ID_SEQ; DROP SEQUENCE RIVERS_ID_SEQ; DROP SEQUENCE TIME_INTERVALS_ID_SEQ; DROP SEQUENCE UNITS_ID_SEQ; DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ; DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ; DROP SEQUENCE WST_COLUMNS_ID_SEQ; DROP SEQUENCE WST_Q_RANGES_ID_SEQ; DROP SEQUENCE WSTS_ID_SEQ; DROP VIEW wst_value_table; DROP VIEW wst_w_values ; DROP VIEW wst_q_values; DROP VIEW official_lines; DROP VIEW q_main_values; DROP VIEW official_q_values; DROP VIEW wst_ranges;