load_xml.py

import noteql
import click


@click.command()
@click.option("--tag", default="", help="tag name to extract xml")
@click.option("--table", default="", help="tablename")
@click.option("--schema", default="", help="schema")
@click.option("--field", default="", help="fieldname in table")
@click.option("--dburi", default="", help="sqlalchemy db uri")
@click.option("--append", is_flag=True, help="prefix")
@click.option("--overwrite", is_flag=True, help="overwrite")
@click.argument("file_name")
def load_xml_command_line(
    file_name, tag, table, schema, field, dburi, append, overwrite
):
    if not schema:
        schema = "public"
    session = noteql.Session(schema, dburi=dburi)
    session.load_xml(
        file_name,
        tag=tag,
        table_name=table,
        field_name=field,
        append=append,
        overwrite=overwrite,
    )


if __name__ == "__main__":
    load_xml_command_line()