r5082 - trunk/gnue-common/utils/xml2sql

[johannes]

Author: johannes
Date: 2004-02-09 13:25:01 -0600 (Mon, 09 Feb 2004)
New Revision: 5082

Modified:
   trunk/gnue-common/utils/xml2sql/pgsql.xsl
   trunk/gnue-common/utils/xml2sql/pgsql_2.xsl
Log:
Changed template for insert-statements to provide a list of columns. This will
ensure correct SQL inserts.


Modified: trunk/gnue-common/utils/xml2sql/pgsql.xsl
===================================================================
--- trunk/gnue-common/utils/xml2sql/pgsql.xsl   2004-02-09 19:23:40 UTC (rev 
5081)
+++ trunk/gnue-common/utils/xml2sql/pgsql.xsl   2004-02-09 19:25:01 UTC (rev 
5082)
@@ -1,3 +1,4 @@
+<!-- $Id$ -->
 <?xml version="1.0"?>
 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0">
   <xsl:template match="/schema"><sql>
@@ -138,14 +139,24 @@
     <xsl:for-each select="rows/row">
       <command><xsl:text>Insert into </xsl:text>
         <xsl:value-of select="$tableName"/>
-        <xsl:text> values (</xsl:text>
+        <xsl:text> (</xsl:text>
         <xsl:variable name="numValues" select="count(value)"/>
+        <!-- list of columns -->
         <xsl:for-each select="value">
-           <xsl:value-of select="."/>
+           <xsl:value-of select="@field"/>
            <xsl:if test="position() &lt; $numValues">
               <xsl:text>, </xsl:text>
            </xsl:if>
         </xsl:for-each>
+        <!-- -->
+        <xsl:text>) values (</xsl:text>
+        <!-- values -->
+        <xsl:for-each select="value">
+          <xsl:value-of select="."/>
+           <xsl:if test="position() &lt; $numValues">
+              <xsl:text>, </xsl:text>
+           </xsl:if>
+        </xsl:for-each>
         <xsl:text>);</xsl:text>
       </command>
     </xsl:for-each>


Property changes on: trunk/gnue-common/utils/xml2sql/pgsql.xsl
___________________________________________________________________
Name: svn:keywords
   + Id

Modified: trunk/gnue-common/utils/xml2sql/pgsql_2.xsl
===================================================================
--- trunk/gnue-common/utils/xml2sql/pgsql_2.xsl 2004-02-09 19:23:40 UTC (rev 
5081)
+++ trunk/gnue-common/utils/xml2sql/pgsql_2.xsl 2004-02-09 19:25:01 UTC (rev 
5082)
@@ -1,3 +1,4 @@
+<!-- $Id$ -->
 <?xml version="1.0"?>
 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0">
   <xsl:template match="/schema"><sql>
@@ -111,14 +112,24 @@
     <xsl:for-each select="rows/row">
       <command><xsl:text>Insert into </xsl:text>
         <xsl:value-of select="$tableName"/>
-        <xsl:text> values (</xsl:text>
+        <xsl:text> (</xsl:text>
         <xsl:variable name="numValues" select="count(value)"/>
+        <!-- list of columns -->
         <xsl:for-each select="value">
-           <xsl:value-of select="."/>
+           <xsl:value-of select="@field"/>
            <xsl:if test="position() &lt; $numValues">
               <xsl:text>, </xsl:text>
            </xsl:if>
         </xsl:for-each>
+        <!-- -->
+        <xsl:text>) values (</xsl:text>
+        <!-- values -->
+        <xsl:for-each select="value">
+          <xsl:value-of select="."/>
+           <xsl:if test="position() &lt; $numValues">
+              <xsl:text>, </xsl:text>
+           </xsl:if>
+        </xsl:for-each>
         <xsl:text>);</xsl:text>
       </command>
     </xsl:for-each>


Property changes on: trunk/gnue-common/utils/xml2sql/pgsql_2.xsl
___________________________________________________________________
Name: svn:keywords
   + Id