Mercurial > dive4elements > river
view etl/doc/repair.xsl @ 9713:aef987124822 3.2.x
Do not rely on database default for setting hws_lines.official to 0
It's not under the control of the importer whether the field is rendered
into an INSERT statement, whether it's actually set or not. If it is
unset but rendered into the statement, the field would be set to NULL.
Thus, always set it explicitly.
While here, remove an unused import.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 12 Mar 2021 15:11:44 +0100 |
parents | 5aa05a7a34b7 |
children |
line wrap: on
line source
<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml"/> <xsl:key name="gauge-name" match="/STATIONEN/STATION" use="@NAME"/> <xsl:template name="lookup-gauge-number"> <xsl:param name="name"/> <xsl:param name="number"/> <xsl:variable name="fixed-number"> <xsl:for-each select="document('pegelstationen.xml')"> <xsl:value-of select="key('gauge-name', $name)/@NUMMER"/> </xsl:for-each> </xsl:variable> <xsl:choose> <xsl:when test="$fixed-number != ''"> <xsl:value-of select="$fixed-number"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$number"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="/DIPSFLYS/STATIONEN/PEGELSTATION"> <PEGELSTATION> <xsl:attribute name="NUMMER"> <xsl:call-template name="lookup-gauge-number"> <xsl:with-param name="name" select="@NAME"/> <xsl:with-param name="number" select="@NUMMER"/> </xsl:call-template> </xsl:attribute> <xsl:apply-templates select="@*[local-name() != 'NUMMER']"/> <xsl:apply-templates select="node()"/> </PEGELSTATION> </xsl:template> <xsl:template match="@*|node()"> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:template> </xsl:stylesheet>