()
| 210 | |
| 211 | |
| 212 | def _load_profiles() -> Dict[str, Dict[str, Any]]: |
| 213 | conn = db_ops.get_connection() |
| 214 | rows = conn.execute("SELECT user_id, profile_json FROM profiles ORDER BY user_id").fetchall() |
| 215 | conn.close() |
| 216 | result: Dict[str, Dict[str, Any]] = {} |
| 217 | for row in rows: |
| 218 | result[str(row["user_id"])] = json.loads(row["profile_json"]) |
| 219 | return result |
| 220 | |
| 221 | |
| 222 | def _load_roles() -> Dict[str, Dict[str, Any]]: |