PI: importdb
The purpose of an import PI is to produce an XML-fragment from a database request.
<?_wxt importdb connection=""
sql=""
driver=""
xpath="" targetlocation=""
transformation=""?>
The parameters are:
| connection (mandatory) | A connectionstring. In templates this parameter may be skipped. In this case the connection in contentelement (dbcontent) in the script is used. |
| sql (optional) | A sql string. If sql is set, sqlfile is ignored. |
| sqlfile (optional) | The location of a file containing a sql string. If sql is set, sqlfile is ignored. |
| targetlocation (optional) | The result of the sqlquery, or queries, are saved as an XML-file. This XML-structure is base for transformation and following xpath extraction. targetlocation is optional, but it is very usefull to inspect this file when writing and debugging a transformation. |
| encoding (optional) | The encoding for the resulting xml. Default is UTF-8 if not changed in scrip (option:default-encoding) |
| xpath (optional) | Any xpath expression that identifies a nodeset that will be treated like a XML-fragment. |
| parse (optional) | Possible values are yes and no, width default no. If parse is set to yes the imported material is supposed to be a parsable XML-fragment (XHTML-fragment) and WXT will include this fragment as is in the module. If xpath is used the fragment imported is considered "current node". |
| transformation (optional) | A transformation identifier (see: Transformation ). This transformation may have parameters. Transformation _table is predefined and produces a simple table from the extracted data. _table can take no parameters. |
Styleclass describing a possible table-output from this PI is: dbresult, see distributed std styles.
Examples:
Importing a fragment of XHTMLcode
<?_wxt importdb
connection="jdbc:mysql://frigg.hiof.no/fragments?user=a&password=b"
sql="use fragments;
select content from material where fragid = 3;"
encoding="UTF-8"
parse="yes"
targetlocation="dbdump4.xml"?>
Importing and showing the result as a table
<?_wxt importdb
connection="jdbc:mysql://frigg.hiof.no/vin?user=a&password=b"
sql="use vin;
select type,name,dice,price from wines
where country='Spania' and type='white';
select type,name,dice from wines
where country = 'Frankrike' and type='sparkling' and dice=6;"
encoding="UTF-8"
transformation="_table"
xpath="//div[@class='dbresult' and position()='1']"
targetlocation="dbdump.xml"?>
Note the xpath stating that we will show the first of, in this case, two dbresults.
Importing and showing with a written transformation
<?_wxt importdb
connection="jdbc:mysql://frigg.hiof.no/vin?user=a&password=b"
sql="use vin;
select type,description,dice,name from wines
where country = 'Frankrike';"
encoding="UTF-8"
transformation="vindb1(type='red',dice='1')"
xpath="//div[@id='root']/*"
targetlocation="dbdump1.xml"?>