Hello,

I have difficulties building an *-* relationship on the same table.

#
# products <-> products
#
products_products = schema.Table('products_products', Base.metadata,
    schema.Column('id_productA', types.Integer, 
schema.ForeignKey('products.id_product'), primary_key=True),
    schema.Column('id_productB', types.Integer, 
schema.ForeignKey('products.id_product'), primary_key=True),
)

class Product(Base):
    __tablename__ = 'products'
   
    #
    # attributes
    #
    id_product =  schema.Column('id_product', types.Integer, 
schema.Sequence('seq_id_product', optional=True), primary_key=True)
    ...
    substitute = orm.relation('Product', secondary=products_products)

This leads to:
Could not determine join condition between parent/child tables on 
relation Product.substitute.

Where is my mistake ?
Thanks for your help.

Thomas



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" 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/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to