[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-common/utils/xml2sql gadfly.xsl interbase....
From: |
Reinhard Mueller |
Subject: |
gnue-common/utils/xml2sql gadfly.xsl interbase.... |
Date: |
Thu, 16 Oct 2003 18:51:55 -0400 |
CVSROOT: /cvsroot/gnue
Module name: gnue-common
Branch:
Changes by: Reinhard Mueller <address@hidden> 03/10/16 18:51:55
Modified files:
utils/xml2sql : gadfly.xsl interbase.xsl mssql.xsl mysql.xsl
pgsql.xsl pgsql_2.xsl sqlite.xsl sybase.xsl
Log message:
Added "boolean" option for type. Depending on the database, this maps
to a
native boolean type or to an integer.
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/gadfly.xsl.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/interbase.xsl.diff?tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/mssql.xsl.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/mysql.xsl.diff?tr1=1.7&tr2=1.8&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/pgsql.xsl.diff?tr1=1.7&tr2=1.8&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/pgsql_2.xsl.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/sqlite.xsl.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/sybase.xsl.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
Patches:
Index: gnue-common/utils/xml2sql/gadfly.xsl
diff -c gnue-common/utils/xml2sql/gadfly.xsl:1.1
gnue-common/utils/xml2sql/gadfly.xsl:1.2
*** gnue-common/utils/xml2sql/gadfly.xsl:1.1 Tue Sep 24 09:44:01 2002
--- gnue-common/utils/xml2sql/gadfly.xsl Thu Oct 16 18:51:55 2003
***************
*** 37,42 ****
--- 37,43 ----
<xsl:when test="@type = "datetime""><xsl:text>
varchar</xsl:text>
</xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
varchar</xsl:text>
+ <xsl:when test="@type = "boolean""><xsl:text>
integer</xsl:text>
</xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
Index: gnue-common/utils/xml2sql/interbase.xsl
diff -c gnue-common/utils/xml2sql/interbase.xsl:1.3
gnue-common/utils/xml2sql/interbase.xsl:1.4
*** gnue-common/utils/xml2sql/interbase.xsl:1.3 Sat Sep 20 08:00:24 2003
--- gnue-common/utils/xml2sql/interbase.xsl Thu Oct 16 18:51:55 2003
***************
*** 15,26 ****
</xsl:for-each></sql>
</xsl:template>
- <xsl:template name="doBooleanDomain">
- <xsl:if
test="count(./tables/table/fields/address@hidden"boolean"]) > 0">
- <command>CREATE DOMAIN boolean CHAR DEFAULT 'N' CHECK (VALUE IN
('N','Y')) NOT NULL;</command>
- </xsl:if>
- </xsl:template>
-
<xsl:template name="doGenerator">
<xsl:if test="count(./fields/address@hidden"auto"]) > 0">
<command>CREATE GENERATOR gen_<xsl:value-of select="@name"/>;</command>
--- 15,20 ----
***************
*** 62,68 ****
<xsl:when test="@type = "string""><xsl:text>
</xsl:text>varchar(<xsl:value-of select="@length"/>)</xsl:when>
<xsl:when test="@type = "blob""><xsl:text>
</xsl:text></xsl:when>
<xsl:when test="@type = "date""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
! <xsl:when test="@type = "boolean""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
date</xsl:text></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
date</xsl:text></xsl:when>
<xsl:when test="@type = "int""><xsl:text>
integer</xsl:text></xsl:when>
--- 56,62 ----
<xsl:when test="@type = "string""><xsl:text>
</xsl:text>varchar(<xsl:value-of select="@length"/>)</xsl:when>
<xsl:when test="@type = "blob""><xsl:text>
</xsl:text></xsl:when>
<xsl:when test="@type = "date""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
! <xsl:when test="@type = "boolean""><xsl:text>
smallint</xsl:text></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
date</xsl:text></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
date</xsl:text></xsl:when>
<xsl:when test="@type = "int""><xsl:text>
integer</xsl:text></xsl:when>
Index: gnue-common/utils/xml2sql/mssql.xsl
diff -c gnue-common/utils/xml2sql/mssql.xsl:1.6
gnue-common/utils/xml2sql/mssql.xsl:1.7
*** gnue-common/utils/xml2sql/mssql.xsl:1.6 Sat Aug 16 20:18:27 2003
--- gnue-common/utils/xml2sql/mssql.xsl Thu Oct 16 18:51:55 2003
***************
*** 58,63 ****
--- 58,64 ----
<xsl:when test="@type = "longtext""><xsl:text>
text</xsl:text></xsl:when>
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
timestamp</xsl:text></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
boolean</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
Index: gnue-common/utils/xml2sql/mysql.xsl
diff -c gnue-common/utils/xml2sql/mysql.xsl:1.7
gnue-common/utils/xml2sql/mysql.xsl:1.8
*** gnue-common/utils/xml2sql/mysql.xsl:1.7 Sat Aug 16 20:18:27 2003
--- gnue-common/utils/xml2sql/mysql.xsl Thu Oct 16 18:51:55 2003
***************
*** 74,79 ****
--- 74,80 ----
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
timestamp</xsl:text></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
tinyint</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
Index: gnue-common/utils/xml2sql/pgsql.xsl
diff -c gnue-common/utils/xml2sql/pgsql.xsl:1.7
gnue-common/utils/xml2sql/pgsql.xsl:1.8
*** gnue-common/utils/xml2sql/pgsql.xsl:1.7 Sat Aug 16 20:18:27 2003
--- gnue-common/utils/xml2sql/pgsql.xsl Thu Oct 16 18:51:55 2003
***************
*** 52,57 ****
--- 52,58 ----
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
boolean</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> </xsl:text>UNHANDLED TYPE(<xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
Index: gnue-common/utils/xml2sql/pgsql_2.xsl
diff -c gnue-common/utils/xml2sql/pgsql_2.xsl:1.2
gnue-common/utils/xml2sql/pgsql_2.xsl:1.3
*** gnue-common/utils/xml2sql/pgsql_2.xsl:1.2 Tue Jul 30 13:00:17 2002
--- gnue-common/utils/xml2sql/pgsql_2.xsl Thu Oct 16 18:51:55 2003
***************
*** 31,36 ****
--- 31,37 ----
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
boolean</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> </xsl:text>UNHANDLED TYPE(<xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
Index: gnue-common/utils/xml2sql/sqlite.xsl
diff -c gnue-common/utils/xml2sql/sqlite.xsl:1.2
gnue-common/utils/xml2sql/sqlite.xsl:1.3
*** gnue-common/utils/xml2sql/sqlite.xsl:1.2 Sat Aug 16 20:18:27 2003
--- gnue-common/utils/xml2sql/sqlite.xsl Thu Oct 16 18:51:55 2003
***************
*** 51,56 ****
--- 51,57 ----
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "datetime""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
boolean</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> </xsl:text>UNHANDLED TYPE(<xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
Index: gnue-common/utils/xml2sql/sybase.xsl
diff -c gnue-common/utils/xml2sql/sybase.xsl:1.6
gnue-common/utils/xml2sql/sybase.xsl:1.7
*** gnue-common/utils/xml2sql/sybase.xsl:1.6 Sat Aug 16 20:18:27 2003
--- gnue-common/utils/xml2sql/sybase.xsl Thu Oct 16 18:51:55 2003
***************
*** 58,63 ****
--- 58,64 ----
<xsl:when test="@type = "longtext""><xsl:text>
text</xsl:text></xsl:when>
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
<xsl:when test="@type = "timestamp""><xsl:text>
timestamp</xsl:text></xsl:when>
+ <xsl:when test="@type = "boolean""><xsl:text>
smallint</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
<xsl:choose>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue-common/utils/xml2sql gadfly.xsl interbase....,
Reinhard Mueller <=