Name:
Phil R Lawrence
Email:
[EMAIL PROTECTED]
Homepage:
www.lehigh.edu/~prl2
Preferred CPAN user id:
PRL-
Short Desc of Planned Contribution:
Text::PCL::Basic
returns PCL strings for pre- and post-pending
to your plain text files accrding to your
passed in basic formatting parms, including
width, lines per page, media size (letter,
legal, com-10, etc), orientation, sides, and
copies.
Term::Interact
use this to get input from users via terminal
interaction. Uses Text::Autoformat,
Term::Readkey. Provides for any number of
regex checks on user input and any number of
checks against return values from SQL
statements (ala "SELECT foo FROM validation").
SQL::Snippet
OO abstraction of any RDBMS. Generates SQL
statements based on simple OO syntax.
Example:
# let's report on our population of
# vendors (definition of a 'vendor'
# may include one table or many tables
# with complicated joins -- doesn't
# change this simple interface)
$population_name = 'vendors';
# we want count of this pop...
# set SELECT clause accordingly
$snippet->
pop->$population_name->
select( 'SELECT count(*)' );
# let's limit our reported vendor pop
# to those with ISO9001 certification
$limit = 'ISO9001';
# set limit on population (many
# limits can be set, we are only
# setting one in this example)
$snippet->
pop->$population_name->
lim->$limit_name;
# get sql for population. Note this
# may return a very complicated SQL
# statement, depending on how many
# tables are involved in the definition
# of the pop and any applied limits.
# Yet the OO interface remains simple,
# no matter how complicated the backend
# gets.
$sql = $snippet->
pop->$population_name->
query();
