make it like this and you are good to go: http://pastie.org/1052684
you should change the model name in the relation() method for author. and then you can access the username like blog_post.author.username. please read the sqlalchemy docs for more information: http://www.sqlalchemy.org/docs/05/ormtutorial.html#building-a-relation On 20 Temmuz, 18:40, bloeper <[email protected]> wrote: > Hi all, > > I have a question, i am creating an blog application. > The blog model is as follow: > class Blog( DeclarativeBase ): > __tablename__ = 'blog' > > id = Column( Integer, primary_key = True ) > title = Column( Unicode( 100 ), nullable = False ) > slug = Column( Unicode( 110), nullable = False, unique = True ) > date = Column( DateTime, nullable = False ) > content = Column( Text, nullable = False ) > reaction = Column( Integer, nullable = True ) > author = Column( Integer, ForeignKey( 'tg_user.user_id', > onupdate="CASCADE", ondelete="CASCADE" ) ) > > def __init__( self, title, content, reaction, author, tags ): > self.title = title > self.slug = urlify( title ) > self.date = datetime.now() > self.content = content > self.reaction = reaction > self.author = author > > Now is the question (when I retrieve the information) through: > @expose('nextrus.templates.new.blog') > def blog( self, slug = 'first-post'): > try: > blog = DBSession.query( Blog ).filter_by( slug = slug ).one() > except NoResultFound: > blog = DBSession.query( Page ).filter_by( slug = u'not- > found').one() > > try: > menus = DBSession.query( Menu ).order_by( Menu.order ) > except NoResultFound: > pass > > return dict( blog = blog, menus = menus ) > > How can i get the username from the table of tg_users? > I know it's quite simple but can't find it in the tg documentation. > > Thanks in advance. > > Greetings, > > Bloeper -- 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.
