Skip to content

Open-source personal finance manager. Self-hosted, privacy-first.

3.3 KB
Raw Blame
"""Running balance (#1202) on real PostgreSQL: the window and the daily series."""
import uuid
from datetime import date, datetime, timedelta, timezone
from decimal import Decimal

import pytest
import pytest_asyncio
from httpx import ASGITransport, AsyncClient

from app.core.database import get_async_session
from app.main import app
from app.models.account import Account
from app.models.category import Category
from app.models.transaction import Transaction

pytestmark = pytest.mark.asyncio


@pytest_asyncio.fixture
async def session(postgres_sessions):
    async with postgres_sessions() as session:
        yield session
        await session.rollback()


@pytest.fixture
def clean_db(postgres_sessions):
    """The reused user/data fixtures start in a fresh per-test PostgreSQL schema."""


@pytest_asyncio.fixture
async def client(postgres_sessions, monkeypatch):
    async def pg_session():
        async with postgres_sessions() as session:
            yield session

    monkeypatch.setitem(app.dependency_overrides, get_async_session, pg_session)
    async with AsyncClient(transport=ASGITransport(app=app), base_url="http://test") as client:
        yield client


async def test_running_balance_list_and_series_agree(client, auth_headers, session, test_user):
    account = Account(
        id=uuid.uuid4(), user_id=test_user.id, name="Running PG", type="checking",
        balance=Decimal("0"), currency="BRL",
    )
    ignored = Category(id=uuid.uuid4(), user_id=test_user.id, name="Ignored", is_ignored=True)
    session.add_all([account, ignored])
    await session.commit()
    created = datetime(2026, 1, 1, tzinfo=timezone.utc)
    for offset, (amount, txn_type, day, extra) in enumerate([
        ("1000", "credit", date(2026, 1, 20), {"source": "opening_balance"}),
        ("200", "credit", date(2026, 2, 2), {}),
        ("50", "debit", date(2026, 2, 5), {"status": "pending"}),
        ("30", "debit", date(2026, 2, 5), {"category_id": ignored.id}),
        ("400", "debit", date(2026, 2, 20), {}),
    ]):
        session.add(Transaction(
            id=uuid.uuid4(), user_id=test_user.id, account_id=account.id,
            description=f"{txn_type} {amount}", amount=Decimal(amount), currency="BRL",
            type=txn_type, date=day, source=extra.pop("source", "manual"),
            created_at=created + timedelta(seconds=offset), **extra,
        ))
    await session.commit()
    range_params = {"from": "2026-02-01", "to": "2026-02-28"}

    pages = []
    for page in (1, 2):
        response = await client.get("/api/transactions", params={
            "account_id": str(account.id), "include_running_balance": "true",
            "include_opening_balance": "true", "limit": 2, "page": page, **range_params,
        }, headers=auth_headers)
        assert response.status_code == 200, response.text
        pages += response.json()["items"]
    series = await client.get(
        f"/api/accounts/{account.id}/running-balance", params=range_params, headers=auth_headers,
    )

    assert [tx["running_balance"] for tx in pages] == [750, 1150, 1150, 1200]
    assert series.status_code == 200, series.text
    points = series.json()
    assert len(points) == 28
    assert points[0]["balance"] == 1000
    assert points[4]["balance"] == 1150
    assert points[-1]["balance"] == pages[0]["running_balance"]