def insert_basic_data(engine):
Session = sessionmaker(engine)
session = Session()
dept = Dept(name='总部', desc='公司总部')
session.add(dept)
session.flush()
admin = User(name='admin',
password=utils.md5encode('admin'),
dept_id=dept.id)
session.add(admin)
sys_admin_role = Role('系统管理员', '系统管理员')
dept_admin_role = Role('部门管理员', '部门管理员')
user_role = Role('普通用户', '普通用户')
session.add(sys_admin_role)
session.add(dept_admin_role)
session.add(user_role)
session.flush()
membership1 = UserRoleMembership(user_id=admin.id,
role_id=sys_admin_role.id)
session.add(membership1)
session.commit()
session.close()
def insert_test_data(engine):
Session = sessionmaker(engine)
session = Session()
user1 = User(name='熊大', password=utils.md5encode('abc123'))
user2 = User(name='熊二', password=utils.md5encode('abc123'))
session.add(user1)
session.add(user2)
session.flush()
admin_role = session.query(Role).filter(Role.name=='管理员').first()
user_role = session.query(Role).filter(Role.name=='普通用户').first()
session.add(UserRoleMembership(user1.id, user_role.id))
session.add(UserRoleMembership(user2.id, user_role.id))
session.commit()
session.close()
def insert_basic_data(engine):
Session = sessionmaker(engine)
session = Session()
admin = User(name='admin', password=utils.md5encode('admin'))
session.add(admin)
admin_role = Role('管理员', '管理员')
user_role = Role('普通用户', '普通用户')
session.add(admin_role)
session.add(user_role)
session.flush()
membership1 = UserRoleMembership(user_id=admin.id,
role_id=admin_role.id)
session.add(membership1)
session.commit()
session.close()
def insert_basic_data(engine):
Session = sessionmaker(engine)
session = Session()
dept = Dept(name='总部', desc='公司总部')
session.add(dept)
session.flush()
admin = User(name='admin', password=utils.md5encode('admin'), dept_id=dept.id)
session.add(admin)
sys_admin_role = Role('系统管理员', '系统管理员')
dept_admin_role = Role('部门管理员', '部门管理员')
user_role = Role('普通用户', '普通用户')
session.add(sys_admin_role)
session.add(dept_admin_role)
session.add(user_role)
session.flush()
membership1 = UserRoleMembership(user_id=admin.id,
role_id=sys_admin_role.id)
session.add(membership1)
session.commit()
session.close()
def insert_test_data(engine):
Session = sessionmaker(engine)
session = Session()
head_dept = session.query(Dept).filter(Dept.name == '总部').first()
dept1 = Dept(name='研发部', desc='研发部', parent_id=head_dept.id)
session.add(dept1)
session.flush()
dept1_1 = Dept(name='研发一部', desc='研发一部', parent_id=dept1.id)
dept1_2 = Dept(name='研发二部', desc='研发二部', parent_id=dept1.id)
session.add(dept1_1)
session.add(dept1_2)
dept2 = Dept(name='市场部', desc='市场部', parent_id=head_dept.id)
session.add(dept2)
session.flush()
dept2_1 = Dept(name='市场一部', desc='市场一部', parent_id=dept2.id)
dept2_2 = Dept(name='市场二部', desc='市场二部', parent_id=dept2.id)
session.add(dept2_1)
session.add(dept2_2)
session.flush()
user1 = User(name='熊大',
password=utils.md5encode('abc123'),
dept_id=dept1.id)
user2 = User(name='熊二',
password=utils.md5encode('abc123'),
dept_id=dept2.id)
user3 = User(name='张三',
password=utils.md5encode('abc123'),
email='*****@*****.**',
dept_id=dept1_1.id)
user4 = User(name='李四',
password=utils.md5encode('abc123'),
email='*****@*****.**',
dept_id=dept1_2.id)
user5 = User(name='王五',
password=utils.md5encode('abc123'),
dept_id=dept2_1.id)
user6 = User(name='赵六',
password=utils.md5encode('abc123'),
dept_id=dept2_2.id)
user7 = User(name='用户1',
password=utils.md5encode('abc123'),
dept_id=dept1_1.id)
user8 = User(name='用户2',
password=utils.md5encode('abc123'),
dept_id=dept1_2.id)
user9 = User(name='用户3',
password=utils.md5encode('abc123'),
dept_id=dept1_1.id)
user10 = User(name='用户4',
password=utils.md5encode('abc123'),
dept_id=dept1_2.id)
session.add(user1)
session.add(user2)
session.add(user3)
session.add(user4)
session.add(user5)
session.add(user6)
session.add(user7)
session.add(user8)
session.add(user9)
session.add(user10)
session.flush()
sys_admin_role = session.query(Role).filter(Role.name == '系统管理员').first()
dept_admin_role = session.query(Role).filter(Role.name == '部门管理员').first()
user_role = session.query(Role).filter(Role.name == '普通用户').first()
session.add(UserRoleMembership(user1.id, dept_admin_role.id))
session.add(UserRoleMembership(user2.id, dept_admin_role.id))
session.add(UserRoleMembership(user3.id, dept_admin_role.id))
session.add(UserRoleMembership(user4.id, dept_admin_role.id))
session.add(UserRoleMembership(user5.id, dept_admin_role.id))
session.add(UserRoleMembership(user6.id, dept_admin_role.id))
session.add(UserRoleMembership(user7.id, user_role.id))
session.add(UserRoleMembership(user8.id, user_role.id))
session.add(UserRoleMembership(user9.id, user_role.id))
session.add(UserRoleMembership(user10.id, user_role.id))
session.flush()
session.add(
Permission(path='^/depts$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/depts/.*', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/depts$', role_id=sys_admin_role.id, method='POST'))
session.add(
Permission(path='^/depts/.*', role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/depts/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/depts$', role_id=dept_admin_role.id, method='GET'))
session.add(
Permission(path='^/depts/.*', role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/depts$', role_id=dept_admin_role.id, method='POST'))
session.add(
Permission(path='^/depts/.*',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/depts/.*',
role_id=dept_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/roles$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/roles$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/roles$', role_id=user_role.id,
method='GET'))
session.add(
Permission(path='^/users$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/users/.*', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/users$', role_id=sys_admin_role.id, method='POST'))
session.add(
Permission(path='^/users/.*', role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/users/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/users$', role_id=dept_admin_role.id, method='GET'))
session.add(
Permission(path='^/users/.*', role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/users$', role_id=dept_admin_role.id, method='POST'))
session.add(
Permission(path='^/users/.*',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/users/.*',
role_id=dept_admin_role.id,
method='DELETE'))
session.add(Permission(path='^/users$', role_id=user_role.id,
method='GET'))
session.add(
Permission(path='^/users/.*', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/flavors$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/flavors$', role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/flavors$', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/flavors$', role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/flavors/.*',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/flavors/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/servers$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/servers$', role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/servers$', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/servers/.*',
role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/servers/.*',
role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/servers/.*', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/servers$', role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/servers$',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/servers$', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/servers/.*',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/servers/.*',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/servers/.*', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/servers/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/servers/.*',
role_id=dept_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/servers/.*', role_id=user_role.id, method='DELETE'))
session.add(
Permission(path='^/volumes$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/volumes$', role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/volumes$', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/volumes/.*',
role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/volumes/.*',
role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/volumes/.*', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/volumes$', role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/volumes$',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/volumes$', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/volumes/.*',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/volumes/.*',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/volumes/.*', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/volumes/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/volumes/.*',
role_id=dept_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/volumes/.*', role_id=user_role.id, method='DELETE'))
session.add(
Permission(path='^/snapshots$',
role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/snapshots$',
role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/snapshots$', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/snapshots/.*',
role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/snapshots/.*',
role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/snapshots/.*', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/snapshots$',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/snapshots$',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/snapshots$', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/snapshots/.*',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/snapshots/.*',
role_id=dept_admin_role.id,
method='POST'))
session.add(
Permission(path='^/snapshots/.*', role_id=user_role.id, method='POST'))
session.add(
Permission(path='^/snapshots/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/snapshots/.*',
role_id=dept_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/snapshots/.*',
role_id=user_role.id,
method='DELETE'))
session.add(
Permission(path='^/images$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/images$', role_id=dept_admin_role.id, method='GET'))
session.add(
Permission(path='^/images$', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/images/.*', role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/images/.*',
role_id=dept_admin_role.id,
method='GET'))
session.add(
Permission(path='^/images/.*', role_id=user_role.id, method='GET'))
session.add(
Permission(path='^/images$', role_id=sys_admin_role.id, method='POST'))
session.add(
Permission(path='^/images/.*',
role_id=sys_admin_role.id,
method='POST'))
session.add(
Permission(path='^/images/.*',
role_id=sys_admin_role.id,
method='DELETE'))
session.add(
Permission(path='^/hypervisors$',
role_id=sys_admin_role.id,
method='GET'))
session.add(
Permission(path='^/hosts$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/logs$', role_id=sys_admin_role.id, method='GET'))
session.add(
Permission(path='^/monitor/.*',
role_id=sys_admin_role.id,
method='GET'))
session.commit()
session.close()
def insert_test_data(engine):
Session = sessionmaker(engine)
session = Session()
head_dept = session.query(Dept).filter(Dept.name=='总部').first()
dept1 = Dept(name='研发部', desc='研发部', parent_id=head_dept.id)
session.add(dept1)
session.flush()
dept1_1 = Dept(name='研发一部', desc='研发一部', parent_id=dept1.id)
dept1_2 = Dept(name='研发二部', desc='研发二部', parent_id=dept1.id)
session.add(dept1_1)
session.add(dept1_2)
dept2 = Dept(name='市场部', desc='市场部', parent_id=head_dept.id)
session.add(dept2)
session.flush()
dept2_1 = Dept(name='市场一部', desc='市场一部', parent_id=dept2.id)
dept2_2 = Dept(name='市场二部', desc='市场二部', parent_id=dept2.id)
session.add(dept2_1)
session.add(dept2_2)
session.flush()
user1 = User(name='熊大', password=utils.md5encode('abc123'), dept_id=dept1.id)
user2 = User(name='熊二', password=utils.md5encode('abc123'), dept_id=dept2.id)
user3 = User(name='张三', password=utils.md5encode('abc123'),
email='*****@*****.**', dept_id=dept1_1.id)
user4 = User(name='李四', password=utils.md5encode('abc123'),
email='*****@*****.**', dept_id=dept1_2.id)
user5 = User(name='王五', password=utils.md5encode('abc123'), dept_id=dept2_1.id)
user6 = User(name='赵六', password=utils.md5encode('abc123'), dept_id=dept2_2.id)
user7 = User(name='用户1', password=utils.md5encode('abc123'), dept_id=dept1_1.id)
user8 = User(name='用户2', password=utils.md5encode('abc123'), dept_id=dept1_2.id)
user9 = User(name='用户3', password=utils.md5encode('abc123'), dept_id=dept1_1.id)
user10 = User(name='用户4', password=utils.md5encode('abc123'), dept_id=dept1_2.id)
session.add(user1)
session.add(user2)
session.add(user3)
session.add(user4)
session.add(user5)
session.add(user6)
session.add(user7)
session.add(user8)
session.add(user9)
session.add(user10)
session.flush()
sys_admin_role = session.query(Role).filter(Role.name=='系统管理员').first()
dept_admin_role = session.query(Role).filter(Role.name=='部门管理员').first()
user_role = session.query(Role).filter(Role.name=='普通用户').first()
session.add(UserRoleMembership(user1.id, dept_admin_role.id))
session.add(UserRoleMembership(user2.id, dept_admin_role.id))
session.add(UserRoleMembership(user3.id, dept_admin_role.id))
session.add(UserRoleMembership(user4.id, dept_admin_role.id))
session.add(UserRoleMembership(user5.id, dept_admin_role.id))
session.add(UserRoleMembership(user6.id, dept_admin_role.id))
session.add(UserRoleMembership(user7.id, user_role.id))
session.add(UserRoleMembership(user8.id, user_role.id))
session.add(UserRoleMembership(user9.id, user_role.id))
session.add(UserRoleMembership(user10.id, user_role.id))
session.flush()
session.add(Permission(path='^/depts$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/depts/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/depts$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/depts/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/depts/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/depts$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/depts/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/depts$', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/depts/.*', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/depts/.*', role_id=dept_admin_role.id, method='DELETE'))
session.add(Permission(path='^/roles$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/roles$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/roles$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/users$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/users/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/users$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/users/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/users/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/users$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/users/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/users$', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/users/.*', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/users/.*', role_id=dept_admin_role.id, method='DELETE'))
session.add(Permission(path='^/users$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/users/.*', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/flavors$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/flavors$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/flavors$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/flavors$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/flavors/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/flavors/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/servers$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/servers$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/servers$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/servers/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/servers/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/servers/.*', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/servers$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/servers$', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/servers$', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/servers/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/servers/.*', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/servers/.*', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/servers/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/servers/.*', role_id=dept_admin_role.id, method='DELETE'))
session.add(Permission(path='^/servers/.*', role_id=user_role.id, method='DELETE'))
session.add(Permission(path='^/volumes$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/volumes$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/volumes$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/volumes/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/volumes/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/volumes/.*', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/volumes$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/volumes$', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/volumes$', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/volumes/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/volumes/.*', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/volumes/.*', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/volumes/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/volumes/.*', role_id=dept_admin_role.id, method='DELETE'))
session.add(Permission(path='^/volumes/.*', role_id=user_role.id, method='DELETE'))
session.add(Permission(path='^/snapshots$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/snapshots$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/snapshots$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/snapshots/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/snapshots/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/snapshots/.*', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/snapshots$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/snapshots$', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/snapshots$', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/snapshots/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/snapshots/.*', role_id=dept_admin_role.id, method='POST'))
session.add(Permission(path='^/snapshots/.*', role_id=user_role.id, method='POST'))
session.add(Permission(path='^/snapshots/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/snapshots/.*', role_id=dept_admin_role.id, method='DELETE'))
session.add(Permission(path='^/snapshots/.*', role_id=user_role.id, method='DELETE'))
session.add(Permission(path='^/images$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/images$', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/images$', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/images/.*', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/images/.*', role_id=dept_admin_role.id, method='GET'))
session.add(Permission(path='^/images/.*', role_id=user_role.id, method='GET'))
session.add(Permission(path='^/images$', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/images/.*', role_id=sys_admin_role.id, method='POST'))
session.add(Permission(path='^/images/.*', role_id=sys_admin_role.id, method='DELETE'))
session.add(Permission(path='^/hypervisors$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/hosts$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/logs$', role_id=sys_admin_role.id, method='GET'))
session.add(Permission(path='^/monitor/.*', role_id=sys_admin_role.id, method='GET'))
session.commit()
session.close()