[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue/common/utils/xml2sql Schema.txt mssql.xsl ...
From: |
Jan Ischebeck |
Subject: |
gnue/common/utils/xml2sql Schema.txt mssql.xsl ... |
Date: |
Fri, 26 Jul 2002 10:14:57 -0400 |
CVSROOT: /cvsroot/gnue
Module name: gnue
Changes by: Jan Ischebeck <address@hidden> 02/07/26 10:14:57
Modified files:
common/utils/xml2sql: Schema.txt mssql.xsl mysql.xsl sybase.xsl
Added files:
common/utils/xml2sql: example.gsd
Log message:
modified xsl files to work with modified index/primary/foreign key
syntax
add an example gsd file, corrected bug in schema.txt
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/example.gsd?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/Schema.txt.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/mssql.xsl.diff?tr1=1.4&tr2=1.5&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/mysql.xsl.diff?tr1=1.4&tr2=1.5&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/sybase.xsl.diff?tr1=1.4&tr2=1.5&r1=text&r2=text
Patches:
Index: gnue/common/utils/xml2sql/Schema.txt
diff -c gnue/common/utils/xml2sql/Schema.txt:1.1
gnue/common/utils/xml2sql/Schema.txt:1.2
*** gnue/common/utils/xml2sql/Schema.txt:1.1 Wed Jul 24 10:11:30 2002
--- gnue/common/utils/xml2sql/Schema.txt Fri Jul 26 10:14:57 2002
***************
*** 59,88 ****
<fields>
<!-- Your field declarations here -->
</fields>
! <data>
! <tabledata>
! <rows>
! <row>
! <value>1</value>
! <value>Freud</value>
! <value>Sigmund</value>
! <value>Austria</value>
! </row>
! <row>
! <value>2</value>
! <value>Sullivan</value>
! <value>Peter</value>
! <value>USA</value>
! </row>
! <!-- More rows -->
! </rows>
! </tabledata>
! </data>
! </table>
! </tables>
</schema>
Within a table element, simply specify a data/tabledata element. Within a rows
element, you specify multiple rows with multiple values. xml2sql can not yet
handle filling only specified fields; you have to pass all of them.
--- 59,91 ----
<fields>
<!-- Your field declarations here -->
</fields>
! </table>
! </tables>
! <data>
! <tabledata name="some data" tablename="worlds_best_psychotherapists">
! <rows>
! <row>
! <value>1</value>
! <value>Freud</value>
! <value>Sigmund</value>
! <value>Austria</value>
! </row>
! <row>
! <value>2</value>
! <value>Sullivan</value>
! <value>Peter</value>
! <value>USA</value>
! </row>
! <!-- More rows -->
! </rows>
! </tabledata>
! </data>
</schema>
Within a table element, simply specify a data/tabledata element. Within a rows
element, you specify multiple rows with multiple values. xml2sql can not yet
handle filling only specified fields; you have to pass all of them.
+
+
+
Index: gnue/common/utils/xml2sql/mssql.xsl
diff -c gnue/common/utils/xml2sql/mssql.xsl:1.4
gnue/common/utils/xml2sql/mssql.xsl:1.5
*** gnue/common/utils/xml2sql/mssql.xsl:1.4 Tue Jul 23 16:56:37 2002
--- gnue/common/utils/xml2sql/mssql.xsl Fri Jul 26 10:14:57 2002
***************
*** 84,90 ****
<xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
<xsl:text>)
GO
--- 84,90 ----
<xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="@name"/>
</xsl:for-each>
<xsl:text>)
GO
***************
*** 104,117 ****
<xsl:value-of select="@name"/><xsl:text> Unique (</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
</xsl:when>
<xsl:when test="@type = "foreignkey"">
<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="ref/@sourceField"/><xsl:text>) references
</xsl:text>
! <xsl:value-of
select="ref/@destinationTable"/><xsl:text>(</xsl:text><xsl:value-of
select="ref/@destinationField"/>
</xsl:when>
</xsl:choose>
<xsl:text>)
--- 104,117 ----
<xsl:value-of select="@name"/><xsl:text> Unique (</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="@name"/>
</xsl:for-each>
</xsl:when>
<xsl:when test="@type = "foreignkey"">
<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="constrainfield/@name"/><xsl:text>) references
</xsl:text>
! <xsl:value-of
select="constraintref/@table"/><xsl:text>(</xsl:text><xsl:value-of
select="constraintref/@name"/>
</xsl:when>
</xsl:choose>
<xsl:text>)
Index: gnue/common/utils/xml2sql/mysql.xsl
diff -c gnue/common/utils/xml2sql/mysql.xsl:1.4
gnue/common/utils/xml2sql/mysql.xsl:1.5
*** gnue/common/utils/xml2sql/mysql.xsl:1.4 Tue Jul 23 16:56:37 2002
--- gnue/common/utils/xml2sql/mysql.xsl Fri Jul 26 10:14:57 2002
***************
*** 90,96 ****
<xsl:value-of select="@name"/><xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
<xsl:text>);</xsl:text></command>
</xsl:for-each>
--- 90,96 ----
<xsl:value-of select="@name"/><xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="@name"/>
</xsl:for-each>
<xsl:text>);</xsl:text></command>
</xsl:for-each>
***************
*** 108,122 ****
<xsl:value-of select="@name"/><xsl:text>(</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
<xsl:text>);</xsl:text>
</xsl:when>
<xsl:when test="@type = "foreignkey"">
<!--<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="ref/@sourceField"/><xsl:text>) references
</xsl:text>
! <xsl:value-of
select="ref/@destinationTable"/><xsl:text>(</xsl:text><xsl:value-of
select="ref/@destinationField"/>
<xsl:text>);</xsl:text>-->
</xsl:when>
</xsl:choose>
--- 108,122 ----
<xsl:value-of select="@name"/><xsl:text>(</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 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 = "foreignkey"">
<!--<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>
Index: gnue/common/utils/xml2sql/sybase.xsl
diff -c gnue/common/utils/xml2sql/sybase.xsl:1.4
gnue/common/utils/xml2sql/sybase.xsl:1.5
*** gnue/common/utils/xml2sql/sybase.xsl:1.4 Tue Jul 23 16:56:37 2002
--- gnue/common/utils/xml2sql/sybase.xsl Fri Jul 26 10:14:57 2002
***************
*** 84,90 ****
<xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
<xsl:text>)
GO
--- 84,90 ----
<xsl:text>(</xsl:text>
<xsl:for-each select="idxfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="@name"/>
</xsl:for-each>
<xsl:text>)
GO
***************
*** 104,117 ****
<xsl:value-of select="@name"/><xsl:text> Unique (</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="."/>
</xsl:for-each>
</xsl:when>
<xsl:when test="@type = "foreignkey"">
<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="ref/@sourceField"/><xsl:text>) references
</xsl:text>
! <xsl:value-of
select="ref/@destinationTable"/><xsl:text>(</xsl:text><xsl:value-of
select="ref/@destinationField"/>
</xsl:when>
</xsl:choose>
<xsl:text>)
--- 104,117 ----
<xsl:value-of select="@name"/><xsl:text> Unique (</xsl:text>
<xsl:for-each select="constraintfield">
<xsl:if test="position() > 1"><xsl:text>, </xsl:text></xsl:if>
! <xsl:value-of select="@name"/>
</xsl:for-each>
</xsl:when>
<xsl:when test="@type = "foreignkey"">
<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:when>
</xsl:choose>
<xsl:text>)
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue/common/utils/xml2sql Schema.txt mssql.xsl ...,
Jan Ischebeck <=