Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. .filter(
  2. User.city == current_user.city,
  3. User.propertys.any(Property.name.in_(['Лид', 'Контакт'])),
  4. ~User.contacted.any(),
  5. User.contacted.any(User.id == current_user.id))
  6.  
  7. contacts_users = db.Table('contacts_users',
  8. db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
  9. db.Column('contact_id', db.Integer, db.ForeignKey('user.id'))
  10. )
  11.  
  12. class Address(Base):
  13. name = db.Column(db.String(50), unique=True)
  14. index = db.Column(db.String(50))
  15. city = db.Column(db.ForeignKey('city.id'))
  16.  
  17.  
  18. class City(Base):
  19. name = db.Column(db.String(50))
  20. country = db.Column(db.ForeignKey('country.id'))
  21. addresses = db.relationship('Address',
  22. backref=db.backref('city'))
  23.  
  24. class User(Base, UserMixin):
  25.  
  26. first_name = db.Column(db.String(255))
  27. last_name = db.Column(db.String(255))
  28. ...
  29. adresses = db.relationship('Address', secondary=addresses_users,
  30. backref=db.backref('users'))
  31. contacts = relationship(
  32. 'User', lambda: contacts_users,
  33. primaryjoin=lambda: User.id == contacts_users.c.user_id,
  34. secondaryjoin=lambda: User.id == contacts_users.c.contact_id,
  35. backref='contacted'
  36. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement