As with the general questions that come up around .select() and joins, the
underlying issue is the expectation that "instances of a SQLObject-derived class
are returned". So in your work here, the main bit is creating a fake class that
is "enough" like a SQLObject.
Also in trunk (views.py) is an a
Oleg:
Thanks much for all the info. Although it wasn't what I wanted to hear,
it's better off to know so I don't waste time beating my head against it.
Thanks again.
-Jim
Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 01:19:10PM -0500, Jim Steil wrote:
The only way in SQLObject to
On Fri, Aug 03, 2007 at 08:51:33PM +0200, Johan Carlsson wrote:
> Oleg Broytmann wrote:
> >Luke Oppermann did a unification in the trunk and merged SelectResults,
> > Select() and dbconnection.queryForSelect(). Now Select() is the
> > lowest-level API that implements all features - joins, slice
Oleg Broytmann wrote:
> On Fri, Aug 03, 2007 at 04:24:14PM +0200, Johan Carlsson wrote:
>
>> It's for taking a select object created with sqlbuilder.Select and
>> return a SelectResults derived class of it,
>> that can be iterated over ir or over slices, or call methods like
>> count() and etc
On Fri, Aug 03, 2007 at 01:19:10PM -0500, Jim Steil wrote:
> > The only way in SQLObject to select columns from multiple tables is
> >sqlbuilder.Select().
>
> I've tried that in the past, but I seem to recall that it doesn't return
> the same type of object as a regular .select(), and that is w
Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:
Thanks for the response. I do understand all of that, but in the doc
(http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
gives the following example:
MyTable.select(
join=LEFTJOINOn(Non
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:
> Thanks for the response. I do understand all of that, but in the doc
> (http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
> gives the following example:
>
> MyTable.select(
>join=LEFTJOINOn(None, Table1,
>
Thanks for the response. I do understand all of that, but in the doc
(http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
gives the following example:
MyTable.select(
join=LEFTJOINOn(None, Table1,
MyTable.q.name == Table1.q.value))
will return the foll
On Fri, Aug 03, 2007 at 10:15:50AM -0500, Jim Steil wrote:
> x = RailCar.select(...)
>
> The problem is that I don't get any of the fields from the RailStatus
> table in the select.
The problem is not with the join, but with your understanding of
.select(). SQLObject.select() can do simple or
Hi:
I'm having a problem with my left join. I'm joining two tables using:
x = RailCar.select(join=LEFTJOINOn(RailCar, RailStatus,
RailCar.q.id==RailStatus.q.railCarID))
if I then print x, I get:
SELECT RailCar.railCarId, RailCar.carInitials, RailCar.carNumber,
RailCar.active, RailCar.created
On Fri, Aug 03, 2007 at 04:24:14PM +0200, Johan Carlsson wrote:
> It's for taking a select object created with sqlbuilder.Select and
> return a SelectResults derived class of it,
> that can be iterated over ir or over slices, or call methods like
> count() and etc.
Luke Oppermann did a unific
Oleg Broytmann wrote:
> On Wed, Aug 01, 2007 at 08:37:19AM +0200, Johan Carlsson wrote:
>
>> I though I post my current work here for comments
>>
>
>But what it's all about? A lot of classes without a line of
> explanation...
>
Typically me I'm afraid :-D
It's for taking a select ob
12 matches
Mail list logo
