Advertisement
Guest User

Untitled

a guest
Nov 21st, 2020
16
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. web_project_client = Table('web_project_client', Base.metadata,
  2. Column('web_project_id', Integer, ForeignKey('web_projects.id', ondelete='CASCADE', onupdate='CASCADE')),
  3. Column('client_id', Integer, ForeignKey('clients.id', ondelete='CASCADE', onupdate='CASCADE')),
  4. )
  5.  
  6. class WebProject(Base):
  7. __tablename__ = 'web_projects'
  8. id = Column(Integer, primary_key=True)
  9. metrics = relationship("MetricsJSON", backref="web_project")
  10. ...
  11. clients = relationship('Client',
  12. secondary=web_project_client,
  13. backref=backref('web_projects', lazy='dynamic'),
  14. lazy='dynamic'
  15. )
  16. ...
  17.  
  18. class Client(Base):
  19. __tablename__ = 'clients'
  20. id = Column(Integer, primary_key=True)
  21. ...
  22. metrics = relationship("MetricsJSON", backref="client", lazy='dynamic')
  23. ...
  24.  
  25. class MetricsJSON(Base):
  26. __tablename__ = 'metrics_json'
  27. id = Column(Integer, primary_key = True)
  28. metrics = Column(JSONB)
  29.  
  30. timestamp = Column(DateTime, default=datetime.utcnow())
  31.  
  32. web_project_id = Column(Integer, ForeignKey('web_projects.id'))
  33. client_id = Column(Integer, ForeignKey('clients.id'))
  34. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement