Re: [RDBO] suggestions for enchancement

2007-12-04 Thread David Lloyd
Ok, so does Hibernate from the Java World, or JPA from Jave EE 3.0 actually do what we want? I suspect it does... DSL - SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop

Re: [RDBO] suggestions for enchancement

2007-11-28 Thread Perrin Harkins
On Nov 27, 2007 11:21 PM, David Lloyd <[EMAIL PROTECTED]> wrote: > Ron Savage wrote: > > You mean like SQL::Abstract? > > http://search.cpan.org/~nwiger/SQL-Abstract-1.22/ > > I was thinking the same thing...does that not do what the OP wishes it to? SQL::Abstract is very limited. It doesn't even

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread David Lloyd
Ron, Ron Savage wrote: > You mean like SQL::Abstract? > http://search.cpan.org/~nwiger/SQL-Abstract-1.22/ I was thinking the same thing...does that not do what the OP wishes it to? DSL - SF.Net email is sponsored by: The F

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread maxim
an Davis > Sent: Tuesday, November 27, 2007 2:26 PM > To: Rose::DB::Object list > Subject: Re: [RDBO] suggestions for enchancement > > On Nov 27, 2007 3:19 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > > On Nov 27, 2007 2:41 PM, maxim <[EMAIL PROTECTED]> wrote: > >

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread Sean Davis
On Nov 27, 2007 3:19 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Nov 27, 2007 2:41 PM, maxim <[EMAIL PROTECTED]> wrote: > > its useful when you have XML based framework where your backend is > > trying to reflect some XML schema and you dont what to remap XML on the DB > > schema but just us

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread Perrin Harkins
On Nov 27, 2007 2:41 PM, maxim <[EMAIL PROTECTED]> wrote: > its useful when you have XML based framework where your backend is > trying to reflect some XML schema and you dont what to remap XML on the DB > schema but just using it. If you really want to use XML for your backend storage, I'd sugges

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread maxim
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Perrin Harkins > Sent: Tuesday, November 27, 2007 12:19 PM > To: rose-db-object@lists.sourceforge.net > Subject: Re: [RDBO] suggestions for enchancement > > On

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread Perrin Harkins
On Nov 26, 2007 11:39 PM, John Siracusa <[EMAIL PROTECTED]> wrote: > I suppose you could simulate it by building > up Perl data structures suitable for passing in a get_objects() query > parameter (i.e., value/hashref pairs and so on) but that's not quite > the same thing. That's what I've done an

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread John Siracusa
On Nov 27, 2007 9:29 AM, Peter Karman <[EMAIL PROTECTED]> wrote: > fwiw, the DBIC folks have been discussing this very topic lately: > > http://lists.scsys.co.uk/pipermail/dbix-class/2007-November/005320.html I know. I'm on that list too :) -John

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread Peter Karman
On 11/27/2007 07:32 AM, John Siracusa wrote: > On Nov 27, 2007, at 12:50 AM, Ron Savage wrote: >> On Tue, 2007-11-27 at 00:15 -0500, John Siracusa wrote: >>> I think we need a mutable object representation of SQL first, the the >> You mean like SQL::Abstract? > > No, definitely not like SQL::Abs

Re: [RDBO] suggestions for enchancement

2007-11-27 Thread John Siracusa
On Nov 27, 2007, at 12:50 AM, Ron Savage wrote: > On Tue, 2007-11-27 at 00:15 -0500, John Siracusa wrote: >> I think we need a mutable object representation of SQL first, the the > > You mean like SQL::Abstract? No, definitely not like SQL::Abstract :) SQLA provides a very limited set of featur

Re: [RDBO] suggestions for enchancement

2007-11-26 Thread Ron Savage
On Tue, 2007-11-27 at 00:15 -0500, John Siracusa wrote: Hi John > I think we need a mutable object representation of SQL first, the the You mean like SQL::Abstract? http://search.cpan.org/~nwiger/SQL-Abstract-1.22/ -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html -

Re: [RDBO] suggestions for enchancement

2007-11-26 Thread John Siracusa
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->setCond

Re: [RDBO] suggestions for enchancement

2007-11-26 Thread John Siracusa
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

[RDBO] suggestions for enchancement

2007-11-26 Thread maxim
Hi John, It would be nice to have abstraction layer for SQL query itself. I've seen that you have QueryBuilder class but its not really cohesive with Rose::DB::Object paradigm. What I am looking for is row based object which knows about allowed fields and operations and therefore can be passed to