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

$Revision: 506 $

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

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.

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

  my $sqlHydra = Bio::Das::ProServer::SourceHydra::sql->new( ... );
  my @sources  = $dbiHydra->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.

Run ProServer with the -debug flag.

  [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

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