def insert_roles(): roles = { 'user': ['post_comment'], 'moderator': [ 'post_comment', 'write_articles', 'manage_comments', 'manage_articles', 'manage_users', ] } permissions_map = {p.name: p for p in Permission.query} for role, permissions in roles.items(): ur = Role.query.filter_by(name=role).first() if ur is None: r = Role() for p in permissions: r.permissions.append(permissions_map.get(p)) r.name = role db.session.add(r) db.session.commit()