auto / database /connection.py
rsnarsna
feat(admin): implement database-backed admin email whitelist validation and endpoints (DEC-027)
04b6a97
Raw History Blame Contribute Delete
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
@property
def is_connected(self) -> bool:
if not self._connected_attempted:
self._ensure_connected()
return self._is_connected
@is_connected.setter
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]