stag-bulkload.pl - creates bulkload SQL for input data
# 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
FORMAT is one of xml, sxpr or itext, or the name of a perl module
xml assumed as default
adds a COMMIT statement after the INSERTs for this node
Data::Stag
DBIx::DBStag
To install DBIx::DBStag, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::DBStag
CPAN shell
perl -MCPAN -e shell install DBIx::DBStag
For more information on module installation, please visit the detailed CPAN module installation guide.