Open-source personal finance manager. Self-hosted, privacy-first.
import uuid
from datetime import date
from typing import Optional
from fastapi import APIRouter, Depends, HTTPException, Query, status
from sqlalchemy.ext.asyncio import AsyncSession
from app.core.database import get_async_session
from app.core.workspace_context import (
WorkspaceContext,
current_workspace,
current_writable_workspace,
)
from app.schemas.budget import (
BudgetBatchCreate,
BudgetCreate,
BudgetRead,
BudgetSuggestionResponse,
BudgetUpdate,
BudgetVsActual,
)
from app.services import budget_service
router = APIRouter(prefix="/api/budgets", tags=["budgets"])
@router.get("", response_model=list[BudgetRead])
async def list_budgets(
month: Optional[date] = Query(None),
ctx: WorkspaceContext = Depends(current_workspace),
session: AsyncSession = Depends(get_async_session),
):
return await budget_service.get_budgets(session, ctx.workspace.id, month)
@router.post("", response_model=BudgetRead, status_code=status.HTTP_201_CREATED)
async def create_budget(
data: BudgetCreate,
ctx: WorkspaceContext = Depends(current_writable_workspace),
session: AsyncSession = Depends(get_async_session),
):
try:
return await budget_service.create_budget(session, ctx.workspace.id, ctx.user_id, data)
except Exception as e:
raise HTTPException(status_code=status.HTTP_400_BAD_REQUEST, detail=str(e))
@router.post(
"/batch", response_model=list[BudgetRead], status_code=status.HTTP_201_CREATED
)
async def create_budgets_batch(
data: BudgetBatchCreate,
ctx: WorkspaceContext = Depends(current_writable_workspace),
session: AsyncSession = Depends(get_async_session),
):
try:
return await budget_service.create_budgets_batch(
session, ctx.workspace.id, ctx.user_id, data
)
except ValueError as e:
raise HTTPException(status_code=status.HTTP_400_BAD_REQUEST, detail=str(e))
@router.get("/suggestions", response_model=BudgetSuggestionResponse)
async def budget_suggestions(
month: Optional[date] = Query(None),
months: int = Query(3, ge=1, le=24),
ctx: WorkspaceContext = Depends(current_workspace),
session: AsyncSession = Depends(get_async_session),
):
return await budget_service.get_budget_suggestions(
session, ctx.workspace.id, ctx.user_id, month, months
)
@router.patch("/{budget_id}", response_model=BudgetRead)
async def update_budget(
budget_id: uuid.UUID,
data: BudgetUpdate,
ctx: WorkspaceContext = Depends(current_writable_workspace),
session: AsyncSession = Depends(get_async_session),
):
budget = await budget_service.update_budget(session, budget_id, ctx.workspace.id, data)
if not budget:
raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Budget not found")
return budget
@router.delete("/{budget_id}", status_code=status.HTTP_204_NO_CONTENT)
async def delete_budget(
budget_id: uuid.UUID,
ctx: WorkspaceContext = Depends(current_writable_workspace),
session: AsyncSession = Depends(get_async_session),
):
deleted = await budget_service.delete_budget(session, budget_id, ctx.workspace.id)
if not deleted:
raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Budget not found")
@router.get("/comparison", response_model=list[BudgetVsActual])
async def budget_comparison(
month: Optional[date] = Query(None),
ctx: WorkspaceContext = Depends(current_workspace),
session: AsyncSession = Depends(get_async_session),
):
return await budget_service.get_budget_vs_actual(session, ctx.workspace.id, ctx.user_id, month)