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. -->

<!-- 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. -->

<!-- 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".

Warning: The result will not be HTML escaped automatically.

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.