session is designed to handle this. Add a property that leverages the foreign key you defined. Then let session do the work.
http://www.sqlalchemy.org/docs/orm/tutorial.html#building-a-relationship class ModelAttribute(Base): __tablename__ ='model_attribute' id = Column(Integer,primary_key=True) confirmed = Column(Boolean,default=False, nullable=False) values = relationship(ModelAttributeValue) attr = ModelAttribute(confirmed=True) attr.values.append(ModelAttributeValue(value=1)) session.add(attr) session.commit() -- Mike Conley -- 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.