sqlobject-discuss

[SQLObject] Where's get?

[Eduardo E. <eel...@na...>]

Hi All,

 >>> from SQLObject import *
 >>> __connection__ = MySQLConnection(name = 'system_conn', user = 
'user', passwd = 'pass', host = 'host', db = 'db', debug = True)
 >>> class SysUser (SQLObject):
...	name = StringCol(length=10, alternateID=True)
...
 >>> u = SysUser.get(1)
Traceback (most recent call last):
   File "<stdin>", line 1, in ?
AttributeError: type object 'SysUser' has no attribute 'get'

How can I load an existing instance?

TIA.

Ed.

Re: [SQLObject] Where's get?

[Oleg B. <ph...@ma...>]

On Tue, May 18, 2004 at 06:16:10PM -0400, Eduardo Elgueta wrote:
> >>> from SQLObject import *
> >>> __connection__ = MySQLConnection(name = 'system_conn', user = 
> 'user', passwd = 'pass', host = 'host', db = 'db', debug = True)
> >>> class SysUser (SQLObject):
> ...	name = StringCol(length=10, alternateID=True)
> ...
> >>> u = SysUser.get(1)
> Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
> AttributeError: type object 'SysUser' has no attribute 'get'
> 
> How can I load an existing instance?

>>> u = SysUser(1) # just so simple ;)

   or, using your alternateID:

>>> u = SysUser.byName("Eduardo")

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Where's get?

[Luke O. <lu...@me...>]

in the 0.6/SVN branch, SysUser.get(id) exists (API change/addition), but
SysUser(id) will still work. (Ian, is this planned to be deprecated? I'm
trying to recall the implications of this API change - was _init/construction
intended to be used to replace .new(), and get() the preferred way to retrieve
existing objects?)

if you are using 0.5.x, then Oleg's answer below is correct.

- Luke

>>
>> How can I load an existing instance?
>
>>>> u = SysUser(1) # just so simple ;)
>
>   or, using your alternateID:
>
>>>> u = SysUser.byName("Eduardo")
>
> Oleg.

[SQLObject] Re: Where's get?

[Eduardo E. <eel...@na...>]

Oops. I downloaded the 0.6 docs with the 0.5 tar.gz.

Thank you, guys.

Ed.

Luke Opperman wrote:

> in the 0.6/SVN branch, SysUser.get(id) exists (API change/addition), but
> SysUser(id) will still work. (Ian, is this planned to be deprecated? I'm
> trying to recall the implications of this API change - was 
> _init/construction
> intended to be used to replace .new(), and get() the preferred way to 
> retrieve
> existing objects?)
> 
> if you are using 0.5.x, then Oleg's answer below is correct.
> 
> - Luke
> 
>>>
>>> How can I load an existing instance?
>>
>>
>>>>> u = SysUser(1) # just so simple ;)
>>
>>
>>   or, using your alternateID:
>>
>>>>> u = SysUser.byName("Eduardo")
>>
>>
>> Oleg.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click