My *model* is like this:

__init__.py:

from projects.model.auth import User
from projects.model.main import Company

auth.py:

class User(DeclarativeBase):
    company_id = Column('company_id', Integer, ForeignKey('company.id'))
# many-to-one

main.py:

class Company(DeclarativeBase):
    id = Column(Integer, primary_key=True)
    name = Column(Unicode(200), nullable=False)
    users = relation('User') # one-to-many

My *template* contains:

${user.company.name}

This throws the following error:

UndefinedError: <User...> has no member named "company"

I know User.company doesn't exist.  But how can I make it exist in the
model so that ${user.company} returns a Company object rather than just
a primary key value from the database?  In other words, what is the
right syntax to get ${user.company.name} to display the company name in
the template?  I've tried variations of backref=... but haven't been
able to get it right.

Tim

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to