Konstrukt::Plugin::sql - Perform SQL queries. Usually combined with templates to display the results.
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. -->
<!-- using custom connection settings --> <& sql template="..." source="dbi_dsn" user="username" pass="password" &> ... <& / &>
<!-- some query that won't return result data --> <& sql &>DELETE FROM some_table WHERE id=23<& / &>
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.
Yes, this plugin may return dynamic nodes (i.e. template nodes).
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.
Put out the date.
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.
Konstrukt::Plugin, Konstrukt
To install Konstrukt, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Konstrukt
CPAN shell
perl -MCPAN -e shell install Konstrukt
For more information on module installation, please visit the detailed CPAN module installation guide.