NAME

db_sanity.pl - run various sanity tests on data in a 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_sanity.pl
        PROJECT: meta
        VERSION: 0.15

SYNOPSIS

        db_sanity.pl

DESCRIPTION

This will run some sanity tests against a database. The tests may include: 0. primary key uniqueness checking. 1. foreign key checking. 2. no illegal characters in strings. 3. valid values for enums. 4. valid values for special types of floats. 5. valid values for special types of ints. 6. valid values for booleans if booleans are not supported by the db. 7. valid values for special types of strings (IP addresses, URLs etc...).

OPTIONS

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

def_file (type: modu, default: xmlx/def/contacts.xml)

which definition file to use ?

connections_file (type: modu, default: xmlx/connections/connections.xml)

which connections file to use ?

name (type: stri, default: )

which database name to use ?

con_name (type: stri, default: )

which connection name to use ?

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 more data sets
        0.01 MV perl packaging
        0.02 MV license issues
        0.03 MV fix database problems
        0.04 MV md5 project
        0.05 MV database
        0.06 MV perl module versions in files
        0.07 MV thumbnail user interface
        0.08 MV more thumbnail issues
        0.09 MV website construction
        0.10 MV improve the movie db xml
        0.11 MV web site automation
        0.12 MV SEE ALSO section fix
        0.13 MV move tests to modules
        0.14 MV teachers project
        0.15 MV md5 issues

SEE ALSO

Meta::Db::Connections(3), Meta::Db::Dbi(3), Meta::Db::Def(3), Meta::Utils::Opts::Opts(3), Meta::Utils::System(3), strict(3)

TODO

-make it actually do the work and test it.