Your definition implies that there is an one-to-many relationship between Component and Version. So you can do:
> c1.version = v1 Or the other way around: > v1.user.append(c1) Am Donnerstag, 14. Februar 2013 19:50:04 UTC+1 schrieb andrew b: > > > > On Wednesday, February 13, 2013 3:48:28 PM UTC-5, Christoph Zwerschke > wrote: >> >> Am 13.02.2013 21:26, schrieb andrew b: >> > So I see how you can access the columns in one of your model objects. >> > For example ObjectQuery.user_name to get the user_name attribute from >> > that query object. But how do I use the relationships that I setup in >> my >> > model classes? I made a class definition where I join two tables(and it >> > worked fine, but seems wasteful if there's a better way), because I >> > couldn't figure out how to access the relation from the table below. >> >> You should use the ForeignKey construct. Have a look at the SQLAlchemy >> docs here, they explain it very well: >> >> http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#building-a-relationship >> >> >> -- Christoph >> > > > Hey thanks, I've looked at that before. But everytime I try to use the > Object.relationship it gives me a NoneType error says I can't append to it > etc. Maybe I'm doing something incorrectly. Here's another example of what > I'm trying to do. > > CODE IN MY ROOT CONTROLLER: > c1 = Component() > v1 = Version() > c1.version.append(v1) > > print c1.version > > > CODE IN MY MODEL: > class Component(DeclarativeBase): > __tablename__ = 'component' > > __table_args__ = {} > > #column definitions > component_pk = Column(u'component_pk', INTEGER(), primary_key=True, > nullable=False) > version_id = Column(u'version_id', INTEGER(), > ForeignKey('version.version_id'), nullable=False) > > #relation definitions > version = relation('Version', > primaryjoin='Component.version_id==Version.version_id', backref="user") > images = relation('Image', > primaryjoin='Component.component_pk==component_has_image.c.component_component_pk', > > secondary=component_has_image, > secondaryjoin='component_has_image.c.image_image_pk==Image.image_pk') > parts = relation('Part', > primaryjoin='Component.component_pk==component_has_part.c.component_component_pk', > > secondary=component_has_part, > secondaryjoin='component_has_part.c.part_part_pk==Part.part_pk') > > class Version(DeclarativeBase): > __tablename__ = 'version' > > __table_args__ = {} > > #column definitions > object_type = Column(u'object_type', VARCHAR(length=45)) > version_id = Column(u'version_id', INTEGER(), primary_key=True, > nullable=False) > version_name = Column(u'version_name', VARCHAR(length=45)) > #relation definitions > > -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/turbogears?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
