[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue common/utils/xml2sql/pgsql.xsl common/util...
From: |
Jan Ischebeck |
Subject: |
gnue common/utils/xml2sql/pgsql.xsl common/util... |
Date: |
Thu, 03 Apr 2003 18:34:19 -0500 |
CVSROOT: /cvsroot/gnue
Module name: gnue
Changes by: Jan Ischebeck <address@hidden> 03/04/03 18:34:19
Modified files:
common/utils/xml2sql: pgsql.xsl mysql.xsl
appserver/samples: sample.gsd
Log message:
small changes on a way to a GSD populated appserver backend db
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/utils/xml2sql/pgsql.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.5&tr2=1.6&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/appserver/samples/sample.gsd.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
Patches:
Index: gnue/appserver/samples/sample.gsd
diff -c gnue/appserver/samples/sample.gsd:1.1
gnue/appserver/samples/sample.gsd:1.2
*** gnue/appserver/samples/sample.gsd:1.1 Wed Jul 10 16:29:59 2002
--- gnue/appserver/samples/sample.gsd Thu Apr 3 18:34:19 2003
***************
*** 1,34 ****
<?xml version="1.0"?>
<schema>
<tables>
<table name="appserver_users">
! <fields><field name="username" type="varchar" size="20"
nullable="N"/>
! <field name="password" type="varchar" size="20"/>
<field name="tablelist" type="text"/>
</fields>
<primarykey name="pk_appserver_users">
<pkfield name="username"/>
</primarykey>
</table>
<table name="appserver_pytrigger">
! <fields><field name="name" type="varchar" size="30"
nullable="N"/>
! <field name="event" type="varchar" size="30"/>
<field name="code" type="text"/>
</fields>
<primarykey name="pk_appserver_pytrigger">
<pkfield name="name"/></primarykey>
</table>
! <!-- a test table -->
<table name="person">
! <fields><field name="name" type="varchar" size="35"/>
! <field name="street" type="varchar" size="35"/>
! <field name="zip" type="varchar" size="17"/>
! <field name="city" type="varchar" size="35"/>
</fields>
</table>
</tables>
<data>
<tabledata name="sample_appserver_users" tablename="appserver_users">
<rows>
<row>
--- 1,93 ----
<?xml version="1.0"?>
<schema>
<tables>
+ <!-- Class Repository -->
+ <table name="gnue_module">
+ <fields>
+ <field name="gnue_id" type="string" length="32"/>
+ <field name="gnue_name" type="string" length="35"/>
+ <field name="gnue_comment" type="string" length="70"/>
+ </fields>
+ <primarykey name="pk_gnue_module">
+ <pkfield name="gnue_id"/></primarykey>
+ </table>
+ <table name="gnue_class">
+ <fields>
+ <field name="gnue_id" type="string" length="32"/>
+ <field name="gnue_module" type="string" length="35"/>
+ <field name="gnue_name" type="string" length="35"/>
+ <field name="gnue_comment" type="string" length="70"/>
+ </fields>
+ <primarykey name="pk_gnue_class">
+ <pkfield name="gnue_id"/></primarykey>
+ </table>
+ <table name="gnue_property">
+ <fields>
+ <field name="gnue_id" type="string" length="32"/>
+ <field name="gnue_module" type="string" length="35"/>
+ <field name="gnue_class" type="string" length="35"/>
+ <field name="gnue_name" type="string" length="35"/>
+ <field name="gnue_type" type="string" length="35"/>
+ <field name="gnue_comment" type="string" length="70"/>
+ </fields>
+ <primarykey name="pk_gnue_property">
+ <pkfield name="gnue_id"/></primarykey>
+ </table>
+ <!-- Appserver User listing -->
<table name="appserver_users">
! <fields>
! <field name="gnue_id" type="string" length="32"/>
! <field name="username" type="string" length="20"
nullable="N"/>
! <field name="password" type="string" length="20"/>
<field name="tablelist" type="text"/>
</fields>
<primarykey name="pk_appserver_users">
<pkfield name="username"/>
</primarykey>
</table>
+ <!-- Appserver trigger list
+ TODO: merge into class repository -->
<table name="appserver_pytrigger">
! <fields>
! <field name="gnue_id" type="string" length="32"/>
! <field name="name" type="string" length="30"
nullable="N"/>
! <field name="event" type="string" length="30"/>
<field name="code" type="text"/>
</fields>
<primarykey name="pk_appserver_pytrigger">
<pkfield name="name"/></primarykey>
</table>
!
! <!-- a test table, can be removed -->
<table name="person">
! <fields><field name="name" type="string" length="35"/>
! <field name="street" type="string" length="35"/>
! <field name="zip" type="string" length="17"/>
! <field name="city" type="string" length="35"/>
</fields>
</table>
</tables>
<data>
+ <tabledata name="basic_gnue_module" tablename="gnue_module">
+ <rows>
+ <row>
+ <value>'00000000000000000000000000000000'</value>
+ <value>'gnue'</value>
+ <value>'GNU Enterprise System Module'</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="basic_gnue_module" tablename="gnue_module">
+ <rows>
+ <row>
+ <value>'00000000000000000000000000000000'</value>
+ <value>'gnue'</value>
+ <value>'GNU Enterprise System Module'</value>
+ </row>
+ </rows>
+ </tabledata>
+
<tabledata name="sample_appserver_users" tablename="appserver_users">
<rows>
<row>
Index: gnue/common/utils/xml2sql/mysql.xsl
diff -c gnue/common/utils/xml2sql/mysql.xsl:1.5
gnue/common/utils/xml2sql/mysql.xsl:1.6
*** gnue/common/utils/xml2sql/mysql.xsl:1.5 Fri Jul 26 10:14:57 2002
--- gnue/common/utils/xml2sql/mysql.xsl Thu Apr 3 18:34:19 2003
***************
*** 19,46 ****
<xsl:when test="@type = "auto""><xsl:text> int(11)
auto_increment</xsl:text></xsl:when>
<xsl:when test="@type = "int"">
<xsl:choose>
! <xsl:when test="@size = 2"><xsl:text>
smallint</xsl:text></xsl:when>
! <xsl:when test="@size = 4"><xsl:text> int</xsl:text></xsl:when>
! <xsl:when test="@size = 8"><xsl:text> bigint</xsl:text></xsl:when>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "float"">
<xsl:choose>
! <xsl:when test="@size = 4"><xsl:text> float</xsl:text></xsl:when>
! <xsl:when test="@size = 8"><xsl:text> double</xsl:text></xsl:when>
</xsl:choose>
</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>
! <xsl:when test="@type = "varchar"">
<xsl:choose>
! <xsl:when test="@size > 255"><xsl:text>
text</xsl:text></xsl:when>
! <xsl:otherwise><xsl:text> </xsl:text><xsl:value-of
select="@type"/>(<xsl:value-of select="@size"/>)</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "char"">
<xsl:choose>
! <xsl:when test="@size > 255"><xsl:text>
text</xsl:text></xsl:when>
! <xsl:otherwise><xsl:text> </xsl:text><xsl:value-of
select="@type"/>(<xsl:value-of select="@size"/>)</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "blob""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
--- 19,52 ----
<xsl:when test="@type = "auto""><xsl:text> int(11)
auto_increment</xsl:text></xsl:when>
<xsl:when test="@type = "int"">
<xsl:choose>
! <xsl:when test="@length = 2"><xsl:text>
smallint</xsl:text></xsl:when>
! <xsl:when test="@length = 4"><xsl:text> int</xsl:text></xsl:when>
! <xsl:when test="@length = 8"><xsl:text>
bigint</xsl:text></xsl:when>
! <xsl:otherwise>
! <xsl:text> int</xsl:text>
! </xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "float"">
<xsl:choose>
! <xsl:when test="@length = 4"><xsl:text>
float</xsl:text></xsl:when>
! <xsl:when test="@length = 8"><xsl:text>
double</xsl:text></xsl:when>
! <xsl:otherwise>
! <xsl:text> double</xsl:text>
! </xsl:otherwise>
</xsl:choose>
</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>
! <xsl:when test="@type = "string"">
<xsl:choose>
! <xsl:when test="@length > 255"><xsl:text>
text</xsl:text></xsl:when>
! <xsl:otherwise><xsl:text> </xsl:text>varchar(<xsl:value-of
select="@length"/>)</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "char"">
<xsl:choose>
! <xsl:when test="@length > 255"><xsl:text>
text</xsl:text></xsl:when>
! <xsl:otherwise><xsl:text> </xsl:text><xsl:value-of
select="@type"/>(<xsl:value-of select="@length"/>)</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="@type = "blob""><xsl:text>
</xsl:text><xsl:value-of select="@type"/></xsl:when>
***************
*** 51,57 ****
<xsl:when test="@type = "timestamp""><xsl:text>
timestamp</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
! <xsl:choose>
<xsl:when test="@nullable = "N""><xsl:text> NOT
NULL</xsl:text></xsl:when><xsl:otherwise><xsl:text>
NULL</xsl:text></xsl:otherwise>
</xsl:choose>
<xsl:if test="@default != """><xsl:text> default </xsl:text>
--- 57,63 ----
<xsl:when test="@type = "timestamp""><xsl:text>
timestamp</xsl:text></xsl:when>
<xsl:otherwise><xsl:text> UNHANDLED TYPE(</xsl:text><xsl:value-of
select="@type"/>)</xsl:otherwise>
</xsl:choose>
! <xsl:choose>
<xsl:when test="@nullable = "N""><xsl:text> NOT
NULL</xsl:text></xsl:when><xsl:otherwise><xsl:text>
NULL</xsl:text></xsl:otherwise>
</xsl:choose>
<xsl:if test="@default != """><xsl:text> default </xsl:text>
Index: gnue/common/utils/xml2sql/pgsql.xsl
diff -c gnue/common/utils/xml2sql/pgsql.xsl:1.5
gnue/common/utils/xml2sql/pgsql.xsl:1.6
*** gnue/common/utils/xml2sql/pgsql.xsl:1.5 Wed Jul 24 19:25:25 2002
--- gnue/common/utils/xml2sql/pgsql.xsl Thu Apr 3 18:34:19 2003
***************
*** 22,32 ****
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text>
</xsl:text>int4</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>
! <xsl:when test="@type = "varchar""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@size"/>)</xsl:when>
! <xsl:when test="@type = "char""><xsl:text>
</xsl:text><xsl:value-of select="@type"/>(<xsl:value-of
select="@size"/>)</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>
--- 22,32 ----
<xsl:value-of select="@name"/>
<xsl:choose>
<xsl:when test="@type = "auto""><xsl:text>
</xsl:text>int4</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>
! <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>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue common/utils/xml2sql/pgsql.xsl common/util...,
Jan Ischebeck <=