import sys
from typing import Iterable, Optional, Dict, Any
import csv

import ftfy

from chocula.util import clean_str, parse_country
from chocula.common import DirectoryLoader
from chocula.database import DirectoryInfo


class SherpaRomeoLoader(DirectoryLoader):
    """
    CSV Columns:

        #RoMEO Record ID,Publisher,Policy Heading,Country,RoMEO colour,Published Permission,Published Restrictions,Published Max embargo,Accepted Prmission,Accepted Restrictions,Accepted Max embargo,Submitted Permission,Submitted Restrictions,Submitted Max embargo,Open Access Publishing,Record Status,Updated

        #Journal Title,ISSN,ESSN,URL,RoMEO Record ID,Updated

    """

    source_slug = "sherpa_romeo"
    sherpa_policies: Dict[str, Any] = dict()

    def open_file(self) -> Iterable:

        # first load policies
        print("##### Loading SHERPA/ROMEO policies...", file=sys.stderr)
        fixed_policy_file = ftfy.fix_file(
            open(self.config.sherpa_romeo_policies_simple.filepath, "rb")
        )
        policy_reader = csv.DictReader(fixed_policy_file)
        for row in policy_reader:
            self.sherpa_policies[row["RoMEO Record ID"]] = row

        # then open regular file
        raw_file = (
            open(self.config.sherpa_romeo_journals_simple.filepath, "rb")
            .read()
            .decode(errors="replace")
        )
        fixed_file = ftfy.fix_text(raw_file)
        return csv.DictReader(fixed_file.split("\n"))

    def parse_record(self, row) -> Optional[DirectoryInfo]:
        # super mangled :(

        row.update(self.sherpa_policies[row["RoMEO Record ID"]])

        info = DirectoryInfo(
            directory_slug=self.source_slug,
            issnp=row["ISSN"],
            issne=row["ESSN"],
            name=clean_str(row["Journal Title"]),
            publisher=clean_str(row["Publisher"]),
            country=parse_country(row["Country"]),
            custom_id=row["RoMEO Record ID"],
        )

        if row["RoMEO colour"]:
            info.extra["sherpa_romeo"] = dict(color=row["RoMEO colour"])

        return info