Guest User

Untitled

a guest
May 23rd, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. groups_table = sql.Table(
  2. 'groups', meta.metadata,
  3. sql.Column('id', sql.Integer, primary_key=True),
  4. sql.Column('name', sql.Unicode(50)),
  5. )
  6.  
  7. class Group(MyOrm): pass
  8.  
  9. #-----
  10.  
  11. # Association table
  12. group2group_table = sql.Table(
  13. 'group2group', meta.metadata,
  14. sql.Column('parent_id', sql.Integer, sql.ForeignKey('groups.id')),
  15. sql.Column('child_id', sql.Integer, sql.ForeignKey('groups.id')),
  16. )
  17.  
  18. #-----
  19.  
  20. # Mapper
  21. orm.mapper(Group, groups_table, properties={
  22. 'children':orm.relation(
  23. Group,
  24. primaryjoin=(groups_table.c.id==group2group_table.c.parent_id),
  25. secondaryjoin=(groups_table.c.id==group2group_table.c.child_id),
  26. secondary=group2group_table,
  27. foreign_keys=[groups_table.c.id, groups_table.c.id],
  28. ),
  29. }
  30. )
Add Comment
Please, Sign In to add comment