Thread: [SQLObject] Many to One and Length of SelectResults
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Merrell, B. L. <BRI...@sa...> - 2005-08-03 06:05:50
|
Following up my earlier posting (thanks for the clarification Ian). The only way to remain implemenation indepenedent when selecting across two or more tables is to select on one table and then iterate programatically on the results (which are individually and automatically joined). I also can't seem to figure out how tell how many results were returned by a SelectResults object. Len() doesnt' appear to be defined for the class. -brian |
From: Oleg B. <ph...@ma...> - 2005-08-03 08:52:17
|
On Wed, Aug 03, 2005 at 02:05:23AM -0400, Merrell, Brian L. wrote: > I also can't seem to figure out how tell how many results were returned by a > SelectResults object. Len() doesnt' appear to be defined for the class. .count(). Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: michelts <mic...@gm...> - 2005-08-03 11:47:35
|
Hi, You may use .max('someattribute'), .min('someattribute') or .avg('someattribute') on the select result too... Just to you know :) On 8/3/05, Oleg Broytmann <ph...@ma...> wrote: > On Wed, Aug 03, 2005 at 02:05:23AM -0400, Merrell, Brian L. wrote: > > I also can't seem to figure out how tell how many results were returned= by a > > SelectResults object. Len() doesnt' appear to be defined for the class= . >=20 > .count(). >=20 > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. >=20 >=20 > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclic= k > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss >=20 --=20 Michel Thadeu Sabchuk Curitiba - Brasil |
From: John S. <sp...@is...> - 2005-08-03 14:27:35
|
On Aug 3, 2005, at 4:52 AM, Oleg Broytmann wrote: > On Wed, Aug 03, 2005 at 02:05:23AM -0400, Merrell, Brian L. wrote: > >> I also can't seem to figure out how tell how many results were >> returned by a >> SelectResults object. Len() doesnt' appear to be defined for the >> class. >> > > .count(). Yeah, I learned this just yeterday from Leonard Richardson's great article, but it wasn't before I had tried using len() on a SelectResults instance <wink>. Which begs the question, can we add len() support since it seems so natural? |
From: Ian B. <ia...@co...> - 2005-08-03 15:53:40
|
John Speno wrote: > Yeah, I learned this just yeterday from Leonard Richardson's great > article, but > it wasn't before I had tried using len() on a SelectResults instance > <wink>. > > Which begs the question, can we add len() support since it seems so > natural? It used to be in there, but sadly Python calls __len__ all the time behind your back, like when you turn something into a list, and there's no way to stop it. Since .count() is an expensive operation that caused significant problems. -- Ian Bicking / ia...@co... / http://blog.ianbicking.org |