hoover_pipeline

SYNOPSIS

hoover_pipeline.pl {-url <url> | -reg_conf <reg_conf> -reg_alias <reg_alias>} [ { -before_datetime <datetime> | -days_ago <days_ago> } ]

DESCRIPTION

hoover_pipeline.pl is a script used to remove old “DONE” Jobs from a continuously running pipeline database

USAGE EXAMPLES

    # delete all Jobs that have been "DONE" for at least a week (default threshold) :

hoover_pipeline.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult"


    # delete all Jobs that have been "DONE" for at least a given number of days

hoover_pipeline.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult" -days_ago 3


    # delete all Jobs "DONE" before a specific datetime:

hoover_pipeline.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult" -before_datetime "2013-02-14 15:42:50"

OPTIONS

--reg_conf <path>

path to a Registry configuration file

--reg_type <string>

type of the registry entry (“hive”, “core”, “compara”, etc - defaults to “hive”)

--reg_alias <string>

species/alias name for the eHive DBAdaptor

--url <url string>

URL defining where eHive database is located

--nosqlvc

“No SQL Version Check” - set if you want to force working with a database created by a potentially schema-incompatible API

--before_datetime <string>

delete Jobs “DONE” before a specific time

--days_ago <num>

delete Jobs that have been “DONE” for at least <num> days

-h, --help

show this help message