# For outputting an XML file to a PostgreSQL database, use the general format of

# http://vegbank.org/vegdocs/xml/vegbank_example_ver1.0.2.xml

import os.path

import sys

import xml.dom.minidom

    def usage_err():

        raise SystemExit('Usage: '+opts.env_usage(env_names, True)

            +' [commit=1] '+sys.argv[0]+' [map_path] [<input] [>output]')

    # Get db config from env vars

    db_config_names = ['engine', 'host', 'user', 'password', 'database']

    map_path = None

    try: _prog_name, map_path = sys.argv

    except ValueError:

    # Load map header

    in_is_xpaths = True

            import db_xml

            in_db = sql.connect(in_db_config)

            in_pkeys = {}

                def put_col(path, value):

                    xpath.put_obj(doc1, path, row_id, has_types, value)

                for value, out in metadata: put_col(out, value)

                for in_, out in mappings:

            in_db.close()

        elif in_is_xml: raise SystemExit('XML input not supported yet')

        else: # input is CSV

            reader = csv.reader(sys.stdin)

            cols = reader.next()

            for row_idx, row in enumerate(reader):

                row_id = str(row_idx)

                def put_col(path, value):

                    xpath.put_obj(doc1, path, row_id, has_types, value)

                for value, out in metadata: put_col(out, value)

        finally:

            out_db.rollback()

            out_db.close()

try: main()

except SyntaxException, ex: raise SystemExit(str(ex))