#!/usr/bin/env python

# Concatenates spreadsheets, removing any duplicated headers

# Usage: self [sheet...] >out_sheet

import os.path

import sys

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

import csvs

import util

def main():

    paths = sys.argv[1:]

    first_path = None

    first_info = None

    for path in paths:

        stream = open(path, 'rb')

        # Get dialect and process first line

        info = csvs.stream_info(stream)

        try:

            def write_header(): sys.stdout.write(info.header_line)

            if first_info == None:

                first_path = path

                first_info = info

                write_header()

            else:

                if not util.classes_eq(info.dialect, first_info.dialect):

                    raise SystemExit('Spreadsheet error: "'+path

                        +'" dialect doesn\'t match "'+first_path+'" dialect')

                if info.header_line != first_info.header_line: write_header()

                    # not a duplicated header

            # Copy remaining lines

            while True:

                line = stream.readline()

                if line == '': break

                sys.stdout.write(line)

        except IOError, e: # abort if output stream closed

            if str(e) != '[Errno 32] Broken pipe': raise # other IOErrors

        stream.close()

main()