import importlib.util
from datetime import datetime, timedelta, timezone
from pathlib import Path
import unittest

root = Path(__file__).resolve().parents[2]
spec = importlib.util.spec_from_file_location('refresh_model', root / 'scripts/refresh_powerbi_model.py')
module = importlib.util.module_from_spec(spec)
spec.loader.exec_module(module)


class RefreshModelTests(unittest.TestCase):
    def fake(self, pending=False, yesterday=False):
        calls = []
        snapshot = '11111111-1111-4111-8111-111111111111'
        today = (datetime.now(timezone.utc) + timedelta(hours=3) - timedelta(days=1 if yesterday else 0)).date().isoformat()
        def request(url, headers, body=None):
            calls.append((url, body))
            if url.endswith('/manifest'):
                return {'success': True, 'metadata': {'snapshot_id': snapshot, 'business_date_eat': today, 'completed_at_utc': 'synthetic', 'readable_fields_ready': True}}
            if '/refreshes?' in url:
                return {'value': [{'status': 'Unknown' if pending else 'Completed'}]}
            if url.endswith('/parameters'):
                return {'value': [{'name': 'SnapshotId', 'type': 'Text', 'currentValue': 'old'}]}
            return {}
        return calls, request

    def invoke(self, request, **options):
        return module.run('https://ngbvd.mglsd.go.ug', '22222222-2222-4222-8222-222222222222',
                          '33333333-3333-4333-8333-333333333333', 'synthetic-key', 'synthetic-secret',
                          'synthetic-token', request=request, **options)

    def test_plan_sends_no_writes(self):
        calls, request = self.fake()
        self.assertFalse(self.invoke(request)['refresh_submitted'])
        self.assertTrue(all(body is None for url, body in calls))

    def test_apply_pins_parameter_before_refresh(self):
        calls, request = self.fake()
        result = self.invoke(request, apply=True, enhanced_metadata=True)
        self.assertTrue(result['refresh_submitted'])
        writes = [(url, body) for url, body in calls if body is not None]
        self.assertTrue(writes[0][0].endswith('/Default.UpdateParameters'))
        self.assertEqual(result['snapshot_id'], writes[0][1]['updateDetails'][0]['newValue'])
        self.assertTrue(writes[1][0].endswith('/refreshes'))

    def test_pending_refresh_blocks_parameter_changes(self):
        calls, request = self.fake(pending=True)
        with self.assertRaisesRegex(module.RefreshError, 'ALREADY_PENDING'):
            self.invoke(request, apply=True, enhanced_metadata=True)
        self.assertTrue(all(body is None for url, body in calls))

    def test_old_snapshot_is_not_silently_reused_for_today(self):
        calls, request = self.fake(yesterday=True)
        with self.assertRaisesRegex(module.RefreshError, 'TODAYS_SNAPSHOT_NOT_READY'):
            self.invoke(request, apply=True, enhanced_metadata=True)
        self.assertEqual(1, len(calls))

    def test_enhanced_metadata_confirmation_is_required(self):
        calls, request = self.fake()
        with self.assertRaisesRegex(module.RefreshError, 'ENHANCED_METADATA'):
            self.invoke(request, apply=True)
        self.assertTrue(all(body is None for url, body in calls))

    def test_upgrade_pending_snapshot_blocks_model_writes(self):
        calls, original = self.fake()
        def request(url, headers, body=None):
            result = original(url, headers, body)
            if url.endswith('/manifest'):
                result['metadata']['readable_fields_ready'] = False
            return result
        with self.assertRaisesRegex(module.RefreshError, 'READABLE_FIELDS_NOT_READY'):
            self.invoke(request, apply=True, enhanced_metadata=True)
        self.assertEqual(1, len(calls))
        self.assertTrue(all(body is None for url, body in calls))


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