Name wanted for module in construction
- From: lukeross@xxxxxxxxx
- Date: 15 Mar 2006 15:21:35 -0800
Hi,
I'm writing a module designed to work along with DBI to enable
database-independent SQL generation. I've seen DBIx::SQLEngine and
DBIx::Abstract, but I feel that the syntax is too verbose and the data
structures too nested. My module uses source filters and PPI to allow
you to write some Perlish code which is transformed. Syntax is nowhere
near fixed yet, but along the lines of:
$dbh->My::Module(table1, table1.foo == 1 && table1.bar eq "hello");
(a.k.a. select * from table1 where table1.foo = 1 and table1.bar =
"hello")
or the more complex:
$dbh->My::Module([table1->table2(table1.a==table2.b)], table1.status =~
m/^Foo/ and (table2.a eq "a" || table2.a eq $foo));
(a.k.a. select * from table1 right join table2 on table1.a=table2.b
where table1.status like "Foo%" and (table2.a = "a" or table2.a =
$foo)) where $foo is interpolated at runtime.
Questions: am I reinventing the wheel? and if not, what should I call
it? I have in mind Filter::SQL or DBIx::Filter.
Thanks,
Luke
.
- Follow-Ups:
- Re: Name wanted for module in construction
- From: Ron Savage
- Re: Name wanted for module in construction
- Prev by Date: Re: Is there nealy same module? ExportTo
- Next by Date: Unable to load module
- Previous by thread: Net::FTP connection status
- Next by thread: Re: Name wanted for module in construction
- Index(es):
Relevant Pages
|
|
