blob: 36f3c09282bd99012953d95f6b99677321ac2d8a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
"""Major function for handling admin users."""
from gn_auth.auth.db import sqlite3 as db
from gn_auth.auth.authentication.users import User
def make_sys_admin(cursor: db.DbCursor, user: User) -> User:
"""Make a given user into an system admin."""
cursor.execute(
"SELECT * FROM roles WHERE role_name='system-administrator'")
admin_role = cursor.fetchone()
cursor.execute(
"SELECT * FROM resources AS r "
"INNER JOIN resource_categories AS rc "
"ON r.resource_category_id=rc.resource_category_id "
"WHERE resource_category_key='system'")
the_system = cursor.fetchone()
cursor.execute(
"INSERT INTO user_roles VALUES (:user_id, :role_id, :resource_id)",
{
"user_id": str(user.user_id),
"role_id": admin_role["role_id"],
"resource_id": the_system["resource_id"]
})
return user
|
