I thought expose method already wraps session.flush(), and the result
is same if I add session.flush(). :(
On Jan 25, 11:24 pm, "Tim Van Steenburgh" <[EMAIL PROTECTED]>
wrote:
> You didn't call session.flush() in your save() method.
>
> On 1/25/07, Olli Wang <[EMAIL PROTECTED]> wrote:
>
>
>
> > I really really need to know what's wrong with SA and solve it. Please
> > give me a hand.
> > I couldn't make relationship between classes in expose method of
> > controller but nothing wrong in tg-admin shell.
>
> > Here's my classes in model (I use TurboEntity):
>
> > class Artist(Entity):
> > name = Column(Unicode(16), nullable=False, unique=True)
> > songs = OneToMany("Song")
>
> > class Song(Entity):
> > name = Column(Unicode(16), nullable=False)
> > artist = ManyToOne("Artist")
>
> > And here's my method in controller:
>
> > @expose()
> > def save(self):
> > artist = Artist.get(1)
> > song = Song(name="Song Name", artist=artist)
>
> > return dict()
>
> > Okay. Here's the problem I met. There should be relationship between
> > Artist and Song, but they don't. Be more clear, I give an example if I
> > run something in tg-admin shell:
>
> > >>> Song.select()[-1]
> > <Song entity at 0x1a29990>
> > >>> Song.select()[-1].id
> > 1
> > >>> Song.select()[-1].artist
> > >>> Song.select()[-1].artist.name
> > Traceback (most recent call last):
> > File "<console>", line 1, in ?
> > AttributeError: 'NoneType' object has no attribute 'name'
>
> > But, If I run this in tg-admin shell, everything is correct:
>
> > >>> artist = Artist.get(1)
> > >>> song = Song(name="Song Name", artist=artist)
> > >>> session.flush()
> > >>> Song.select()[-1]
> > <Song entity at 0x1a290d0>
> > >>> Song.select()[-1].id
> > 2
> > >>> Song.select()[-1].artist
> > <Artist entity at 0x1a29610>
> > >>> Song.select()[-1].artist.name
> > u'McFly'
>
> > See? Everything is correct in tg-admin shell but isn't in expose
> > method. I don't know if I missed something, but I really need to solve
> > this problem. Any help would be appreciated. Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
