Roger Pettett > Bio-Das-ProServer > Bio::Das::ProServer::SourceHydra::sql

Download:
Bio-Das-ProServer-2.20.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 687   Source  

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 ^

syntax highlighting: