"""Lightweight regression checks for portfolio demo boundaries and metrics."""
import os
import sys
import tempfile
import unittest

sys.path.insert(0, os.path.dirname(os.path.dirname(__file__)))


class ShowcaseTests(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        cls.directory = tempfile.TemporaryDirectory(prefix='mortgage_banker_portal-test-')
        os.environ['MORTGAGE_DATA_DIR'] = cls.directory.name
        os.environ['MORTGAGE_DEMO'] = '1'
        import core
        cls.core = core
        cls.app = core.create_app()
        cls.client = cls.app.test_client()

    @classmethod
    def tearDownClass(cls):
        cls.directory.cleanup()

    def test_demo_populates_synthetic_records(self):
        with self.core.get_db() as conn:
            count = conn.execute('SELECT COUNT(*) FROM loans').fetchone()[0]
            wrong_numbers = conn.execute("SELECT COUNT(*) FROM loans WHERE loan_number NOT LIKE 'DEMO-%'").fetchone()[0]
            self.assertGreater(count, 100)
            self.assertEqual(wrong_numbers, 0)

    def test_pages_and_export_are_available(self):
        for url in ('/', '/loans', '/brokers', '/analytics', '/reports', '/tools',
                    '/integrations', '/api/reports/dashboard.csv', '/api/reports/portfolio.csv',
                    '/api/analytics/export', '/api/export/loans'):
            with self.subTest(url=url):
                self.assertEqual(self.client.get(url).status_code, 200)

    def test_filtering_is_consistent(self):
        all_data = self.client.get('/api/dashboard/overview?period=12m').get_json()
        short = self.client.get('/api/dashboard/overview?period=3m').get_json()
        wholesale = self.client.get('/api/dashboard/overview?channel=Wholesale').get_json()
        self.assertEqual(len(all_data['monthly']), 12)
        self.assertEqual(len(short['monthly']), 3)
        self.assertLessEqual(sum(m['volume'] for m in short['monthly']), sum(m['volume'] for m in all_data['monthly']))
        self.assertLessEqual(wholesale['metrics']['active_loans'], all_data['metrics']['active_loans'])
        self.assertEqual(sum(stage['loans'] for stage in all_data['pipeline']), all_data['metrics']['active_loans'])
        self.assertEqual(len(wholesale['channel_mix']), 3)  # market-wide reference

    def test_read_only_boundary(self):
        attempts = [
            self.client.post('/api/loans', json={'loan_number': 'UNAUTHORIZED'}),
            self.client.delete('/api/loans/1'),
            self.client.post('/api/settings', json={'company_name': 'bad'}),
            self.client.post('/api/import/loans'),
        ]
        self.assertTrue(all(result.status_code == 403 for result in attempts))
        self.assertEqual(self.client.get('/settings').status_code, 302)
        self.assertEqual(self.client.get('/api/settings/reset').status_code, 405)


if __name__ == '__main__':
    unittest.main()
