Apache::Wyrd::SQLForm 0.98

Apache::Wyrd::SQLForm is a Perl module to general Form Wyrd for editing data in SQL.

SYNOPSIS

< BASENAME::SQLForm index="user_id" table="users" >
< BASENAME::Form::Template name="password" >
< BASENAME::Form::Preload >
< BASENAME::Defaults >
select 'root' as user_id;
< /BASENAME::Defaults >
< BASENAME::Query >
select user_id from users where name='Groucho'
< /BASENAME::Query >
< /BASENAME::Form::Preload >
< b >Enter Password:< /b >< br >
< BASENAME::Input name="password" type="password" / >
< BASENAME::Input name="user_id" type="hidden" / >
< /BASENAME::Form::Template >
< BASENAME::Form::Template name="result" >
< H1 >Status: $:_status< /H1 >
< HR >
< P >$:_message< /P >
< /BASENAME::Form::Template >
< /BASENAME::SQLForm >

The SQLForm is a subclass of Apache::Wyrd::Form. It is meant to simplify the creation of forms that are used to edit data within a database connected to via the Apache::Wyrd::DBL.

The SQLForm makes the assumption that there is a primary table on which the edit is operating and that other tables will, if necessary, have elements inserted, changed or deleted from them as they relate to the primary table.

This module is meant to be subclassed, so a large number of its methods are only defined in order to be overridden. Any changes to secondary tables, for example, need to be handled by subclassing _prep_secondary, _submit_secondary, and _perform_secondary_deletes, all of which do nothing by default.


Product's homepage

Requirements:

· Perl