sqlw_import - import a Field:Value datafile into an SQLite database.
version 0.1601
sqlw_import --help | --manpage | --version
sqlw_import --datafile datafile [--row_delim string ] --sqlitedb dbfile --table table
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.
The input data file.
Print help message and exit.
Print the full help documentation (manual page) and exit.
The end of a row of data is marked by this marker on a line by itself. (default: '=')
Print informational messages.
Print version information and exit.
The input data file is in the form of Field:Value pairs, with each record separated by a line with '=' on it.
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.
Getopt::Long Pod::Usage Getopt::ArgvFile SQLite::Work
perl(1) Getopt::Long Getopt::ArgvFile Pod::Usage
Please report any bugs or feature requests to the author.
Kathryn Andersen (RUBYKAT) perlkat AT katspace dot com http://www.katspace.com
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.
To install SQLite::Work, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQLite::Work
CPAN shell
perl -MCPAN -e shell install SQLite::Work
For more information on module installation, please visit the detailed CPAN module installation guide.