cgi_to_db - convert stored CGI files (from CGI.pm) to fsdb

NOTE: this page was directly converted from the perl FSDB manual pages from FSDB version 3.1

SYNOPSIS

cgi_to_db [-duU] [-e EmptyValue] [cgi-files…]

DESCRIPTION

Converts all stored CGI files (from CGI.pm) to fsdb, optionally unescaping the contents. When contents are unescaped, CR NL is recoded as ``n’’.

Output is always in fsdb list format with double space (type ``S’’) field separator.

Unlike most Fsdb programs, the input to this program is not usually from standard input. However, the program will take -i options.

This program requires temporary storage equal to the size of the data (so that it can handle the case of different entries having different headers).

OPTIONS

-u or –unescape

do unescape data, converting CGI escape codes like %xx to regular characters (default)

-U or –nounescape

do not unescape data, but leave it CGI-encoded

-e E or –empty E

give value E as the value for empty (null) records

-T TmpDir

where to put tmp files. Also uses environment variable TMPDIR, if -T is not specified. Default is /tmp.

This module also supports the standard fsdb options:

-d

Enable debugging output.

-i or –input InputSource

Read from InputSource, typically a file name, or - for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

-o or –output OutputDestination

Write to OutputDestination, typically a file name, or - for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

–autorun or –noautorun

By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The --(no)autorun option controls that behavior within Perl.

--help

Show help.

--man

Show full manual.

SAMPLE USAGE

Input:

file A (TEST/cgi_to_db_ex.in):

name=test id=111-11-1111 email=test%40usc.edu submit_time=Tue%20Jan%2014%2011%3A32%3A39%202003 =

file B (TEST/cgi_to_db_ex.in-2):

name=test2 id=222-22-2222 email=test2%40usc.edu newfield=foo emptyfield= submit_time=Tue%20Jan%2024%2022%3A32%3A39%202003 =

Command:

cgi_to_db TEST/cgi_to_db_ex.in TEST/cgi_to_db_ex.in-2

Output:

#fsdb -R C -F S name id email submit_time newfield emptyfield name: test id: 111-11-1111 email: test@usc.edu submit_time: Tue Jan 14 11:32:39 2003 name: test2 id: 222-22-2222 email: test2@usc.edu newfield: foo emptyfield: - submit_time: Tue Jan 24 22:32:39 2003 # | cgi_to_db TEST/cgi_to_db_ex.in TEST/cgi_to_db_ex.in-2

SEE ALSO

Fsdb. CGI (3pm). <http://stein.cshl.org/boulder/>. <http://stein.cshl.org/WWW/software/CGI/>