"""Private-mode tests run in a subprocess to isolate module-level DB config."""
import os
import sqlite3
import subprocess
import sys
import tempfile
import textwrap
import unittest
from pathlib import Path


class PrivateFrameworkTests(unittest.TestCase):
    def test_identity_audit_and_external_adapter(self):
        with tempfile.TemporaryDirectory(prefix='mortgage_banker_portal-private-') as directory:
            external_file = Path(directory) / 'upstream.db'
            con = sqlite3.connect(external_file)
            con.execute('''CREATE TABLE upstream (
                loan_number TEXT, loan_status TEXT, loan_channel TEXT, loan_program TEXT,
                loan_amount REAL, note_rate REAL, registered_date TEXT, funded_date TEXT,
                gross_profit REAL, broker_company TEXT, rate_locked_date TEXT
            )''')
            con.execute('''INSERT INTO upstream VALUES ('EXT-001','Underwriting','Wholesale','Conventional',440000,6.25,
                date('now','-11 days'),NULL,NULL,'Test Bank',date('now','-12 days'))''')
            con.execute('CREATE VIEW mortgage_dashboard_source AS SELECT * FROM upstream')
            con.commit()
            con.close()
            environment = os.environ.copy()
            environment.update({
                'MORTGAGE_DEMO': '0', 'MORTGAGE_DATA_DIR': directory,
                'MORTGAGE_ADMIN_PASSWORD': 'this-is-a-test-password-only',
                'MORTGAGE_SECRET_KEY': 'private-test-not-a-real-secret',
                'MORTGAGE_EXTERNAL_URL': 'sqlite:///' + external_file.as_posix(),
            })
            script = textwrap.dedent('''
                import re
                import core
                app=core.create_app()
                c=app.test_client()
                assert c.get('/').status_code == 302
                page=c.get('/login').get_data(as_text=True)
                token=re.search(r'name="csrf_token" value="([^"]+)"',page).group(1)
                assert c.post('/login',data={'username':'admin','password':'this-is-a-test-password-only','csrf_token':token}).status_code == 302
                assert c.get('/users').status_code == 200
                assert c.get('/integrations').status_code == 200
                assert c.get('/audit').status_code == 200
                assert c.post('/api/users',json={'username':'jane.doe','password':'a-strong-test-password','display_name':'Jane Doe','role':'viewer'}).status_code == 400
                csrf={'X-CSRF-Token':c.get('/profile').get_data(as_text=True).split('name="csrf-token" content="')[1].split('"')[0]}
                added=c.post('/api/users',json={'username':'jane.doe','password':'a-strong-test-password','display_name':'Jane Doe','role':'viewer'},headers=csrf)
                assert added.status_code == 201, added.get_data(as_text=True)
                assert c.patch('/api/profile',json={'display_name':'App Owner'},headers=csrf).status_code == 200
                status=c.post('/api/integrations/test',headers=csrf,json={})
                assert status.status_code == 200, status.get_data(as_text=True)
                external=c.get('/api/dashboard/overview?source=external').get_json()
                assert external['metrics']['active_loans']==1, external
                assert external['metrics']['active_volume']==440000, external
                assert c.get('/api/audit/export/config.csv').status_code == 200
                events=c.get('/api/audit/events').get_json()
                assert any(e['action']=='user.created' for e in events)
                assert any(e['action']=='connection.tested' for e in events)
                assert c.post('/logout',headers=csrf).status_code == 302
                viewer_page=c.get('/login').get_data(as_text=True)
                viewer_csrf=re.search(r'name="csrf_token" value="([^"]+)"',viewer_page).group(1)
                assert c.post('/login',data={'username':'jane.doe','password':'a-strong-test-password','csrf_token':viewer_csrf}).status_code == 302
                assert c.get('/profile').status_code == 200
                assert c.get('/users').status_code == 403
                assert c.get('/api/audit/export/config.csv').status_code == 403
                assert c.get('/api/export/loans').status_code == 403
                viewer_token=c.get('/profile').get_data(as_text=True).split('name="csrf-token" content="')[1].split('"')[0]
                assert c.post('/api/loans',json={'loan_number':'NO'},headers={'X-CSRF-Token':viewer_token}).status_code == 403
                print('private framework checks passed')
            ''')
            root = Path(__file__).resolve().parents[1]
            result = subprocess.run([sys.executable, '-c', script], cwd=root, env=environment,
                                    capture_output=True, text=True, timeout=35)
            self.assertEqual(result.returncode, 0, result.stdout + '\n' + result.stderr)


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