1from src import db 

2from src.utils import GUID 

3 

4RolePermissionModel = db.Table("role_permission", 

5 db.Column("role_id", db.Integer, db.ForeignKey( 

6 "role.role_id"), primary_key=True), 

7 db.Column("permission", db.String(45), db.ForeignKey( 

8 "permission.permission"), primary_key=True) 

9 ) 

10 

11class RoleModel(db.Model): 

12 """ 

13 Role Model for storing different roles 

14 """ 

15 __tablename__ = "role" 

16 

17 role_id = db.Column(db.Integer, primary_key=True, 

18 autoincrement=True, nullable=False) 

19 name = db.Column(db.String(45)) 

20 

21 permission = db.relationship( 

22 "PermissionModel", secondary=RolePermissionModel, lazy="dynamic") 

23 

24class PermissionModel(db.Model): 

25 """ 

26 Permission Model for storing all role's permission 

27 """ 

28 __tablename__ = "permission" 

29 

30 permission = db.Column(db.String(45), primary_key=True, nullable=False) 

31 

32