import unittest
from datetime import date
from decimal import Decimal
from unittest.mock import MagicMock, patch
from fastapi import FastAPI, Request
from fastapi.responses import HTMLResponse
from fastapi.testclient import TestClient
from app.db import get_session
from app.permissions import Principal
from app.routes import router
class ForderungNoticeTests(unittest.TestCase):
def setUp(self):
self.db = MagicMock()
self.application = FastAPI()
self.application.include_router(router)
self.application.dependency_overrides[get_session] = lambda: self.db
@self.application.middleware("http")
async def authenticated(request: Request, call_next):
request.state.principal = Principal("tester", "Tester", "", "Mitarbeiter", "ldap", "csrf", ())
return await call_next(request)
self.client = TestClient(self.application)
self.addCleanup(self.client.close)
self.detail_context_patch = patch("app.routes.get_template_context")
self.detail_context = self.detail_context_patch.start()
self.addCleanup(self.detail_context_patch.stop)
self.current = {
"Beleg_Nr": "WGG24501320",
"Beleg_Datum": date(2024, 5, 13),
"Kunde_Text": "Beispielkunde ",
"Beleg_Betrag": Decimal("1234.50"),
"Beleg_Offen": Decimal("250.00"),
}
def result(self, row=None, access=False):
result = MagicMock()
result.first.return_value = (1,) if access else None
result.mappings.return_value.first.return_value = row
return result
def get_notice(self, htmx=False):
return self.client.get("/app/forderungen/details/1_WGG24501320", headers={"HX-Request": "true"} if htmx else {})
def assert_notice(self, response):
self.assertEqual(response.status_code, 200)
self.assertIn('href="/app/forderungen/liste?focus=1_WGG24501320">Zurück zur Liste', response.text)
self.assertNotIn('id="formular"', response.text)
self.assertNotIn('name="Kommentar"', response.text)
self.detail_context.assert_not_called()
def test_open_forderung_displays_only_summary_and_skips_history(self):
self.db.execute.side_effect = [self.result(), self.result(self.current)]
response = self.get_notice()
self.assert_notice(response)
self.assertIn("Forderung WGG24501320 vom 13.05.2024 ist noch offen.", response.text)
self.assertIn("1.234,50 €", response.text)
self.assertIn("250,00 €", response.text)
self.assertIn("<script>", response.text)
self.assertNotIn("", response.text)
self.assertEqual(self.db.execute.call_count, 2)
def test_history_displays_dates_and_queries_exact_tenant_key(self):
history = {"Beleg_Nr": "WGG24501320", "Beleg_Datum": date(2024, 5, 13), "Auszifferung_Datum": date(2024, 6, 2)}
self.db.execute.side_effect = [self.result(), self.result(), self.result(history)]
response = self.get_notice(htmx=True)
self.assert_notice(response)
self.assertIn("wurde am 02.06.2024 beglichen.", response.text)
query, params = self.db.execute.call_args.args
self.assertIn("dbo.Forderungen_Historie", str(query))
self.assertIn("ORDER BY Auszifferung_Datum DESC", str(query))
self.assertEqual(params, {"client_db": "1", "beleg_nr": "WGG24501320"})
self.assertNotIn("WGG24501320", str(query))
def test_missing_entry_displays_short_message(self):
self.db.execute.side_effect = [self.result(), self.result(), self.result()]
response = self.get_notice()
self.assert_notice(response)
self.assertIn("Eintrag nicht gefunden.", response.text)
def test_null_fields_and_zero_amount_render_correctly(self):
row = dict(self.current, Beleg_Datum=None, Kunde_Text=None, Beleg_Betrag=None, Beleg_Offen=Decimal("0"))
self.db.execute.side_effect = [self.result(), self.result(row)]
response = self.get_notice()
self.assert_notice(response)
self.assertEqual(response.text.count("nicht hinterlegt"), 3)
self.assertIn("0,00 €", response.text)
def test_authorized_user_retains_existing_detail_flow(self):
self.db.execute.return_value = self.result(access=True)
self.detail_context.return_value = {"existing": "context"}
with patch("app.routes.templates.TemplateResponse", return_value=HTMLResponse("Full details")) as render:
response = self.get_notice()
self.assertEqual(response.status_code, 200)
self.assertEqual(response.text, "Full details")
self.detail_context.assert_called_once()
self.assertEqual(render.call_args.args[1], "forderungen/details/details.html")
self.db.execute.assert_called_once()
def test_database_failure_is_not_reported_as_missing(self):
self.db.execute.side_effect = [self.result(), RuntimeError("Database unavailable")]
with TestClient(self.application, raise_server_exceptions=False) as client:
response = client.get("/app/forderungen/details/1_WGG24501320")
self.assertEqual(response.status_code, 500)
self.assertNotIn("Eintrag nicht gefunden", response.text)
def test_write_file_and_export_routes_remain_denied(self):
self.db.execute.return_value = self.result()
cases = [
("post", "/app/forderungen/details/1_WGG24501320", {"data": {"source": "comments", "Kommentar": "test"}}),
("get", "/app/forderungen/files/1_WGG24501320", {}),
("get", "/files/?name=1/WGG24501320/invoice.pdf", {}),
("get", "/app/forderungen/export/1_WGG24501320/", {}),
]
for method, url, kwargs in cases:
with self.subTest(url=url):
self.db.execute.reset_mock()
response = getattr(self.client, method)(url, **kwargs)
self.assertEqual(response.status_code, 404)
self.db.execute.assert_called_once()
self.db.commit.assert_not_called()
if __name__ == "__main__":
unittest.main()