Re: [SQLObject] Approach to large joins

2007-03-04 Thread Craig Sparks
Simon, Since we use postgres, which supports views, I have an example of something like this I could attach. Let me know if you need it. -> Craig Oleg Broytmann wrote: > On Fri, Mar 02, 2007 at 09:10:29PM +0200, Simon Robins wrote: >> Is there some sort of way of having a composite object which

Re: [SQLObject] Approach to large joins

2007-03-02 Thread Oleg Broytmann
On Fri, Mar 02, 2007 at 09:10:29PM +0200, Simon Robins wrote: > Is there some sort of way of having a composite object which contains > all the classes I wanted in the join? There is no. May be you want a VIEW, if your DB supports them? A VIEW from the point of SQLObject is just another table

[SQLObject] Approach to large joins

2007-03-02 Thread Simon Robins
I've been using the basic SQLObject APIs very happily for the last year. Thanks for all the hard work. I have a question as to what is the best approach to the following - I want to do a join across multiple tables potentially returning lots of rows. I do this with MyClass.select which give