David Manura wrote:
Terrence Brannon wrote:
isnt that a long word to type every time? I envision subroutines with
an interpolating property:
sub get_authors : dbi_interp {
my ($author_list) = @_;
qq[SELECT * FROM AUTHORS WHERE author_id IN ], $author_list ;
}
my $sql = get_authors (10
David Manura wrote:
Yes, I shall shorten the name. I'm not certain if you mean something
similar to what I'm thinking of when using the "get_authors :
dbi_interp" syntax, but I am considering adding support for
Filter::Simple to simplify the syntax even further as such:
use SQL::Interpolate F
Jim Cromie wrote:
heres another possibility - without the attributes. With a wrapper
class, you can make the interpolate function disappear altogether
...
use SqlStr (alias => 'iDBI');
my $dsn = "dbi:mysql:database=test;user=test;host=localhost;";
my $dbh = iDBI->connect($dsn, { RaiseError => 1,
On Dec 31, 2003, at 9:49 PM, Terrence Brannon wrote:
And have some DBIx::Declare-aware template-processing engine handle
page requests automagically such that adding new templates and/or SQL
code doesn't involve writing or maintaining a single line of Perl
code.
you seem very HTML::Template o
NAME
Config::DBI - database connection support via Config::ApacheFormat files
SYNOPSIS
In .cshrc:
setenv DBI_CONF dbi.conf
In dbi.conf:
# Pass may be a password, or in which case, the password is
# is prompted for:
Pass
# Connect attribute
# dbi_connect_method is a standard part