NAME

Bio::Das::ProServer::SourceHydra::sql - A database-backed implementation of B::D::P::SourceHydra

VERSION

$Revision: 687 $

AUTHOR

Andy Jenkinson <andy.jenkinson@ebi.ac.uk>.

LICENSE AND COPYRIGHT

Copyright (c) 2008 EMBL-EBI

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for disclaimers of warranty.

DESCRIPTION

Extension of the 'dbi' hydra to allow the use of custom SQL queries to determine the available source names.

SYNOPSIS

my $sqlHydra = Bio::Das::ProServer::SourceHydra::sql->new( ... );
my @sources  = $dbiHydra->sources();

SUBROUTINES/METHODS

sources : DBI sources

Runs a preconfigured SQL statement, with the first column of each row of the
results being the name of a DAS source.

my @sources = $sqlhydra->sources();

The SQL query comes from $self->config->{'query'};

This routine caches results for $CACHE_TIMEOUT seconds.

DIAGNOSTICS

Run ProServer with the -debug flag.

CONFIGURATION AND ENVIRONMENT

[mysimplehydra]
adaptor   = simpledb           # SourceAdaptor to clone
hydra     = sql                # Hydra implementation to use
transport = dbi
query     = select sourcename from meta_table
dbname    = proserver
dbhost    = mysql.example.com
dbuser    = proserverro
dbpass    = topsecret

DEPENDENCIES

Bio::Das::ProServer::SourceHydra::dbi

INCOMPATIBILITIES

BUGS AND LIMITATIONS