I just don't really agree that this isn't very OOpy. Obviously it
wouldn't be good to just mix the extra columns right into your existing
SQLObject instances so they're different from your definition. However,
either the SQLObject class or the SelectResults class could define some
dict-like structure as a standard property for the "extra" columns
returned that weren't used in constructing the actual SQLObject
instances that pop out of the SelectResults instance. You'd have to use
a "get" method to pull stuff out, and you wouldn't be guaranteed that
the columns you were looking for would actually be there. But if you
knew something about the query that produced the results, then you WOULD
know where to look to find the extra stuff.
Having OOPy style integration is great, but it's worthless if you have
to dodge around the library completely or settle for really inefficient
performance for some complex queries. I'd always prefer to find clever
(and OO acceptable) ways to add functionality into an ORM library
instead of just leaving functionality out.
What do other people think?
- Sean
Rick Flosi wrote:
> I think it might not exist b/c it isn't very SQLObjecty.
> You'd be returning an object with a new field in it, SUM(), which isn't
> part of the SQLObject and probably a subset of the SQLObject fields as
> well. This isn't very OO which is what I think SQLObject was designed for.
>
> On Fri, 4 Aug 2006, Sean O'Donnell wrote:
>
>> Yip, us poor seans seem to be flat out of luck. Im off to a wedding for
>> the weekend, when I get back
>> I will see about getting my hands dirty. I've never looked at the
>> SQLObject source, so it should prove
>> to be an education.
>>
>> Thanks for getting back to me so quickly.
>>
>> Sean
>>
>> Sean McBride wrote:
>>> Unfortunately, it's not implemented right now, and it seems that only
>>> Seans need it! See my post a little ways down this list about it. As it
>>> currently stands, someone like you or I is going to have to implement it
>>> and submit to the list before this kind of ordering is possible.
>>> (Believe me, I have about 5-8 queries right now that could really use it.)
>>>
>>> I'm considering trying my hand at adding it but won't have time for at
>>> least a few more weeks due to my current project.
>>>
>>> - Sean
>>>
>>> Sean O'Donnell wrote:
>>>
>>>> Hi There,
>>>>
>>>> Im trying to figure out a way to order a query by the sum of a colum in
>>>> a MultipleJoin
>>>>
>>>> e.g (not the original code, its messed up by me trying so many possible
>>>> solutions :)
>>>>
>>>> class Salesman(SQLObject):
>>>> name = StringCol()
>>>> sales = MultipleJoin(Sale)
>>>>
>>>> class Sale(SQLObject):
>>>> salesman = ForeignKey('Salesman')
>>>> amount = IntCol()
>>>>
>>>>
>>>> Now supposing I want to query a list of all of the Salesmen, ordered by
>>>> the Sum of the amounts of their sales?
>>>> Will SQLObject let me do that?
>>>>
>>>> If I was writing plain ole SQL I would do
>>>>
>>>> select salesman.name, sum(sale.amount) from salesman, sale where
>>>> salesman.id = sale.salesman_id group by salesman.id order by sum(sale)
>>>> desc.
>>>>
>>>> I dug through the SQLObject documentation and order by only seems to
>>>> take single column names, I found some references to group by on this
>>>> mailing list, but could not get anything working :(
>>>>
>>>> Thanks for your help
>>>>
>>>> Sean
>>>>
>>>> -------------------------------------------------------------------------
>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>>> your
>>>> opinions on IT & business topics through brief surveys -- and earn cash
>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>>
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys -- and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sqlobject-discuss mailing list
>>> sqlobject-discuss@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys -- and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sqlobject-discuss mailing list
>> sqlobject-discuss@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
