#!/usr/bin/env python

# Translates a data dictionary spreadsheet to Redmine formatting

# Spreadsheet must have columns <Term>|...|Sources

# - <Term> can be any name

# Usage: self <spreadsheet >redmine

import csv

import re

import sys

# Spreadsheet format

source_sep = ', '

term_col = 0

##### URLs

def simplify_url(url): return re.sub(r'\(.*?\)', r'', url)

def url_term(url):

    match = re.search(r'[\w-]+$', url)

    assert match

    return match.group(0)

##### Redmine

def redmine_url(text, url):

    if url: return '"'+text+'":'+url

    else: return text

def source2redmine_url(url):

    if url: return redmine_url(url_term(url), simplify_url(url))

    else: return ''

class RedmineTableWriter:

    '''Formats rows as a Redmine table'''

    def __init__(self, stream):

        self.stream = stream

    def writerow(self, row):

        self.stream.write(('|'.join(['']+row+['']))+'\n')

def main():

    # Determine column order

    reader = csv.reader(sys.stdin)

    header = reader.next()

    sources_col = header.index('Sources')

    # Translate input

    writer = RedmineTableWriter(sys.stdout)

    writer.writerow(['*Term*', '*Sources*'])

    for row in reader:

        term = row[term_col]

        sources = map(simplify_url, row[sources_col].split(source_sep))

        sources_str = source_sep.join(sources)

        writer.writerow([redmine_url(term, sources[0]), sources_str])

main()