GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SQLW_IMPORT (1)

.ds Aq ’

NAME

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

CONTENTS

VERSION

version 0.1601

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.

Search for    or go to Top of page |  Section 1 |  Main Index


perl v5.20.3 SQLW_IMPORT (1) 2016-04-04

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.