NAME

updatedb.pl - Update SQL Databases

DESCRIPTION

updatedb is an utility to update SQL databases from text files.

FORMAT OF THE TEXT FILES

updatedb assumes that each line of the input contains a data record and that the field within the records are separated by tabulators. The first field of the data record is used as table name.

Alternatively updatedb can read the column names from the first line of input (see the -h/--headline option).

OPTIONS

-h, --headline

Reads the column names from the first line of the input instead of dedicting them from the database layout. Requires the -t/--table option.

-t TABLE, --table=TABLE

Uses TABLE as table name for all records instead of the first field name.

-r ROUTINE, --routine=ROUTINE

Applies ROUTINE to any data record. ROUTINE must be a subroutine. updatedb passes the table name and a hash reference to this subroutine. The keys of the hash are the column names and the values are the corresponding field values.

AUTHOR

Stefan Hornburg, racke@linuxia.net

SEE ALSO

perl(1), DBIx::CGI(3)