NAME

stag-bulkload.pl - creates bulkload SQL for input data

SYNOPSIS

  # convert XML to IText
  stag-bulkload.pl -l person file1.xml file2.xml

  # use a custom parser/generator and a custom writer/generator
  stag-bulkload.pl -p MyMod::MyParser file.txt

Creates bulkload SQL statements for an input file

Works only with certain kinds of schemas, where the FK relations make a tree (not a graph); i.e. the only FKs are to the parent

You do not need a connection to the DB

It is of no use for incremental loading - it assumes integer surrogate promary keys and starts these from 1

-p|parser FORMAT: FORMAT is one of xml, sxpr or itext, or the name of a perl module; xml assumed as default
-l|loadrecord NODE: adds a COMMIT statement after the INSERTs for this node