balld 00/11/09 23:53:51
Modified: samples/sql esql.xml Added: samples/sql esql.xsd esql.xsl Log: updated to use and document the (hopefully) final namespace Revision Changes Path 1.5 +36 -67 xml-cocoon/samples/sql/esql.xml Index: esql.xml =================================================================== RCS file: /home/cvs/xml-cocoon/samples/sql/esql.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- esql.xml 2000/09/29 04:25:20 1.4 +++ esql.xml 2000/11/10 07:53:50 1.5 @@ -1,80 +1,49 @@ <?xml version="1.0"?> <?cocoon-process type="xsp"?> -<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?> +<?cocoon-process type="xslt"?> +<?xml-stylesheet type="text/xsl" href="esql.xsl"?> <xsp:page - language="java" - xmlns:esql="http://apache.org/cocoon/SQL/v2"; xmlns:xsp="http://www.apache.org/1999/XSP/Core"; - xmlns:request="http://www.apache.org/1999/XSP/Request"; + xmlns:esql="http://apache.org/cocoon/SQL/v2"; > <page> - -<esql:execute-query inner-method="no"> -<esql:driver>postgresql.Driver</esql:driver> -<esql:dburl>jdbc:postgresql://localhost/test</esql:dburl> -<esql:username>test</esql:username> -<esql:password>test</esql:password> -<esql:query>select * from department_table</esql:query> -<esql:results> - <department> - <id><esql:get-string column="id"/></id> - <name><esql:get-string column="name"/></name> - <employees> - <esql:execute-query inner-method="no"> - <esql:query>select * from employee_table where department_id = <esql:get-string column="id" ancestor="1"/></esql:query> - <esql:results> - <employee> - <id><esql:get-string column="id"/></id> - <name><esql:get-string column="name"/></name> - </employee> - </esql:results> - </esql:execute-query> - </employees> - </department> -</esql:results> -<esql:no-results> - <error>no results were found</error> -</esql:no-results> -<esql:error-results> - <message><esql:get-message/></message> - <stacktrace><esql:get-stacktrace/></stacktrace> -</esql:error-results> -</esql:execute-query> -<esql:execute-query> -<esql:driver>postgresql.Driver</esql:driver> -<esql:dburl>jdbc:postgresql://localhost/test</esql:dburl> -<esql:username>test</esql:username> -<esql:password>test</esql:password> -<esql:statement>select * from department_table where name = <esql:parameter><request:get-parameter name="name"/></esql:parameter></esql:statement> -<esql:results> - <department> - <id><esql:get-string column="id"/></id> - <name><esql:get-string column="name"/></name> - <employees> - <esql:execute-query> - <esql:query>select * from employee_table where department_id = <esql:get-string column="id" ancestor="1"/></esql:query> - <esql:results> - <employee> - <id><esql:get-string column="id"/></id> - <name><esql:get-string column="name"/></name> - </employee> - </esql:results> - </esql:execute-query> - </employees> - </department> -</esql:results> -<esql:no-results> - <error>no results were found</error> -</esql:no-results> -<esql:error-results> - <message><esql:get-message/></message> - <stacktrace><esql:get-stacktrace/></stacktrace> -</esql:error-results> -</esql:execute-query> +<esql:connection> + <esql:driver>org.postgresql.Driver</esql:driver> + <esql:dburl>jdbc:postgresql://localhost/test</esql:dburl> + <esql:username>test</esql:username> + <esql:password>test</esql:password> + <esql:execute-query> + <esql:query>select id,name from department_table</esql:query> + <esql:results> + <header>header info</header> + <esql:row-results> + <department> + <id><esql:get-int column="id"/></id> + <name><esql:get-string column="name"/></name> + <esql:connection> + <esql:driver>org.postgresql.Driver</esql:driver> + <esql:dburl>jdbc:postgresql://localhost/test</esql:dburl> + <esql:username>test</esql:username> + <esql:password>test</esql:password> + <esql:execute-query> + <esql:query>select name from user_table where department_id = <esql:parameter type="int"><esql:get-int ancestor="1" column="id"/></esql:parameter></esql:query> + <esql:results> + <esql:row-results> + <user><esql:get-string column="name"/></user> + </esql:row-results> + </esql:results> + </esql:execute-query> + </esql:connection> + </department> + </esql:row-results> + <footer>footer info</footer> + </esql:results> + </esql:execute-query> +</esql:connection> </page> 1.1 xml-cocoon/samples/sql/esql.xsd Index: esql.xsd =================================================================== <?xml version="1.0"?> <schema xmlns="http://www.w3.org/2000/10/XMLSchema"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; > <element name="esql:connection"> <complexType> <choice> <sequence> <!-- not schema strings - xsp strings --> <element name="esql:driver" type="string" minOccurs="1" maxOccurs="1"/> <element name="esql:dburl" type="string" minOccurs="1" maxOccurs="1"/> <element name="esql:username" type="string" minOccurs="0" maxOccurs="1"/> <element name="esql:password" type="string" minOccurs="0" maxOccurs="1"/> </sequence> <element name="esql:pool" type="string" minOccurs="1" maxOccurs="1"/> </choice> <element name="esql:execute-query" minOccurs="0" maxOccurs="unbounded"> <complexType> <sequence> <element name="esql:query" type="string" minOccurs="1" maxOccurs="1"/> <element name="esql:results" minOccurs="0" maxOccurs="1"> <!-- strings and stuff from other namespaces --> <element name="esql:row-results" minOccurs="0" maxOccurs="1"/> <!-- strings and stuff from other namespaces --> <element name="esql:no-results" minOccurs="0" maxOccurs="1"/> <!-- strings and stuff from other namespaces --> </complexType> </element> <element name="esql:update-results" minOccurs="0" maxOccurs="1"/> <element name="esql:error-results" minOccurs="0" maxOccurs="1"/> </sequence> </complexType> </element> </complexType> </element> </schema> 1.1 xml-cocoon/samples/sql/esql.xsl Index: esql.xsl =================================================================== <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0" > <xsl:template match="/page"> <html> <head> <title>Apache Cocoon - esql sample page</title> </head> <body> <p> <xsl:value-of select="header"/> </p> <table border="1"> <xsl:for-each select="department"> <tr> <td> <xsl:value-of select="id"/> </td> <td> <xsl:value-of select="name"/> </td> <td> <table border="1"> <xsl:for-each select="user"> <tr> <td> <xsl:value-of select="."/> </td> </tr> </xsl:for-each> </table> </td> </tr> </xsl:for-each> </table> <p> <xsl:value-of select="footer"/> </p> </body> </html> </xsl:template> </xsl:stylesheet>
