app/service/income_statement.py

from app.schema.index import IncomeStatementCreate
from app.model.transaction import Transaction as TransactionModel
from app.model.income_statement import IncomeStatement as IncomeStatementModel
from sqlalchemy.ext.asyncio import AsyncSession


async def call_llm_to_create_income_statement(payload: IncomeStatementCreate, db: AsyncSession) -> None:
    transactions = await TransactionModel.get_by_user_between_dates(
        db, payload.user_id, payload.date_from, payload.date_to
    )

    # TODO: Call LLM to generate income and expenses
    income = {}
    expenses = {}
    await IncomeStatementModel.create(db, **payload, income=income, expenses=expenses)