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
"""SQLAlchemy persistence adapter for Console app site management."""
from dataclasses import asdict
from typing import override
from sqlalchemy import ColumnElement, select
from sqlalchemy.orm import Session, sessionmaker
from libs.datetime_utils import naive_utc_now
from models.enums import AppStatus
from models.model import App, Site
from repositories.app.console_visibility import console_visible_condition
from services.app_site_service import (
AppSiteAppNotFoundError,
AppSiteChanges,
AppSiteCommandResult,
AppSiteNotFoundError,
AppSiteStore,
)
def _console_app_conditions(workspace_id: str, app_id: str) -> tuple[ColumnElement[bool], ...]:
return (
App.id == app_id,
App.tenant_id == workspace_id,
App.status == AppStatus.NORMAL,
console_visible_condition(),
)
class AppSiteCommandRepository(AppSiteStore):
def __init__(self, *, session_factory: sessionmaker[Session]) -> None:
self._session_factory = session_factory
@override
def update_site(
self,
*,
workspace_id: str,
app_id: str,
actor_id: str,
changes: AppSiteChanges,
) -> AppSiteCommandResult:
with self._session_factory.begin() as session:
site = self._get_site(session, workspace_id, app_id)
for field_name, value in asdict(changes).items():
if value is not None:
setattr(site, field_name, value)
site.updated_by = actor_id
site.updated_at = naive_utc_now()
session.flush()
return self._to_command_result(site)
@override
def reset_access_token(
self,
*,
workspace_id: str,
app_id: str,
actor_id: str,
) -> AppSiteCommandResult:
with self._session_factory.begin() as session:
site = self._get_site(session, workspace_id, app_id)
site.code = Site.generate_code(16, session=session)
site.updated_by = actor_id
site.updated_at = naive_utc_now()
session.flush()
return self._to_command_result(site)
@staticmethod
def _get_site(session: Session, workspace_id: str, app_id: str) -> Site:
site = session.scalar(
select(Site).join(App, App.id == Site.app_id).where(*_console_app_conditions(workspace_id, app_id)).limit(1)
)
if site is not None:
return site
app_exists = session.scalar(select(App.id).where(*_console_app_conditions(workspace_id, app_id)).limit(1))
if app_exists is None:
raise AppSiteAppNotFoundError
raise AppSiteNotFoundError
@staticmethod
def _to_command_result(site: Site) -> AppSiteCommandResult:
return AppSiteCommandResult(
app_id=site.app_id,
code=site.code,
title=site.title,
icon=site.icon,
icon_background=site.icon_background,
description=site.description,
default_language=site.default_language,
customize_domain=site.customize_domain,
copyright=site.copyright,
privacy_policy=site.privacy_policy,
input_placeholder=site.input_placeholder,
custom_disclaimer=site.custom_disclaimer,
customize_token_strategy=str(site.customize_token_strategy),
prompt_public=site.prompt_public,
show_workflow_steps=site.show_workflow_steps,
use_icon_as_answer_icon=site.use_icon_as_answer_icon,
)