Project

General

Profile

1
#!/usr/bin/env python
2
# Translates a data dictionary spreadsheet to Redmine formatting
3

    
4
import csv
5
import re
6
import sys
7

    
8
# Spreadsheet format
9
source_sep = ', '
10

    
11
##### URLs
12

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

    
15
def url_term(url):
16
    match = re.search(r'[\w:-]+$', url)
17
    assert match
18
    return match.group(0)
19

    
20
##### Redmine
21

    
22
def redmine_url(text, url):
23
    if url: return '"'+text+'":'+url
24
    else: return text
25

    
26
def source2redmine_url(url):
27
    if url: return redmine_url(url_term(url), simplify_url(url))
28
    else: return ''
29

    
30
class RedmineTableWriter:
31
    '''Formats rows as a Redmine table'''
32
    
33
    def __init__(self, stream):
34
        self.stream = stream
35
    
36
    def writerow(self, row):
37
        self.stream.write(('|'.join(['']+row+['']))+'\n')
38

    
39

    
40
def main():
41
    try: _prog_name, term_col, sources_col, def_col = sys.argv
42
    except ValueError: raise SystemExit('Usage: '+sys.argv[0]
43
        +' <spreadsheet term_col# sources_col# def_col# >redmine')
44
    term_col, sources_col, def_col = map(int, [term_col, sources_col, def_col])
45
    
46
    # Determine column order
47
    reader = csv.reader(sys.stdin)
48
    header = reader.next()
49
    
50
    # Translate input
51
    writer = RedmineTableWriter(sys.stdout)
52
    writer.writerow(['*Term*', '*Sources*', '*Definition*'])
53
    for row in reader:
54
        term = row[term_col]
55
        sources = map(simplify_url, row[sources_col].split(source_sep))
56
        def_ = row[def_col]
57
        
58
        term_str = redmine_url(term, sources[0])
59
        sources_str = source_sep.join(map(source2redmine_url, sources))
60
        
61
        writer.writerow([term_str, sources_str, def_])
62

    
63
main()
(13-13/69)