NAME

db_edit_text.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_edit_text.pl
        PROJECT: meta
        VERSION: 0.01

SYNOPSIS

        db_edit_text.pl [options]

DESCRIPTION

This script will enable you to edit a text field within the database using your favorite editor.

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.

The script will: 0. connect to the database. 1. check that the field specified is indeed a text field. 2. get the record according to the specifier and exit if there is a problem. 3. save the text to a temp file. 4. launch your favorite editor to edit that file. 5. get the resulting text file and store it in the database using UPDATE.

OPTIONS

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

what value to select on

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.

-enable to edit the file in various other editors (gimp etc for images etc...).