On Nov 26, 2007, at 5:29 PM, maxim wrote:
It would be nice to have abstraction layer for SQL query itself.
Yeah, no kidding :) I've got ideas for one but so far not enough time to
dedicate to it.
Something like:
my $query = Rose::DB::TableName::Manager->getSelect();
$query->someField->setCondition(eq => 'somename') if
$query->can("someField");
$query->anotherField->addCondition(lt => '1000') if
$query->can("anotherField");
$query->anotherField->addCondition( gt => '0') if
$query->can("anotherField");
my $iterator = $query->get_iterator();
------------------------------------------------
Or may be you can point me to the proper technique to follow with current
implementation.
There's nothing so nice. I suppose you could simulate it by building up
Perl data structures suitable for passing to get_objects() (i.e.,
value/hashref pairs and so on) but that's not quite the same thing.
Also, is it possible to support XPath based sql queries. (like for example
'/dbname:[EMAIL PROTECTED] = "somevalue" and @field2 > "1000"]' )
It might lead to some interesting applications where direct mapping from
some XML chunk is one of thoughts.
I think we need a mutable object representation of SQL first, the the same
thing for a set of results. Then maybe after that we can think about
translating from one query syntax (e.g., XPath) to another.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object