#!/usr/bin/env python

# Transforms a map spreadsheet to use a different root

import csv

import os.path

import re

import sys

sys.path.append(os.path.dirname(__file__)+"/../lib")

import opts

def all_not_none(list_):

    return reduce(lambda a, b: a and b, map(lambda e: e != None, list_))

def main():

    # Get config from env vars

    config_names = ['in_root', 'out_root']

    env_names = []

    configs = map(lambda col: opts.get_env_vars(config_names, col, env_names),

        ['left', 'right'])

    if not all_not_none(configs): raise SystemExit(

        'Usage: '+opts.env_usage(env_names)+' '+sys.argv[0]+' <in_map >out_map')

    # Transform map

    reader = csv.reader(sys.stdin)

    writer = csv.writer(sys.stdout)

    cols = reader.next()

    for i in xrange(len(configs)):

        config = configs[i]

        label, sep, config['root'] = cols[i].partition(':')

        cols[i] = label+sep+config['out_root']

        config['in_root_re'] = r'^'+re.escape(config['in_root'])+r'\b'

    writer.writerow(cols)

    for row in reader:

        for i in xrange(len(configs)): row[i] = configs[i]['root']+row[i]

        def sub(i):

            row[i], n = re.subn(configs[i]['in_root_re'], r'', row[i])

            return n > 0

        if sub(0):

            if not sub(1): raise SystemExit('Map error: Root "'

                +configs[1]['in_root']+'" is not contained in output mapping: '

                +row[1])

            writer.writerow(row)

main()

../scripts/util/ch_map_root <VegX-VegBank.organisms.csv >VegX-VegBank.plots.csv