[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-common/utils/xml2sql pgsql.xsl mssql.xsl m...
|
From: |
Jan Ischebeck |
|
Subject: |
gnue-common/utils/xml2sql pgsql.xsl mssql.xsl m... |
|
Date: |
Sat, 16 Aug 2003 20:18:27 -0400 |
CVSROOT: /cvsroot/gnue
Module name: gnue-common
Branch:
Changes by: Jan Ischebeck <address@hidden> 03/08/16 20:18:27
Modified files:
utils/xml2sql : pgsql.xsl mssql.xsl mysql.xsl interbase.xsl
sqlite.xsl sybase.xsl
Log message:
- updated xslt files to recognize new gsd "number"-type format
(possibly mssql and friends don't use the correct datatypes.
sorry, i have no manual, so I can't check.)
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/pgsql.xsl.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/mssql.xsl.diff?tr1=1.5&tr2=1.6&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/mysql.xsl.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/interbase.xsl.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/sqlite.xsl.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/sybase.xsl.diff?tr1=1.5&tr2=1.6&r1=text&r2=text
Patches:
Index: gnue-common/utils/xml2sql/interbase.xsl
diff -c gnue-common/utils/xml2sql/interbase.xsl:1.1
gnue-common/utils/xml2sql/interbase.xsl:1.2
*** gnue-common/utils/xml2sql/interbase.xsl:1.1 Sun Jul 28 06:42:41 2002
--- gnue-common/utils/xml2sql/interbase.xsl Sat Aug 16 20:18:27 2003
***************
*** 31,36 ****
--- 31,56 ----
<command>CREATE TABLE <xsl:value-of select="$tableName"/> (<xsl:for-each
select="fields/field">
<xsl:value-of select="@name"/>
<xsl:choose>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
+
<xsl:when test="@type = "smallint""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "integer""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "float""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
Index: gnue-common/utils/xml2sql/mssql.xsl
diff -c gnue-common/utils/xml2sql/mssql.xsl:1.5
gnue-common/utils/xml2sql/mssql.xsl:1.6
*** gnue-common/utils/xml2sql/mssql.xsl:1.5 Fri Jul 26 10:14:57 2002
--- gnue-common/utils/xml2sql/mssql.xsl Sat Aug 16 20:18:27 2003
***************
*** 17,22 ****
--- 17,41 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text> int
identity(1,1)</xsl:text></xsl:when>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
<xsl:when test="@type = "int"">
<xsl:choose>
<xsl:when test="@size = 2"><xsl:text>
smallint</xsl:text></xsl:when>
Index: gnue-common/utils/xml2sql/mysql.xsl
diff -c gnue-common/utils/xml2sql/mysql.xsl:1.6
gnue-common/utils/xml2sql/mysql.xsl:1.7
*** gnue-common/utils/xml2sql/mysql.xsl:1.6 Thu Apr 3 18:34:19 2003
--- gnue-common/utils/xml2sql/mysql.xsl Sat Aug 16 20:18:27 2003
***************
*** 17,22 ****
--- 17,41 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text> int(11)
auto_increment</xsl:text></xsl:when>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
<xsl:when test="@type = "int"">
<xsl:choose>
<xsl:when test="@length = 2"><xsl:text>
smallint</xsl:text></xsl:when>
Index: gnue-common/utils/xml2sql/pgsql.xsl
diff -c gnue-common/utils/xml2sql/pgsql.xsl:1.6
gnue-common/utils/xml2sql/pgsql.xsl:1.7
*** gnue-common/utils/xml2sql/pgsql.xsl:1.6 Thu Apr 3 18:34:19 2003
--- gnue-common/utils/xml2sql/pgsql.xsl Sat Aug 16 20:18:27 2003
***************
*** 22,27 ****
--- 22,46 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text>
</xsl:text>int4</xsl:when>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
<xsl:when test="@type = "int""><xsl:text>
</xsl:text><xsl:value-of select="@type"/><xsl:value-of
select="@length"/></xsl:when>
<xsl:when test="@type = "float""><xsl:text>
</xsl:text><xsl:value-of select="@type"/><xsl:value-of
select="@length"/></xsl:when>
<xsl:when test="@type = "decimal""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@precision"/>,<xsl:value-of select="@length"/>)</xsl:when>
Index: gnue-common/utils/xml2sql/sqlite.xsl
diff -c gnue-common/utils/xml2sql/sqlite.xsl:1.1
gnue-common/utils/xml2sql/sqlite.xsl:1.2
*** gnue-common/utils/xml2sql/sqlite.xsl:1.1 Tue Sep 24 09:44:01 2002
--- gnue-common/utils/xml2sql/sqlite.xsl Sat Aug 16 20:18:27 2003
***************
*** 20,25 ****
--- 20,45 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text>
</xsl:text>int4</xsl:when>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
+
<xsl:when test="@type = "int""><xsl:text>
</xsl:text><xsl:value-of select="@type"/><xsl:value-of
select="@size"/></xsl:when>
<xsl:when test="@type = "float""><xsl:text>
</xsl:text><xsl:value-of select="@type"/><xsl:value-of
select="@size"/></xsl:when>
<xsl:when test="@type = "decimal""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@precision"/>,<xsl:value-of select="@scale"/>)</xsl:when>
Index: gnue-common/utils/xml2sql/sybase.xsl
diff -c gnue-common/utils/xml2sql/sybase.xsl:1.5
gnue-common/utils/xml2sql/sybase.xsl:1.6
*** gnue-common/utils/xml2sql/sybase.xsl:1.5 Fri Jul 26 10:14:57 2002
--- gnue-common/utils/xml2sql/sybase.xsl Sat Aug 16 20:18:27 2003
***************
*** 17,22 ****
--- 17,41 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text> numeric(11,0)
identity</xsl:text></xsl:when>
+ <xsl:when test="@type = "number""><xsl:text> </xsl:text>
+ <xsl:choose>
+ <xsl:when test="@precision != "0"">
+ <xsl:text>decimal(</xsl:text><xsl:value-of
select="number(@length)+number(@precision)"/>
+ <xsl:text>,</xsl:text><xsl:value-of
select="@precision"/>
+ <xsl:text>)</xsl:text>
+ </xsl:when>
+ <xsl:otherwise>
+ <xsl:choose>
+ <xsl:when test="@length <=
4"><xsl:text>smallint</xsl:text></xsl:when>
+ <xsl:when test="@length <=
9"><xsl:text>integer</xsl:text></xsl:when>
+ <xsl:when test="@length <=
18"><xsl:text>bigint</xsl:text></xsl:when>
+
+ <xsl:otherwise><xsl:text>decimal(</xsl:text><xsl:value-of
select="@length"/>
+ <xsl:text>,0)</xsl:text></xsl:otherwise>
+ </xsl:choose>
+ </xsl:otherwise>
+ </xsl:choose>
+ </xsl:when>
<xsl:when test="@type = "int"">
<xsl:choose>
<xsl:when test="@size = 2"><xsl:text>
smallint</xsl:text></xsl:when>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue-common/utils/xml2sql pgsql.xsl mssql.xsl m...,
Jan Ischebeck <=