mia-accounting/tests/test_report.py

# The Mia! Accounting Project.
# Author: imacat@mail.imacat.idv.tw (imacat), 2023/4/9

#  Copyright (c) 2023 imacat.
#
#  Licensed under the Apache License, Version 2.0 (the "License");
#  you may not use this file except in compliance with the License.
#  You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.
"""The test for the reports.

"""
import datetime as dt
import unittest

import httpx
from flask import Flask

from test_site.lib import BaseTestData
from testlib import create_test_app, get_client, get_csrf_token, Accounts

PREFIX: str = "/accounting"
"""The URL prefix for the reports."""
CSV_MIME: str = "text/csv; charset=utf-8"
"""The MIME type of the downloaded CSV files."""


class ReportTestCase(unittest.TestCase):
    """The report test case."""

    def setUp(self) -> None:
        """Sets up the test.
        This is run once per test.

        :return: None.
        """
        self.__app: Flask = create_test_app()
        """The Flask application."""

        with self.__app.app_context():
            from accounting.models import JournalEntry, JournalEntryLineItem
            JournalEntry.query.delete()
            JournalEntryLineItem.query.delete()

        self.__client: httpx.Client = get_client(self.__app, "editor")
        """The user client."""
        self.__csrf_token: str = get_csrf_token(self.__client)
        """The CSRF token."""

    def test_nobody(self) -> None:
        """Test the permission as nobody.

        :return: None.
        """
        client: httpx.Client = get_client(self.__app, "nobody")
        ReportTestData(self.__app, "editor").populate()
        response: httpx.Response

        response = client.get(PREFIX)
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/journal")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/journal?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/ledger")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/ledger?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/income-expenses")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/income-expenses?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/trial-balance")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/trial-balance?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/income-statement")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/income-statement?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/balance-sheet")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/balance-sheet?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/unapplied")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/unapplied?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/unmatched")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/unmatched?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/search?q=Salary")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/search?q=Salary&as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/search?q=薪水")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/search?q=薪水&as=csv")
        self.assertEqual(response.status_code, 403)

    def test_viewer(self) -> None:
        """Test the permission as viewer.

        :return: None.
        """
        client: httpx.Client = get_client(self.__app, "viewer")
        ReportTestData(self.__app, "editor").populate()
        response: httpx.Response

        response = client.get(PREFIX)
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/journal")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/journal?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/ledger")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/ledger?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/income-expenses")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/income-expenses?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/trial-balance")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/trial-balance?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/income-statement")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/income-statement?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/balance-sheet")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/balance-sheet?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/unapplied")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/unapplied?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 200)

        response = client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/unmatched")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/unmatched?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 403)

        response = client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 403)

        response = client.get(f"{PREFIX}/search?q=Salary")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/search?q=Salary&as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = client.get(f"{PREFIX}/search?q=薪水")
        self.assertEqual(response.status_code, 200)

        response = client.get(f"{PREFIX}/search?q=薪水&as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

    def test_editor(self) -> None:
        """Test the permission as editor.

        :return: None.
        """
        ReportTestData(self.__app, "editor").populate()
        response: httpx.Response

        response = self.__client.get(PREFIX)
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/journal")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/journal?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/ledger")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/ledger?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/income-expenses")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/income-expenses?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/trial-balance")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/trial-balance?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/income-statement")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/income-statement?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/balance-sheet")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/balance-sheet?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/unapplied")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/unapplied?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/unmatched")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/unmatched?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/search?q=Salary")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/search?q=Salary&as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/search?q=薪水")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/search?q=薪水&as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

    def test_empty_db(self) -> None:
        """Tests the empty database.

        :return: None.
        """
        response: httpx.Response

        response = self.__client.get(PREFIX)
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/journal")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/journal?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/ledger")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/ledger?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/income-expenses")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/income-expenses?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/trial-balance")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/trial-balance?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/income-statement")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/income-statement?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/balance-sheet")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/balance-sheet?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/unapplied")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/unapplied?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(
            f"{PREFIX}/unapplied/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/unmatched")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/unmatched?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(
            f"{PREFIX}/unmatched/USD/{Accounts.PAYABLE}?as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)

        response = self.__client.get(f"{PREFIX}/search?q=Salary")
        self.assertEqual(response.status_code, 200)

        response = self.__client.get(f"{PREFIX}/search?q=Salary&as=csv")
        self.assertEqual(response.status_code, 200)
        self.assertEqual(response.headers["Content-Type"], CSV_MIME)


class ReportTestData(BaseTestData):
    """The report test data."""

    def _init_data(self) -> None:
        today: dt.date = dt.date.today()
        year: int = today.year - 5
        month: int = today.month
        while True:
            date: dt.date = dt.date(year, month, 5)
            if date > today:
                break
            self._add_simple_journal_entry(
                (date - today).days, "USD",
                "Salary薪水", "1200", Accounts.BANK, Accounts.SERVICE)
            month = month + 1
            if month > 12:
                year = year + 1
                month = 1
        self._add_simple_journal_entry(
            1, "USD", "Withdraw領錢", "1000", Accounts.CASH, Accounts.BANK)
        self._add_simple_journal_entry(
            0, "USD", "Dinner晚餐", "40", Accounts.MEAL, Accounts.CASH)