NAME

db_put_file.pl - edit a text field within the database.

COPYRIGHT

Copyright (C) 2001, 2002 Mark Veltzer; All rights reserved.

LICENSE

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111, USA.

DETAILS

        MANIFEST: db_put_file.pl
        PROJECT: meta
        VERSION: 0.01

SYNOPSIS

        db_put_file.pl [options]

DESCRIPTION

This script enables you to load the content of a file into a database field (long text, image, audio, video or whatever).

This script receives: 0. connection data to the database. 1. table to be edited. 2. field to be edited. 3. field to select the record by. 4. value that the field should have. 5. file whos content should be loaded into the database.

The script will: 0. connect to the database. 1. check that the field specified is indeed a binary field. 2. load the file you gave it into ram. 3. save the content into the database.

OPTIONS

verbose (type: bool, default: 0)

should I be noisy ?

connections (type: devf, default: xmlx/connections/connections.xml)

what XML/connections file to use

database (type: stri, default: elems)

what database to work on

table (type: stri, default: elems)

what table to work on

field (type: stri, default: content)

what field to work on

select_field (type: stri, default: name)

what field to select on

select_value (type: stri, default: logo)

what value to select on

file (type: devf, default: jpgx/simul.jpg)

what file to put

help (type: bool, default: 0)

display help message

pod (type: bool, default: 0)

display pod options snipplet

man (type: bool, default: 0)

display manual page

quit (type: bool, default: 0)

quit without doing anything

gtk (type: bool, default: 0)

run a gtk ui to get the parameters

license (type: bool, default: 0)

show license and exit

copyright (type: bool, default: 0)

show copyright and exit

description (type: bool, default: 0)

show description and exit

history (type: bool, default: 0)

show history and exit

no free arguments are allowed

BUGS

None.

AUTHOR

        Name: Mark Veltzer
        Email: mailto:veltzer@cpan.org
        WWW: http://www.veltzer.org
        CPAN id: VELTZER

HISTORY

        0.00 MV download scripts
        0.01 MV md5 issues

SEE ALSO

Meta::Baseline::Aegis(3), Meta::Db::Dbi(3), Meta::Tool::Editor(3), Meta::Utils::File::File(3), Meta::Utils::File::Remove(3), Meta::Utils::Opts::Opts(3), Meta::Utils::Output(3), Meta::Utils::System(3), Meta::Utils::Utils(3), strict(3)

TODO

-check that the field requested is indeed of type text.

-enacpsulate what this script is doing in a module so I can write massive upload script easily.