PI: import-db
The purpose of an import-db PI is to produce an XML-fragment from a databasequery result and replace the PI with this fragment.
<?_wxt import-db
host=""
database=""
databasetype=""
driver=""
user=""
password=""
sql=""
transformation=""
xpath=""
uri="" ?>
Alternative form
<?_wxt import-db
connectionstring=""
sql=""
transformation=""
xpath=""
uri="" ?>
The parameters are:
| uri(optional and recommanded) | A file-URI which may be absolute or relative to the owning groups location. The result of a database transaction will be written to this location. The result may be a support when writing transformations and will serve as a backup if the database is temporary unavailable. |
| transformation(optional) |
A transformation identifier (see: transformation-element) or a grouprelative or absolute location for a transformationfile.
You may use parameters in the transformation.
This transformation is applied to the content
before it is imported.
You may use the word: _table for the transformation.
This will produce a set of HTML tables describing the result of the
database transactions in a simple way.
Omitting the transformation will simply return all result-rows
from the database transaction(s).
|
| xpathoptional | Identifies what we want to extract from the (transformed) databasequery result. |
| database(mandatory or in connectionstring) | A string which identifies the database. |
| databasetype(mandatory or in connectionstring) | A string which identifies the databasetype. |
| host(mandatory or in connectionstring) | A string which identifies the host. |
| user(mandatory or in connectionstring) | The user of the database. |
| password(mandatory or in connectionstring) | The users password. |
| driver(optional) | The databsedriver to be used. WXT reckognize the shortforms psql(postgres) and mysgl, and attempts to find a driver for those databases. You may spesify any driver as long as you are sure that the driver is available in the classpath. |
| sql(optional) | SQL-statements of type SELECT, separated by semicolon. Overrides sqlfile |
| sqlfile(optional) | A file which contains SQL-statements of type SELECT, separated by semicolon. |
Some examples:
<dbcontent
uri="frascript/contentproduced.xml"
database="db1"
host="localhost"
driver="org.gjt.mm.mysql.Driver"
user="bs"
password="thepassword"
sql="SELECT * FROM perstab"
transformation="_table"/>
<dbcontent
connectionstring="jdbc:mysql://localhost/db1?user=bs&password=thepassword"
uri="frascript/contentproduced.xml"
sql="SELECT * FROM perstab"
transformation="T"
xpath="first_name"/>
