lib/WikiDB/adodb/xsl/convert-0.1-0.3.xsl

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <xsl:stylesheet version="1.0"
   3         xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   4 >
   5         <xsl:output method="xml" indent="yes" omit-xml-declaration="no" encoding="UTF-8"/>
   6
   7         <!-- Schema -->
   8         <xsl:template match="/">
   9                 <xsl:comment>
  10 ADODB XMLSchema
  11 http://adodb-xmlschema.sourceforge.net
  12 </xsl:comment>
  13
  14                 <xsl:element name="schema">
  15                         <xsl:attribute name="version">0.3</xsl:attribute>
  16
  17                         <xsl:apply-templates select="schema/table|schema/sql"/>
  18                 </xsl:element>
  19         </xsl:template>
  20
  21         <!-- Table -->
  22         <xsl:template match="table">
  23                 <xsl:variable name="table_name" select="@name"/>
  24
  25                 <xsl:element name="table">
  26                         <xsl:attribute name="name"><xsl:value-of select="$table_name"/></xsl:attribute>
  27
  28                         <xsl:if test="string-length(@platform) > 0">
  29                                 <xsl:attribute name="platform"><xsl:value-of select="@platform"/></xsl:attribute>
  30                         </xsl:if>
  31
  32                         <xsl:if test="string-length(@version) > 0">
  33                                 <xsl:attribute name="version"><xsl:value-of select="@version"/></xsl:attribute>
  34                         </xsl:if>
  35
  36                         <xsl:apply-templates select="descr[1]"/>
  37
  38                         <xsl:choose>
  39                                 <xsl:when test="count(DROP) > 0">
  40                                         <xsl:element name="DROP"/>
  41                                 </xsl:when>
  42                                 <xsl:otherwise>
  43                                         <xsl:apply-templates select="field"/>
  44                                 </xsl:otherwise>
  45                         </xsl:choose>
  46
  47                         <xsl:apply-templates select="constraint"/>
  48
  49                         <xsl:apply-templates select="../index[@table=$table_name]"/>
  50                 </xsl:element>
  51         </xsl:template>
  52
  53         <!-- Field -->
  54         <xsl:template match="field">
  55                 <xsl:element name="field">
  56                         <xsl:attribute name="name"><xsl:value-of select="@name"/></xsl:attribute>
  57                         <xsl:attribute name="type"><xsl:value-of select="@type"/></xsl:attribute>
  58
  59                         <xsl:if test="string-length(@size) > 0">
  60                                 <xsl:attribute name="size"><xsl:value-of select="@size"/></xsl:attribute>
  61                         </xsl:if>
  62
  63                         <xsl:choose>
  64                                 <xsl:when test="string-length(@opts) = 0"/>
  65                                 <xsl:when test="@opts = 'UNSIGNED'">
  66                                         <xsl:element name="UNSIGNED"/>
  67                                 </xsl:when>
  68                                 <xsl:when test="contains(@opts,'UNSIGNED')">
  69                                         <xsl:attribute name="opts">
  70                                                 <xsl:value-of select="concat(substring-before(@opts,'UNSIGNED'),substring-after(@opts,'UNSIGNED'))"/>
  71                                         </xsl:attribute>
  72                                         <xsl:element name="UNSIGNED"/>
  73                                 </xsl:when>
  74                                 <xsl:otherwise>
  75                                         <xsl:attribute name="opts"><xsl:value-of select="@opts"/></xsl:attribute>
  76                                 </xsl:otherwise>
  77                         </xsl:choose>
  78
  79                         <xsl:choose>
  80                                 <xsl:when test="count(PRIMARY) > 0">
  81                                         <xsl:element name="PRIMARY"/>
  82                                 </xsl:when>
  83                                 <xsl:when test="count(KEY) > 0">
  84                                         <xsl:element name="KEY"/>
  85                                 </xsl:when>
  86                                 <xsl:when test="count(NOTNULL) > 0">
  87                                         <xsl:element name="NOTNULL"/>
  88                                 </xsl:when>
  89                         </xsl:choose>
  90
  91                         <xsl:choose>
  92                                 <xsl:when test="count(AUTO) > 0">
  93                                         <xsl:element name="AUTO"/>
  94                                 </xsl:when>
  95                                 <xsl:when test="count(AUTOINCREMENT) > 0">
  96                                         <xsl:element name="AUTOINCREMENT"/>
  97                                 </xsl:when>
  98                         </xsl:choose>
  99
 100                         <xsl:choose>
 101                                 <xsl:when test="count(DEFAULT) > 0">
 102                                         <xsl:element name="DEFAULT">
 103                                                 <xsl:attribute name="value">
 104                                                         <xsl:value-of select="DEFAULT[1]/@value"/>
 105                                                 </xsl:attribute>
 106                                         </xsl:element>
 107                                 </xsl:when>
 108                                 <xsl:when test="count(DEFDATE) > 0">
 109                                         <xsl:element name="DEFDATE">
 110                                                 <xsl:attribute name="value">
 111                                                         <xsl:value-of select="DEFDATE[1]/@value"/>
 112                                                 </xsl:attribute>
 113                                         </xsl:element>
 114                                 </xsl:when>
 115                                 <xsl:when test="count(DEFTIMESTAMP) > 0">
 116                                         <xsl:element name="DEFTIMESTAMP">
 117                                                 <xsl:attribute name="value">
 118                                                         <xsl:value-of select="DEFTIMESTAMP[1]/@value"/>
 119                                                 </xsl:attribute>
 120                                         </xsl:element>
 121                                 </xsl:when>
 122                         </xsl:choose>
 123
 124                         <xsl:if test="count(NOQUOTE) > 0">
 125                                 <xsl:element name="NOQUOTE"/>
 126                         </xsl:if>
 127
 128                         <xsl:apply-templates select="constraint"/>
 129                 </xsl:element>
 130         </xsl:template>
 131
 132         <!-- Constraint -->
 133         <xsl:template match="constraint">
 134                 <xsl:element name="constraint">
 135                         <xsl:value-of select="normalize-space(text())"/>
 136                 </xsl:element>
 137         </xsl:template>
 138
 139         <!-- Index -->
 140         <xsl:template match="index">
 141                 <xsl:element name="index">
 142                         <xsl:attribute name="name"><xsl:value-of select="@name"/></xsl:attribute>
 143
 144                         <xsl:apply-templates select="descr[1]"/>
 145
 146                         <xsl:if test="count(CLUSTERED) > 0">
 147                                 <xsl:element name="CLUSTERED"/>
 148                         </xsl:if>
 149
 150                         <xsl:if test="count(BITMAP) > 0">
 151                                 <xsl:element name="BITMAP"/>
 152                         </xsl:if>
 153
 154                         <xsl:if test="count(UNIQUE) > 0">
 155                                 <xsl:element name="UNIQUE"/>
 156                         </xsl:if>
 157
 158                         <xsl:if test="count(FULLTEXT) > 0">
 159                                 <xsl:element name="FULLTEXT"/>
 160                         </xsl:if>
 161
 162                         <xsl:if test="count(HASH) > 0">
 163                                 <xsl:element name="HASH"/>
 164                         </xsl:if>
 165
 166                         <xsl:choose>
 167                                 <xsl:when test="count(DROP) > 0">
 168                                         <xsl:element name="DROP"/>
 169                                 </xsl:when>
 170                                 <xsl:otherwise>
 171                                         <xsl:apply-templates select="col"/>
 172                                 </xsl:otherwise>
 173                         </xsl:choose>
 174                 </xsl:element>
 175         </xsl:template>
 176
 177         <!-- Index Column -->
 178         <xsl:template match="col">
 179                 <xsl:element name="col">
 180                         <xsl:value-of select="normalize-space(text())"/>
 181                 </xsl:element>
 182         </xsl:template>
 183
 184         <!-- SQL QuerySet -->
 185         <xsl:template match="sql">
 186                 <xsl:element name="sql">
 187                         <xsl:if test="string-length(@platform) > 0">
 188                                 <xsl:attribute name="platform"><xsl:value-of select="@platform"/></xsl:attribute>
 189                         </xsl:if>
 190
 191                         <xsl:if test="string-length(@key) > 0">
 192                                 <xsl:attribute name="key"><xsl:value-of select="@key"/></xsl:attribute>
 193                         </xsl:if>
 194
 195                         <xsl:if test="string-length(@prefixmethod) > 0">
 196                                 <xsl:attribute name="prefixmethod"><xsl:value-of select="@prefixmethod"/></xsl:attribute>
 197                         </xsl:if>
 198
 199                         <xsl:apply-templates select="descr[1]"/>
 200                         <xsl:apply-templates select="query"/>
 201                 </xsl:element>
 202         </xsl:template>
 203
 204         <!-- Query -->
 205         <xsl:template match="query">
 206                 <xsl:element name="query">
 207                         <xsl:if test="string-length(@platform) > 0">
 208                                 <xsl:attribute name="platform"><xsl:value-of select="@platform"/></xsl:attribute>
 209                         </xsl:if>
 210
 211                         <xsl:value-of select="normalize-space(text())"/>
 212                 </xsl:element>
 213         </xsl:template>
 214
 215         <!-- Description -->
 216         <xsl:template match="descr">
 217                 <xsl:element name="descr">
 218                         <xsl:value-of select="normalize-space(text())"/>
 219                 </xsl:element>
 220         </xsl:template>
 221 </xsl:stylesheet>