More Tools for handling roles

I'm just starting my dive into Dancer, and for my lab's purposes, I'm seeing a heavy use of roles. I'm happy to see things like require_role and require_any_role, and user_has_role and _user_roles _ will be very useful as well.

But I'm wanting to have the tools for handing account creation within the app, and while update_user seems to have most of the data points of a user handled, I am not seeing and cannot think through how to add a user role without rolling my own insert, and that sort of thing is what we're using DBIx::Class to avoid, isn't it?

So, I would like, along with user_has_role and user_roles, add_user_role and remove_user_role, hopefully working something like:

add_user_role 'bofh' , 'admin' ;
remove_user_role 'pfy' , 'helpdesk' ;

I am using the suggested users, roles, and user_roles tables.

Start by reading the existing user_has_role, user_roles, and update_user entry points and how they use the suggested users, roles, and user_roles tables through DBIx::Class. Define the behavior of add_user_role and remove_user_role for the example username and role arguments, then verify that users can gain and lose roles without a handwritten insert.