DragonFly On-Line Manual Pages

Search: Section:  

SQLW_IMPORT(1)        User Contributed Perl Documentation       SQLW_IMPORT(1)


NAME

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


VERSION

       version 0.16


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 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)

Search: Section: