[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-common/utils/xml2sql pgsql.xsl
From: |
Reinhard Mueller |
Subject: |
gnue-common/utils/xml2sql pgsql.xsl |
Date: |
Sun, 19 Oct 2003 06:10:18 -0400 |
CVSROOT: /cvsroot/gnue
Module name: gnue-common
Branch:
Changes by: Reinhard Mueller <address@hidden> 03/10/19 06:10:17
Modified files:
utils/xml2sql : pgsql.xsl
Log message:
Fix for date and time types on postgres.
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/utils/xml2sql/pgsql.xsl.diff?tr1=1.8&tr2=1.9&r1=text&r2=text
Patches:
Index: gnue-common/utils/xml2sql/pgsql.xsl
diff -c gnue-common/utils/xml2sql/pgsql.xsl:1.8
gnue-common/utils/xml2sql/pgsql.xsl:1.9
*** gnue-common/utils/xml2sql/pgsql.xsl:1.8 Thu Oct 16 18:51:55 2003
--- gnue-common/utils/xml2sql/pgsql.xsl Sun Oct 19 06:10:16 2003
***************
*** 46,57 ****
<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>
<xsl:when test="@type = "string""><xsl:text>
</xsl:text>varchar(<xsl:value-of select="@length"/>)</xsl:when>
<xsl:when test="@type = "char""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@length"/>)</xsl:when>
- <xsl:when test="@type = "blob""><xsl:text>
</xsl:text>text</xsl:when>
- <xsl:when test="@type = "date""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
- <xsl:when test="@type = "longtext""><xsl:text>
</xsl:text>text</xsl:when>
<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>
--- 46,57 ----
<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>
<xsl:when test="@type = "string""><xsl:text>
</xsl:text>varchar(<xsl:value-of select="@length"/>)</xsl:when>
<xsl:when test="@type = "char""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@length"/>)</xsl:when>
<xsl:when test="@type = "text""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
! <xsl:when test="@type = "longtext""><xsl:text>
</xsl:text>text</xsl:when>
! <xsl:when test="@type = "blob""><xsl:text>
</xsl:text>text</xsl:when>
! <xsl:when test="@type = "date""><xsl:text>
date</xsl:text></xsl:when>
! <xsl:when test="@type = "time""><xsl:text>
time</xsl:text></xsl:when>
! <xsl:when test="@type = "datetime""><xsl:text>
timestamp</xsl:text></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>
- gnue-common/utils/xml2sql pgsql.xsl,
Reinhard Mueller <=