rsnarsna
feat(admin): implement database-backed admin email whitelist validation and endpoints (DEC-027)
04b6a97 Download database/connection.py from Rsnarsna/auto: direct link, hf CLI and curl.
- Browser
- Download file 4.43 kB
-
https://huggingface.co/spaces/Rsnarsna/auto/resolve/main/database/connection.py
- Command line
-
hf download hf://spaces/Rsnarsna/auto/database/connection.py
-
curl -L -o connection.py https://huggingface.co/spaces/Rsnarsna/auto/resolve/main/database/connection.py
4.43 kB
| """ | |
| ALLI Backend - MongoDB Connection Manager | |
| Handles resilient MongoDB Atlas connection lifecycle, lazy connect, and collection/index setup. | |
| """ | |
| import os | |
| from datetime import datetime, timezone | |
| from typing import Optional, Any | |
| import env | |
| try: | |
| from pymongo import MongoClient | |
| from pymongo.errors import ConnectionFailure, PyMongoError | |
| PYMONGO_AVAILABLE = True | |
| except ImportError: | |
| MongoClient = None | |
| ConnectionFailure = Exception | |
| PyMongoError = Exception | |
| PYMONGO_AVAILABLE = False | |
| def get_utc_now() -> str: | |
| """Return current UTC timestamp in ISO-8601 format.""" | |
| return datetime.now(timezone.utc).isoformat() | |
| class MongoConnectionMixin: | |
| """Mixin managing MongoDB Atlas client, lazy connectivity, and indexes.""" | |
| def _init_connection(self, uri: Optional[str] = None, db_name: Optional[str] = None) -> None: | |
| self.uri = uri or os.environ.get("MONGODB_URI") or env.MONGODB_URI | |
| self.db_name = db_name or os.environ.get("MONGODB_DB_NAME") or env.MONGODB_DB_NAME | |
| self.client: Optional[Any] = None | |
| self.collection: Optional[Any] = None | |
| self.users_collection: Optional[Any] = None | |
| self._connected_attempted = False | |
| self._is_connected = False | |
| def is_connected(self) -> bool: | |
| if not self._connected_attempted: | |
| self._ensure_connected() | |
| return self._is_connected | |
| def is_connected(self, val: bool) -> None: | |
| self._connected_attempted = True | |
| self._is_connected = bool(val) | |
| def _ensure_connected(self) -> bool: | |
| if self._connected_attempted: | |
| return self._is_connected | |
| self._connected_attempted = True | |
| if PYMONGO_AVAILABLE and self.uri and MongoClient is not None: | |
| try: | |
| # Fast timeout (1500ms) so requests never block serverless invocations | |
| self.client = MongoClient( | |
| self.uri, | |
| serverSelectionTimeoutMS=1500, | |
| connectTimeoutMS=1500, | |
| ) | |
| self.client.admin.command("ping") | |
| db = self.client[self.db_name] | |
| self.collection = db["workflows"] | |
| self.users_collection = db["users"] | |
| self._ensure_indexes(db) | |
| self._is_connected = True | |
| print( | |
| f"[ALLI MongoDB] Successfully connected to database '{self.db_name}' " | |
| "(workflows, users, orgs & catalogs collections)" | |
| ) | |
| except Exception as e: | |
| print( | |
| f"[ALLI MongoDB] Connection skipped or unavailable ({str(e)}). " | |
| "Using resilient in-memory storage." | |
| ) | |
| self._is_connected = False | |
| else: | |
| self._is_connected = False | |
| return self._is_connected | |
| def _ensure_indexes(self, db: Any) -> None: | |
| """Create non-blocking background indexes across core collections.""" | |
| index_specs = [ | |
| ("users", "user_id", {"unique": True}), | |
| ("workflows", "id", {}), | |
| ("workflows", "user_id", {}), | |
| ("workflows", "org_id", {}), | |
| ("organizations", "org_id", {"unique": True}), | |
| ("organizations", "slug", {}), | |
| ("org_memberships", [("org_id", 1), ("user_id", 1)], {"unique": True}), | |
| ("org_memberships", "user_id", {}), | |
| ("audit_logs", [("org_id", 1), ("timestamp", -1)], {}), | |
| ("blueprints", "package", {}), | |
| ("node_schemas", "type", {}), | |
| ("staged_node_schemas", "node_type", {}), | |
| ("templates", "id", {}), | |
| ("plans", "id", {}), | |
| ("learning_modules", "id", {}), | |
| ("blog_posts", "slug", {}), | |
| ("admin_emails", "email", {"unique": True}), | |
| ("workspace_env_vars", [("org_id", 1), ("key", 1)], {"unique": True}), | |
| ] | |
| for col_name, keys, opts in index_specs: | |
| try: | |
| db[col_name].create_index(keys, background=True, **opts) | |
| except Exception: | |
| pass | |
| def get_collection(self, name: str) -> Optional[Any]: | |
| """Return PyMongo collection handle when connected, else None.""" | |
| if not self.is_connected or self.client is None: | |
| return None | |
| return self.client[self.db_name][name] | |