SQLW_IMPORT(1) User Contributed Perl Documentation SQLW_IMPORT(1)NAMEsqlw_import - import a Field:Value datafile into an SQLite database.
VERSION
version 0.16
SYNOPSISsqlw_import--help | --manpage | --version
sqlw_import--datafile datafile [--row_delim string ] --sqlitedb dbfile
--table table
DESCRIPTION
This script inserts the contents of a Field:Value format datafile into
a table in an SQLite database. The table and the database must have
already been created.
OPTIONS--datafile filename
The input data file.
--help
Print help message and exit.
--manpage
Print the full help documentation (manual page) and exit.
--row_delim
The end of a row of data is marked by this marker on a line by
itself. (default: '=')
--verbose
Print informational messages.
--version
Print version information and exit.
CONVERSION
Field:Value Format
The input data file is in the form of Field:Value pairs, with each
record separated by a line with '=' on it.
SQLite
This script expects both the SQLite database and the destination table
to have already been created. The table is expected to have the same
column names as the fields in the FieldVals file.
REQUIRES
Getopt::Long
Pod::Usage
Getopt::ArgvFile
SQLite::Work
SEE ALSOperl(1) Getopt::Long Getopt::ArgvFile Pod::Usage
BUGS
Please report any bugs or feature requests to the author.
AUTHOR
Kathryn Andersen (RUBYKAT)
perlkat AT katspace dot com
http://www.katspace.com
COPYRIGHT AND LICENCE
Copyright (c) 2004 by Kathryn Andersen
This program is free software; you can redistribute it and/or modify it
under the same terms as Perl itself.
perl v5.20.2 2015-08-30 SQLW_IMPORT(1)