XSQLExample

xsql example

Description

Format a table via xsql.

configuration preconditions

Using the internal sqlite3 engine needs no configuration at all. Each agent has it's own data base.

Access to other data bases is controled by the configuration variable $xsql-connection-definitions names a file, which defines the connection parameters to connect to the mysql data base server like this:

<?xml version="1.0" ?>
<!--
 Please note, this document is not (yet) dissected as it seems to be.
 Instead the elements MUST? occure in the correct ordering.
-->
<connections xml:space="default">
 <connection>
  <name>demo</name>
  <database>test</database>
  <host>localhost</host>
  <user>askemos</user>
  <password>somepassword</password>
 </connection>
</connections>

As you can see, this file contains plain text passwords (as it has to be to here), so keep it from prying eyes.

The first field of each line gives a name to the connection, which is used in the xsql query as the value of the connection attribute. The other columns define the connection parameters.

example code

The query itself looks like this

       
<query xmlns="http://www.askemos.org/2006/XSQL/"
 rowset-element="table" row-element="tr"  connection="demo">
select bar as td, baz as td from foo
</query>

There should be a table called foo in your mysql data base, which has at least the rows bar and baz, otherwise you'll get an sql error. When everything is correct the xsql query formats them as a html table.

Source code:

<xslt:stylesheet xmlns:dsssl="dsssl" xmlns:mind="mind" xmlns:xslt="http://www.w3.org/1999/XSL/Transform" version="1.0">
 <xslt:template match="*[@type=&quot;read&quot;]">
  <html>
   <body bgcolor="white">
    <h1>xsql example</h1>
    <h2>Description</h2>
    <p>Format a table via xsql.</p>
    <h3>configuration preconditions</h3>
    <p>Using the internal
<a href="http://www.slqite.org">sqlite3</a> engine
needs no configuration at all.
Each agent has it's own data base.
</p>
    <p>Access to other data bases is controled by the
configuration variable <code>$xsql-connection-definitions</code>
names a file, which defines the connection parameters to connect to
the mysql data base server like this:</p>
    <pre>
&lt;?xml version="1.0" ?&gt;
&lt;!--
 Please note, this document is *not* (yet) dissected as it seems to be.
 Instead the elements MUST occure in the correct ordering.
--&gt;
&lt;connections xml:space="default"&gt;
 &lt;connection&gt;
  &lt;name&gt;demo&lt;/name&gt;
  &lt;database&gt;test&lt;/database&gt;
  &lt;host&gt;localhost&lt;/host&gt;
  &lt;user&gt;askemos&lt;/user&gt;
  &lt;password&gt;somepassword&lt;/password&gt;
 &lt;/connection&gt;
&lt;/connections&gt;</pre>
    <p>As you can see, this file contains plain text passwords
(as it has to be to here), so keep it from prying eyes.</p>
    <p>The first field of each line gives a name to the connection,
which is used in the xsql query as the value of the connection attribute.
The other columns define the connection parameters.</p>
    <h3>example code</h3>
    <p>The query itself looks like this</p>
    <pre>
     <abbr xmlns="nu">
&lt;query xmlns="http://www.askemos.org/2006/XSQL/"
 rowset-element="table" row-element="tr"  connection="demo"&gt;
select bar as td, baz as td from foo
&lt;/query&gt;</abbr>
    </pre>
    <p>There should be a table called <code>foo</code> in your mysql data base,
which has at least the rows <code>bar</code> and <code>baz</code>,
otherwise you'll get an sql error.
When everything is correct the xsql query formats them as a html table.</p>
   </body>
  </html>
 </xslt:template>
</xslt:stylesheet>

Diese Seite findet man von: overview, .



Letzte Modifikation: Fri, 05 May 2006 12:20:00 +0200

Autor(en): jfw,

Dokument Nummer A67bb0753e1676f81983e0ecf3a15b391 geliefert an public um Mon, 08 Sep 2008 20:25:23 +0200