#!/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)

        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)

        stream.close()

main()