NAME

admin_smokedb - Import smoke report in a mysql database

SYNOSPIS

admin_smokedb --clear  --create --database=s  --dir=s
               --drop --graph --help --import --man
               --min_smoke=i --nntp_server=s --mysql=s
               --password=s --suck --user=s --verbose

DESCRIPTION

This script help you to populate smoke database

The first time you run this script, you must do:

admin_smokedb --create

for create the needed mysql table. Use --user, --password, --database for overwrite default values.

Then you must do:

admin_smokedb --suck --import

for create a complete smoke database. It will take some times as it will fetch all reports from the newsgroup since the beginning of the smoke story. You can then launch your browser with smoke_db.cgi.

For a crontab use, do something like this:

CGI_BASE=/perl/smoke
0 8,19 * * * /usr/bin/admin_smokedb --suck --import --user=root --graph -v

OPTIONS

Options supported at this moment:

Actions

--clear

Remove all reports from database

--create

Create needed tables in mysql for store reports

--drop

Drop tables in mysql created by this app.

--import

Parse and imports reports in database

--suck

Fetch new report from perl.daily-build.reports

--graph [ --min_smoke=no_smoke ]

Build with GD::Graph graph about smoke. Build them in current directory, with the help of the environnement variable CGI_BASE for base url in statics files created.

Others options

--dir= directory

Directory where store fetched reports. Default is HOME/.perl.daily-build.reports

--nntp_server= nntp host

Nntp host to use with --fetch. Default is nntp.perl.org

--verbose

Display informations during execution

--user= user --password=s pass --database= db

Informations about mysql connection. Default is current user, no password, database 'smoke'

SEE ALSO

Test::Smoke::Database, Test::Smoke::Database::FAQ, Test::Smoke

VERSION

$Revision: 1.14 $

AUTHOR

Alain BARBET with some help from Abe Timmerman