Advertisement
Guest User

Untitled

a guest
Jan 27th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. class User(UserMixin, SurrogatePK, Model):
  2. __tablename__ = 'users'
  3. id = Column(db.Integer, primary_key=True, index=True)
  4. username = Column(db.String(80), unique=True, nullable=False)
  5. email = Column(db.String(80), unique=False, nullable=False)
  6. password = Column(db.String(128), nullable=True)
  7. departments = relationship("Department",secondary="user_department_relationship_table", back_populates="users")
  8.  
  9. user_department_relationship_table=db.Table('user_department_relationship_table',
  10. db.Column('department_id', db.Integer,db.ForeignKey('departments.id'), nullable=False),
  11. db.Column('user_id',db.Integer,db.ForeignKey('users.id'),nullable=False),
  12. db.PrimaryKeyConstraint('department_id', 'user_id') )
  13.  
  14.  
  15. class Department(SurrogatePK, Model):
  16. __tablename__ = 'departments'
  17. id = Column(db.Integer, primary_key=True, index=True)
  18. name = Column(db.String(80), unique=True, nullable=False)
  19. short_name = Column(db.String(80), unique=True, nullable=False)
  20. invite_codes = relationship("Invite_Code", backref="department")
  21. users = relationship("User", secondary=user_department_relationship_table,back_populates="departments")
  22.  
  23. from cpt import (
  24. public, user, department
  25. )
  26.  
  27. ...
  28.  
  29.  
  30. def register_blueprints(app):
  31. app.register_blueprint(public.views.blueprint)
  32. app.register_blueprint(user.views.blueprint)
  33. app.register_blueprint(department.views.blueprint)
  34. return None
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement