sqlw_import

Langue: en

Version: 2007-12-27 (mandriva - 01/05/08)

Section: 1 (Commandes utilisateur)

Sommaire

NAME

sqlw_import - import a Field:Value datafile into an SQLite database.

VERSION

This describes version 0.09 of sqlw_import.

SYNOPSIS

sqlw_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 ALSO

perl(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 (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.