Re: [SQLObject] LEFTJOINOn question

[Fred C <bs...@gm...>]

On Apr 22, 2008, at 4:21 PM, Oleg Broytmann wrote:

> On Tue, Apr 22, 2008 at 04:16:53PM -0700, Fred C wrote:
>> How
>> can I have sqlobject returning the fields from both tables.
>
>   SQLObject.select() cannot do that because it doesn't know the
> description of the fields. Article.select(...) - SQLObject knows only
> Article's fields.
>   sqlbuilder.Select() returns whatever you want.


The problem with sqlbuilder is that it only know about the database  
raw fields and what is returned are just arrays of fields and I am  
loosing the mapping with the objects. In my class Articles and  
Comments I have methods  and these methods are not accessible by what  
is returned from sqlbuilder.Select

for exemple in the class Comment I have the method

     def _get_datetime(self):
         return self._SO_get_created().strftime('%b %d, %Y @ %H:%M')

This method cannot called from a request build with sqlbuilder.Select  
and can be called from a regular select

x = Comment.select()
x[0].datetime

-fred-