NAME
Konstrukt::Plugin::sql - Perform SQL queries. Usually combined with templates to display the results.
SYNOPSIS
SELECT queries
Usage:
<!-- put query results into a template using the dbi default settings defined in your konstrukt.settings
see the Konstrukt::DBI documentation for the configuration of the default settings -->
<& sql template="list_layout.template" &>
SELECT * FROM some_table
<& / &>
<!-- you must have a list <+@ sql @+> in your template file to which the results are passed.
the fields inside the list should be named like the columns in your query. -->or
<!-- but you may also define the listname yourself -->
<& sql template="list_layout.template" list="some_list_name" &>
SELECT * FROM some_table
<& / &>
<!-- then you should have a list <+@ some_list_name @+> in your template file. -->or
<!-- using custom connection settings -->
<& sql template="..." source="dbi_dsn" user="username" pass="password" &>
...
<& / &>Other queries
<!-- some query that won't return result data -->
<& sql &>DELETE FROM some_table WHERE id=23<& / &>DESCRIPTION
This plugin allows an easy integration of SQL queries. Usually combined with templates to display the results.
The usage is explained in the "SYNOPSIS".
METHODS
execute_again
Yes, this plugin may return dynamic nodes (i.e. template nodes).
prepare
SQL-queries are very volatile data. We don't want to cache it...
Parameters:
$tag - Reference to the tag (and its children) that shall be handled.
execute
Put out the date.
Parameters:
$tag - Reference to the tag (and its children) that shall be handled.
AUTHOR
Copyright 2006 Thomas Wittek (mail at gedankenkonstrukt dot de). All rights reserved.
This document is free software. It is distributed under the same terms as Perl itself.