Multi-Rag / src /service /memory /async_sql.py
VashuTheGreat2's picture
Upload folder using huggingface_hub
644f326 verified
Raw History Blame Contribute Delete
2.2 kB
import os
import aiosqlite
from typing import Optional
from langgraph.checkpoint.sqlite.aio import AsyncSqliteSaver
from langgraph.checkpoint.serde.jsonplus import JsonPlusSerializer
from src.core.logger import logger
from src.app_config import get_app_config
_checkpointer: Optional[AsyncSqliteSaver] = None
_connection: Optional[aiosqlite.Connection] = None
async def init_checkpointer(db_path: Optional[str] = None) -> AsyncSqliteSaver:
"""Initialize AsyncSqliteSaver with aiosqlite connection."""
global _checkpointer, _connection
if _checkpointer is not None and _connection is not None:
return _checkpointer
if not db_path:
config = get_app_config()
db_path = getattr(config, "checkpoint_db_path", "db/checkpoints.db")
os.makedirs(os.path.dirname(os.path.abspath(db_path)), exist_ok=True)
logger.info("Initializing AsyncSqliteSaver database connection", db_path=db_path)
_connection = await aiosqlite.connect(db_path)
_checkpointer = AsyncSqliteSaver(
_connection,
serde=JsonPlusSerializer(pickle_fallback=True),
)
await _checkpointer.setup()
logger.info("AsyncSqliteSaver checkpointer setup complete", db_path=db_path)
return _checkpointer
async def close_checkpointer() -> None:
"""Close the underlying aiosqlite connection."""
global _checkpointer, _connection
if _connection is not None:
logger.info("Closing AsyncSqliteSaver database connection")
try:
await _connection.close()
except Exception as e:
logger.error("Error while closing database connection", error=str(e))
finally:
_connection = None
_checkpointer = None
def get_checkpointer() -> Optional[AsyncSqliteSaver]:
"""Retrieve the active checkpointer instance."""
global _checkpointer
return _checkpointer
async def get_async_checkpointer(db_path: Optional[str] = None) -> AsyncSqliteSaver:
"""Async getter that ensures checkpointer is initialized before returning."""
global _checkpointer
if _checkpointer is None:
await init_checkpointer(db_path)
return _checkpointer
get_memory = get_checkpointer