gnue/common/utils/xml2sql pgsql_2.xsl

[Jan Ischebeck]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Jan Ischebeck <address@hidden>  02/07/30 13:00:17

Modified files:
        common/utils/xml2sql: pgsql_2.xsl 

Log message:
        moved Constrain definitions into table definitions (ariel)

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/pgsql_2.xsl.diff?tr1=1.1&tr2=1.2&r1=text&r2=text

Patches:
Index: gnue/common/utils/xml2sql/pgsql_2.xsl
diff -c gnue/common/utils/xml2sql/pgsql_2.xsl:1.1 
gnue/common/utils/xml2sql/pgsql_2.xsl:1.2
*** gnue/common/utils/xml2sql/pgsql_2.xsl:1.1   Wed Jul 24 19:25:25 2002
--- gnue/common/utils/xml2sql/pgsql_2.xsl       Tue Jul 30 13:00:17 2002
***************
*** 5,11 ****
        <xsl:call-template name="doSequence"/>
        <xsl:call-template name="doTable"/>
        <xsl:call-template name="doIndexes"><xsl:with-param 
name="table"><xsl:value-of select="@name"/></xsl:with-param></xsl:call-template>
-       <xsl:call-template name="doConstraints"><xsl:with-param 
name="table"><xsl:value-of select="@name"/></xsl:with-param></xsl:call-template>
      </xsl:for-each>
      <xsl:for-each select="data/tabledata">
        <xsl:call-template name="doTableData"/>
--- 5,10 ----
***************
*** 52,57 ****
--- 51,57 ----
          <xsl:text>, </xsl:text>
        </xsl:if>
      </xsl:for-each><xsl:call-template name="doPrimaryKey"><xsl:with-param 
name="table"><xsl:value-of select="@name"/></xsl:with-param></xsl:call-template>
+ <xsl:call-template name="doConstraints"></xsl:call-template>
    );</command>
    </xsl:template>
  
***************
*** 82,114 ****
    </xsl:template>
  
    <xsl:template name="doConstraints">
!     <xsl:param name="table"></xsl:param>
!     <xsl:if test="$table != &quot;&quot;">
!       <xsl:for-each select="constraints/constraint">
!         <command>
          <xsl:choose>
          <xsl:when test="@type = &quot;unique&quot;">
!           <xsl:text>Create Unique Index </xsl:text>
!           <xsl:value-of select="@name"/><xsl:text> On </xsl:text>
!           <xsl:value-of select="$table"/><xsl:text>(</xsl:text>
            <xsl:for-each select="constraintfield">
              <xsl:if test="position() &gt; 1"><xsl:text>, </xsl:text></xsl:if>
              <xsl:value-of select="@name"/>
            </xsl:for-each>
!           <xsl:text>);</xsl:text>
          </xsl:when>
          <xsl:when test="@type = &quot;foreignkey&quot;">
-           <xsl:text>Alter Table </xsl:text><xsl:value-of 
select="$table"/><xsl:text> Add Constraint </xsl:text>
            <xsl:value-of select="@name"/><xsl:text> foreign key (</xsl:text>
            <xsl:value-of select="constraintfield/@name"/><xsl:text>) 
references </xsl:text>
            <xsl:value-of 
select="constraintref/@table"/><xsl:text>(</xsl:text><xsl:value-of 
select="constraintref/@name"/>
!           <xsl:text>);</xsl:text>
          </xsl:when>
          </xsl:choose>
-         </command>
        </xsl:for-each>
!     </xsl:if>
!   </xsl:template>
  
    <xsl:template name="doTableData">
      <xsl:variable name="tableName" select="@tablename"/>
--- 82,109 ----
    </xsl:template>
  
    <xsl:template name="doConstraints">
!     <xsl:for-each select="constraints/constraint">
!         <xsl:text>, Constraint </xsl:text>
          <xsl:choose>
          <xsl:when test="@type = &quot;unique&quot;">
!           <xsl:value-of select="@name"/>
!           <xsl:text> Unique </xsl:text>
!         <xsl:text>( </xsl:text>       
            <xsl:for-each select="constraintfield">
              <xsl:if test="position() &gt; 1"><xsl:text>, </xsl:text></xsl:if>
              <xsl:value-of select="@name"/>
            </xsl:for-each>
!           <xsl:text>)</xsl:text>
          </xsl:when>
          <xsl:when test="@type = &quot;foreignkey&quot;">
            <xsl:value-of select="@name"/><xsl:text> foreign key (</xsl:text>
            <xsl:value-of select="constraintfield/@name"/><xsl:text>) 
references </xsl:text>
            <xsl:value-of 
select="constraintref/@table"/><xsl:text>(</xsl:text><xsl:value-of 
select="constraintref/@name"/>
!           <xsl:text>)</xsl:text>
          </xsl:when>
          </xsl:choose>
        </xsl:for-each>
!     </xsl:template>
  
    <xsl:template name="doTableData">
      <xsl:variable name="tableName" select="@tablename"/>