aboutsummaryrefslogtreecommitdiff
path: root/gn3/auth/authorisation/roles.py
diff options
context:
space:
mode:
Diffstat (limited to 'gn3/auth/authorisation/roles.py')
-rw-r--r--gn3/auth/authorisation/roles.py7
1 files changed, 4 insertions, 3 deletions
diff --git a/gn3/auth/authorisation/roles.py b/gn3/auth/authorisation/roles.py
index 7c33ab3..8435c40 100644
--- a/gn3/auth/authorisation/roles.py
+++ b/gn3/auth/authorisation/roles.py
@@ -33,9 +33,10 @@ def create_role(
cursor.execute(
"INSERT INTO roles(role_id, role_name) VALUES (?, ?)",
- (role.role_id, role.role_name))
- cursor.execute(
+ (str(role.role_id), role.role_name))
+ cursor.executemany(
"INSERT INTO role_privileges(role_id, privilege_id) VALUES (?, ?)",
- ((role.role_id, priv.privilege_id) for priv in privileges))
+ tuple((str(role.role_id), str(priv.privilege_id))
+ for priv in privileges))
return role