from CPWeb.BibtexTools import getCitationOrAlternative, getBibtexParser
from CPWeb.SphinxTools import FluidGenerator
import os.path
import CoolProp
CP = CoolProp.CoolProp

web_dir = os.path.abspath(os.path.join(os.path.dirname(__file__), '..'))
root_dir = os.path.abspath(os.path.join(web_dir, '..'))
csvfile = os.path.join(web_dir, 'fluid_properties', 'PurePseudoPure.csv')
indexfile = os.path.join(web_dir, 'fluid_properties', 'fluidstoc.rst.in')


class Dossier:
    def __init__(self):
        self.data = {}

    def add(self, key, value):
        if key not in self.data:
            self.data[key] = []
        self.data[key].append(value)


d = Dossier()

from pybtex.database.input import bibtex
parser = bibtex.Parser()
bibdata = parser.parse_file(os.path.join(root_dir, "CoolPropBibTeXLibrary.bib"))

bibtexer = getBibtexParser()

bibtex_map = {'EOS': 'EOS',
              'CP0': ':math:`c_{p0}`',
              'CONDUCTIVITY': ':math:`\lambda`',
              'VISCOSITY': ':math:`\eta`',
              'MELTING_LINE': 'melt',
              'SURFACE_TENSION': ':math:`\sigma`'}
bibtex_keys = ['EOS', 'CP0', 'CONDUCTIVITY', 'VISCOSITY', 'MELTING_LINE', 'SURFACE_TENSION']

fluids_path = os.path.join(web_dir, 'fluid_properties', 'fluids')
if not os.path.exists(fluids_path):
    os.makedirs(fluids_path)

for fluid in CoolProp.__fluids__:

    FG = FluidGenerator(fluid)
    FG.write(fluids_path)

    d.add('name', fluid)
    for key in bibtex_keys:
        try:
            # get the item
            s = CoolProp.CoolProp.get_BibTeXKey(fluid, key)
            s = s.strip()
            if s and any([_s not in bibdata.entries.keys() for _s in s.split(',')]):
                print("problem %s %s %s %s" % (fluid, key, '\t\t\t\t', "|" + s + '|'))
                d.add(key, '')
            else:
                d.add(key, s)
        except ValueError as E:
            d.add(key, '')

import pandas
df = pandas.DataFrame(d.data)
df = df.sort_values(by=['name'], ascending=[1])


def build_citation(key):
    if not key:
        return ''
    else:
        return ':cite:`' + key + '`'


def fluid_reference(fluid):
    return ':ref:`{fluid:s} <fluid_{fluid:s}>`'.format(fluid=fluid)


# Write the table
with open(csvfile, 'w') as fp:
    rowdata = ["Name"] + [bibtex_map[key] for key in bibtex_keys]
    fp.write(';'.join(rowdata) + '\n')
    for index, row in df.iterrows():
        rowdata = [fluid_reference(row['name'])] + [build_citation(row[key]) for key in bibtex_keys]
        fp.write(';'.join(rowdata) + '\n')

# Write the hidden table to make sphinx happy
with open(indexfile, 'w') as fp:
    fp.write('.. toctree::\n    :hidden:\n\n')
    for index, row in df.iterrows():
        fp.write('    fluids/' + row['name'] + '.rst\n')