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

NAME

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

Back to Top

VERSION

$Revision: 687 $

Back to Top

AUTHOR

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

Back to Top

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.

Back to Top

DESCRIPTION

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

Back to Top

SYNOPSIS

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

Back to Top

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.

Back to Top

DIAGNOSTICS

Run ProServer with the -debug flag.

Back to Top

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

Back to Top

DEPENDENCIES

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

Back to Top

INCOMPATIBILITIES

Back to Top

BUGS AND LIMITATIONS

Back to Top

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