my ($self) = @_;
return [
{ -logic_name => 'get_databases',
-module => 'Bio::EnsEMBL::Hive::RunnableDB::JobFactory',
-parameters => {
'inputquery' => q{SHOW DATABASES LIKE "}.$self->o('only_databases').q{"},
'column_names' => [ 'dbname' ],
},
-input_ids => [
{ 'db_conn' => $self->o('source_server1') },
{ 'db_conn' => $self->o('source_server2') },
],
-flow_into => {
2 => { 'run_sql' => { 'db_conn' => '#db_conn##dbname#' },
}
},
},
{ -logic_name => 'run_sql',
-module => 'Bio::EnsEMBL::Hive::RunnableDB::Dummy', # use SqlCmd.pm to run your query or another JobFactory.pm to make another fan on table names
-parameters => {
},
-analysis_capacity => 10, # allow several workers to perform identical tasks in parallel
-input_ids => [
# (jobs for this analysis will be flown_into via branch-2 from 'get_databases' jobs above)
],
},
];
}