#!/usr/bin/env python

# Concatenates two spreadsheets with the same headers

import csv

import sys

def main():

    try: _prog_name, sheet_1_path = sys.argv

    except ValueError:

        raise SystemExit('Usage: '+sys.argv[0]+' <sheet_0 sheet_1 [| '

            +sys.argv[0]+' sheet_2]... >cat_sheet')

    # Get cols

    reader_0 = csv.reader(sys.stdin)

    sheet_0_cols = reader_0.next()

    stream_1 = open(sheet_1_path, 'rb')

    reader_1 = csv.reader(stream_1)

    sheet_1_cols = reader_1.next()

    if not sheet_0_cols == sheet_1_cols: raise SystemExit('Map error: '

        'Sheet 1 column names don\'t match sheet 0 column names')

    # Write combined sheet

    writer = csv.writer(sys.stdout)

    writer.writerow(sheet_0_cols)

    def write_sheet(reader):

        for row in reader: writer.writerow(row)

    write_sheet(reader_0)

    write_sheet(reader_1)

    stream_1.close()

main()