Build Agentic workflows, RAG pipelines, with rich AI model and tool support on one collaborative workspace. Deploy on cloud, VPC, or self-hosted, so teams move from prototype to production without rebuilding the stack.
Python agentagentic-aiagentic-frameworkagentic-workflowaiautomationclaudedeepseekgenaigptllmlow-codemcpnextjsno-codeopenaipythonskillsworkflow
"""Database repository for web-app access queries."""
from typing import override
from uuid import UUID
from sqlalchemy import select
from sqlalchemy.exc import DBAPIError, TimeoutError
from sqlalchemy.orm import Session, sessionmaker
from core.app.public_runtime import published_app_filter
from models.enums import AppStatus
from models.model import App, EndUser, Site
from services.entities.authentication_entities import WebAppSessionRecord
from services.web_authentication_service import WebAppSessionQuery
from services.webapp_access_query_service import WebAppAccessQuery, WebAppAccessUnavailableError
class WebAppAccessQueryRepository(WebAppAccessQuery, WebAppSessionQuery):
def __init__(self, *, session_factory: sessionmaker[Session]) -> None:
self._session_factory = session_factory
@override
def find_app_id_by_code(self, app_code: str) -> str | None:
try:
with self._session_factory() as session:
app_id = session.scalar(
select(App.id)
.join(Site, Site.app_id == App.id)
.where(
Site.code == app_code,
Site.status == AppStatus.NORMAL,
App.status == AppStatus.NORMAL,
App.enable_site.is_(True),
published_app_filter(),
)
.limit(1)
)
return app_id if app_id is not None else None
except (DBAPIError, TimeoutError) as e:
raise WebAppAccessUnavailableError from e
@override
def is_app_available(self, app_id: str) -> bool:
try:
canonical_id = str(UUID(app_id))
except ValueError:
return False
try:
with self._session_factory() as session:
return (
session.scalar(
select(App.id)
.join(Site, Site.app_id == App.id)
.where(
App.id == canonical_id,
Site.status == AppStatus.NORMAL,
App.status == AppStatus.NORMAL,
App.enable_site.is_(True),
published_app_filter(),
)
.limit(1)
)
is not None
)
except (DBAPIError, TimeoutError) as e:
raise WebAppAccessUnavailableError from e
@override
def find_active_session(
self,
*,
app_id: str,
app_code: str,
end_user_id: str,
) -> WebAppSessionRecord | None:
stmt = (
select(EndUser.session_id)
.select_from(Site)
.join(App, App.id == Site.app_id)
.join(EndUser, EndUser.app_id == App.id)
.where(
Site.code == app_code,
App.id == app_id,
App.enable_site.is_(True),
EndUser.id == end_user_id,
EndUser.tenant_id == App.tenant_id,
)
.limit(1)
)
try:
with self._session_factory() as session:
session_id = session.scalar(stmt)
if session_id is None:
return None
return WebAppSessionRecord(end_user_session_id=session_id)
except (DBAPIError, TimeoutError) as e:
raise WebAppAccessUnavailableError from e