#!/usr/bin/env python3
"""Pin one NGBVD snapshot before an authorised Power BI model refresh.

Run on the approved gateway/orchestrator, not in an HTTP request. Default is a
read-only plan. Access tokens must be supplied by the organisation's token broker.
"""
import argparse
import base64
from datetime import datetime, timedelta, timezone
import json
import os
import ssl
import sys
from urllib.error import HTTPError, URLError
from urllib.parse import urlsplit
from urllib.request import Request, HTTPRedirectHandler, HTTPSHandler, build_opener
from uuid import UUID


class RefreshError(Exception):
    pass


class NoRedirect(HTTPRedirectHandler):
    def redirect_request(self, req, fp, code, msg, headers, newurl):
        return None


def uuid_text(value):
    try:
        return str(UUID(value))
    except (ValueError, TypeError, AttributeError):
        raise RefreshError('INVALID_WORKSPACE_OR_MODEL_ID')


def request_json(url, headers, body=None):
    data = None if body is None else json.dumps(body).encode('utf-8')
    safe_headers = dict(headers, Accept='application/json')
    if data is not None:
        safe_headers['Content-Type'] = 'application/json'
    req = Request(url, data=data, headers=safe_headers, method='GET' if data is None else 'POST')
    opener = build_opener(NoRedirect(), HTTPSHandler(context=ssl.create_default_context()))
    try:
        with opener.open(req, timeout=30) as response:
            raw = response.read(512 * 1024 + 1)
            if len(raw) > 512 * 1024:
                raise RefreshError('METADATA_RESPONSE_TOO_LARGE')
            if not raw:
                return {}
            try:
                return json.loads(raw)
            except (UnicodeError, ValueError):
                raise RefreshError('INVALID_METADATA_RESPONSE')
    except HTTPError as error:
        # Never print remote error bodies, credentials or URLs containing tokens.
        raise RefreshError('REMOTE_HTTP_' + str(error.code))
    except (URLError, TimeoutError, OSError):
        raise RefreshError('TLS_OR_NETWORK_FAILURE')


def run(site_url, workspace, model, client_key, client_secret, token, apply=False, enhanced_metadata=False, request=request_json):
    site = urlsplit(site_url)
    if site.scheme != 'https' or not site.hostname or site.username or site.password or site.query or site.fragment or site.path not in ('', '/'):
        raise RefreshError('USE_OFFICIAL_HTTPS_ORIGIN')
    if not all((client_key, client_secret, token)) or any('\r' in s or '\n' in s for s in (client_key, client_secret, token)):
        raise RefreshError('MISSING_OR_INVALID_SECRET_STORE_INPUT')
    workspace = uuid_text(workspace); model = uuid_text(model)
    credentials = base64.b64encode((client_key + ':' + client_secret).encode()).decode()
    manifest = request(site_url.rstrip('/') + '/api/v2/power-bi/manifest', {'Authorization': 'Basic ' + credentials})
    if manifest.get('success') is not True or not isinstance(manifest.get('metadata'), dict):
        raise RefreshError('INVALID_NGBVD_MANIFEST')
    metadata = manifest['metadata']
    snapshot = uuid_text(metadata.get('snapshot_id'))
    today = (datetime.now(timezone.utc) + timedelta(hours=3)).date().isoformat()
    if metadata.get('business_date_eat') != today or not metadata.get('completed_at_utc'):
        raise RefreshError('TODAYS_SNAPSHOT_NOT_READY')
    if metadata.get('readable_fields_ready') is not True:
        raise RefreshError('READABLE_FIELDS_NOT_READY')
    base = 'https://api.powerbi.com/v1.0/myorg/groups/' + workspace + '/datasets/' + model
    headers = {'Authorization': 'Bearer ' + token}
    history = request(base + '/refreshes?$top=1', headers)
    for refresh in history.get('value', []):
        if refresh.get('status') not in ('Completed', 'Failed', 'Disabled', 'Cancelled'):
            raise RefreshError('MODEL_REFRESH_ALREADY_PENDING')
    parameters = request(base + '/parameters', headers)
    parameter = next((p for p in parameters.get('value', []) if p.get('name') == 'SnapshotId'), None)
    if not parameter or parameter.get('type') != 'Text':
        raise RefreshError('SNAPSHOT_ID_TEXT_PARAMETER_REQUIRED')
    result = {'apply': bool(apply), 'snapshot_id': snapshot, 'business_date_eat': today,
              'workspace_id': workspace, 'model_id': model, 'refresh_submitted': False}
    if not apply:
        return result
    if not enhanced_metadata:
        raise RefreshError('VERIFY_ENHANCED_METADATA_BEFORE_APPLY')
    if parameter.get('currentValue') != snapshot:
        request(base + '/Default.UpdateParameters', headers, {'updateDetails': [{'name': 'SnapshotId', 'newValue': snapshot}]})
    # The default request uses only notifyOption, compatible with shared capacity.
    # It submits a refresh; it does not claim the refresh has completed.
    request(base + '/refreshes', headers, {'notifyOption': 'NoNotification'})
    result['refresh_submitted'] = True
    return result


def main():
    parser = argparse.ArgumentParser(description=__doc__)
    parser.add_argument('--site-url', default='https://ngbvd.mglsd.go.ug')
    parser.add_argument('--workspace-id', required=True)
    parser.add_argument('--model-id', required=True)
    parser.add_argument('--apply', action='store_true')
    parser.add_argument('--enhanced-metadata', action='store_true', help='Confirm the target model uses enhanced metadata')
    args = parser.parse_args()
    try:
        result = run(args.site_url, args.workspace_id, args.model_id,
                     os.environ.get('NGBVD_POWERBI_CLIENT_KEY', ''),
                     os.environ.get('NGBVD_POWERBI_CLIENT_SECRET', ''),
                     os.environ.get('POWERBI_ACCESS_TOKEN', ''), args.apply, args.enhanced_metadata)
        print(json.dumps(result, indent=2))
        return 0
    except RefreshError as error:
        print(json.dumps({'success': False, 'reason': str(error)}), file=sys.stderr)
        return 1
    except Exception:
        print(json.dumps({'success': False, 'reason': 'UNEXPECTED_ORCHESTRATION_FAILURE'}), file=sys.stderr)
        return 1


if __name__ == '__main__':
    raise SystemExit(main())
