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.00
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
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.