Create backend logic to create new roles

[jeff1evesque]

Based on our #3208, we need to adjust necessary back python logic, to incorporate the following:

New Role: create a new role type, owned by current user.

INSERT INTO RoleType (RoleType) VALUES (‘new-role’);
INSERT INTO Role (RoleOwner, RoleTypeID, UserID)
SELECT ‘1’, RoleType.RoleTypeID, Account.UserID
FROM Account
OUTER JOIN RoleType ON RoleType.RoleType = ‘new-role’
WHERE Account.Username = ‘current-user’

The above implementation will likely occur in the applications backend code.

query = '''\

        INSERT INTO RoleType (RoleType) VALUES (%s);

        '''
args = (role_type)
cur.execute(query, args)


query = '''\

        INSERT INTO Role (RoleOwner, RoleTypeID, UserID)
        SELECT %s, RoleType.RoleTypeID, Account.UserID
        FROM Account
        OUTER JOIN RoleType ON RoleType.RoleType = %s
        WHERE Account.Username = %s

        '''
args = (role_owner, role_type, username)
cur.execute(query, args)