From stefano@locus.apache.org  Fri Jul 21 20:13:38 2000
Return-Path: <stefano@locus.apache.org>
Mailing-List: contact cocoon-cvs-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-cvs@xml.apache.org
Received: (qmail 15942 invoked by uid 1010); 21 Jul 2000 20:13:38 -0000
Date: 21 Jul 2000 20:13:38 -0000
Message-ID: <20000721201338.15935.qmail@locus.apache.org>
From: stefano@locus.apache.org
To: xml-cocoon-cvs@apache.org
Subject: cvs commit: xml-cocoon/src/org/apache/cocoon/processor/xsp/library/sql sql.xsl

stefano     00/07/21 13:13:37

  Added:       src/org/apache/cocoon/processor/xsp/library/sql sql.xsl
  Removed:     src/org/apache/cocoon/processor/xsp/library/java sql.xsl
  Log:
  moved SQL taglib in its correct location
  
  Revision  Changes    Path
  1.1                  xml-cocoon/src/org/apache/cocoon/processor/xsp/library/sql/sql.xsl
  
  Index: sql.xsl
  ===================================================================
  <?xml version="1.0"?>
  <!--
  
   ============================================================================
                     The Apache Software License, Version 1.1
   ============================================================================
  
   Copyright (C) @year@ The Apache Software Foundation. All rights reserved.
  
   Redistribution and use in source and binary forms, with or without modifica-
   tion, are permitted provided that the following conditions are met:
  
   1. Redistributions of  source code must  retain the above copyright  notice,
      this list of conditions and the following disclaimer.
  
   2. Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
  
   3. The end-user documentation included with the redistribution, if any, must
      include  the following  acknowledgment:  "This product includes  software
      developed  by the  Apache Software Foundation  (http://www.apache.org/)."
      Alternately, this  acknowledgment may  appear in the software itself,  if
      and wherever such third-party acknowledgments normally appear.
  
   4. The names "Cocoon" and  "Apache Software Foundation"  must not be used to
      endorse  or promote  products derived  from this  software without  prior
      written permission. For written permission, please contact
      apache@apache.org.
  
   5. Products  derived from this software may not  be called "Apache", nor may
      "Apache" appear  in their name,  without prior written permission  of the
      Apache Software Foundation.
  
   THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES,
   INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
   FITNESS  FOR A PARTICULAR  PURPOSE ARE  DISCLAIMED.  IN NO  EVENT SHALL  THE
   APACHE SOFTWARE  FOUNDATION  OR ITS CONTRIBUTORS  BE LIABLE FOR  ANY DIRECT,
   INDIRECT, INCIDENTAL, SPECIAL,  EXEMPLARY, OR CONSEQUENTIAL  DAMAGES (INCLU-
   DING, BUT NOT LIMITED TO, PROCUREMENT  OF SUBSTITUTE GOODS OR SERVICES; LOSS
   OF USE, DATA, OR  PROFITS; OR BUSINESS  INTERRUPTION)  HOWEVER CAUSED AND ON
   ANY  THEORY OF LIABILITY,  WHETHER  IN CONTRACT,  STRICT LIABILITY,  OR TORT
   (INCLUDING  NEGLIGENCE OR  OTHERWISE) ARISING IN  ANY WAY OUT OF THE  USE OF
   THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  
   This software  consists of voluntary contributions made  by many individuals
   on  behalf of the Apache Software  Foundation and was  originally created by
   Stefano Mazzocchi  <stefano@apache.org>. For more  information on the Apache
   Software Foundation, please see <http://www.apache.org/>.
  
  -->
  
  <xsl:stylesheet version="1.0"
  	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  	xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  	xmlns:sql="http://www.apache.org/1999/SQL"
  >
  
    <xsl:template name="get-nested-content">
      <xsl:param name="content"/>
  	<xsl:choose>
  		<xsl:when test="$content/*">
  			<xsl:apply-templates select="$content/*"/>
  		</xsl:when>
  		<xsl:otherwise>"<xsl:value-of select="$content"/>"</xsl:otherwise>
  	</xsl:choose>
    </xsl:template>
  
    <xsl:template name="get-nested-string">
    	<xsl:param name="content"/>
  	<xsl:choose>
  		<xsl:when test="$content/*">
  			""
  			<xsl:for-each select="$content/node()">
  				<xsl:choose>
  					<xsl:when test="name(.)">
  						+ <xsl:apply-templates select="."/>
  					</xsl:when>
  					<xsl:otherwise>
  						+ "<xsl:value-of select="translate(.,'&#9;&#10;&#13;','   ')"/>"
  					</xsl:otherwise>
  				</xsl:choose>
  			</xsl:for-each>
  		</xsl:when>
  		<xsl:otherwise>"<xsl:value-of select="normalize-space($content)"/>"</xsl:otherwise>
  	</xsl:choose>
  </xsl:template>
  
  <xsl:template match="xsp:page">
  	<xsp:page>
  		<xsl:apply-templates select="@*"/>
  		<xsp:structure>
  			<xsp:include>org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary</xsp:include>
  		</xsp:structure>
  		<xsl:apply-templates/>
  	</xsp:page>
  </xsl:template>
  
  <xsl:template match="sql:execute-query">
  	<xsl:variable name="use-connection">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:use-connection"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="driver">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:driver"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="dburl">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:dburl"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="username">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:username"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="password">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:password"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="doc-element">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:doc-element"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="row-element">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:row-element"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="tag-case">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:tag-case"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="null-indicator">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:null-indicator"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="id-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:id-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="id-attribute-column">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:id-attribute-column"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="max-rows">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:max-rows"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="skip-rows">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:skip-rows"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="count-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:count-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="query-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:query-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="skip-rows-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:skip-rows-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="max-rows-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:max-rows-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="update-rows-attribute">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:update-rows-attribute"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="namespace">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:namespace"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsl:variable name="query">
  		<xsl:call-template name="get-nested-string">
  			<xsl:with-param name="content" select="sql:query"/>
  		</xsl:call-template>
  	</xsl:variable>
  	<xsp:logic>
  		{
  		Integer max_rows = new Integer(-1);
  		String max_rows_string = String.valueOf(<xsl:copy-of select="$max-rows"/>);
  		try {
  			max_rows = new Integer(max_rows_string);
  		} catch (Exception e) {}
  		Integer skip_rows = new Integer(0);
  		String skip_rows_string = String.valueOf(<xsl:copy-of select="$skip-rows"/>);
  		try {
  			skip_rows = new Integer(skip_rows_string);
  		} catch (Exception e) {}
  		Hashtable column_formats = new Hashtable();
  		<xsl:for-each select="sql:column-format">
  		{
  			String name = String.valueOf(<xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="sql:name"/></xsl:call-template>);
  			String classname = String.valueOf(<xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="sql:class"/></xsl:call-template>);
  			String parameters[] = new String[<xsl:value-of select="count(sql:parameter)"/>];
  			<xsl:for-each select="sql:parameter">
  			 parameters[<xsl:value-of select="position()-1"/>] = String.valueOf(<xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="."/></xsl:call-template>);
  			</xsl:for-each>
  			Class my_class = Class.forName(classname);
  			Object format;
  			if (parameters.length == 0) {
  				//FIXME: we should try newInstance on the base class here probably
  				format = my_class.newInstance();
  			} else {
  				Class class_ary[] = new Class[parameters.length];
  				for (int i=0; i&lt;parameters.length; i++) {
  					class_ary[i] = parameters[i].getClass();
  				}
  				java.lang.reflect.Constructor constructor  = my_class.getConstructor(class_ary);
  				format = constructor.newInstance(parameters);
  			}
  			column_formats.put(name,format);
  		}
  		</xsl:for-each>
  			Element result_elements[] = null;
  			if (String.valueOf(<xsl:copy-of select="$use-connection"/>) == "") {
  				result_elements = 
  				XSPSQLLibrary.executeQuery(
  			document,
  			String.valueOf(<xsl:copy-of select="$driver"/>),
  			String.valueOf(<xsl:copy-of select="$dburl"/>),
  			String.valueOf(<xsl:copy-of select="$username"/>),
  			String.valueOf(<xsl:copy-of select="$password"/>),
  			String.valueOf(<xsl:copy-of select="$doc-element"/>),
  			String.valueOf(<xsl:copy-of select="$row-element"/>),
  			String.valueOf(<xsl:copy-of select="$tag-case"/>),
  			String.valueOf(<xsl:copy-of select="$null-indicator"/>),
  			String.valueOf(<xsl:copy-of select="$id-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$id-attribute-column"/>),
  			max_rows,
  			skip_rows,
  			String.valueOf(<xsl:copy-of select="$count-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$query-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$skip-rows-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$max-rows-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$update-rows-attribute"/>),
  			String.valueOf(<xsl:copy-of select="$namespace"/>),
  			String.valueOf(<xsl:copy-of select="$query"/>),
  			column_formats);
   			} else {
   				result_elements = 
  				XSPSQLLibrary.executeQuery(
  										   document,
  										   String.valueOf(<xsl:copy-of select="$use-connection"/>),
  										   String.valueOf(<xsl:copy-of select="$doc-element"/>),
  										   String.valueOf(<xsl:copy-of select="$row-element"/>),
  										   String.valueOf(<xsl:copy-of select="$tag-case"/>),
  										   String.valueOf(<xsl:copy-of select="$null-indicator"/>),
  										   String.valueOf(<xsl:copy-of select="$id-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$id-attribute-column"/>),
  										   max_rows,
  										   skip_rows,
  										   String.valueOf(<xsl:copy-of select="$count-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$query-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$skip-rows-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$max-rows-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$update-rows-attribute"/>),
  										   String.valueOf(<xsl:copy-of select="$namespace"/>),
  										   String.valueOf(<xsl:copy-of select="$query"/>),
  										   column_formats);
   			}
  		for (int i=0; i&lt;result_elements.length; i++) {
  			<xsp:content><xsp:expr>result_elements[i]</xsp:expr></xsp:content>
  		}
  	}
  	</xsp:logic>
  </xsl:template>
  
          <xsl:template match="@*|node()" priority="-1">
  		                <xsl:copy><xsl:apply-templates
  						select="@*|node()"/></xsl:copy>
  						        </xsl:template>
  
  
  </xsl:stylesheet>