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

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::dbi - A database-backed implementation of B::D::P::SourceHydra

VERSION ^

$Revision: 687 $

AUTHOR ^

Roger Pettett <rmp@sanger.ac.uk>.

LICENSE AND COPYRIGHT ^

Copyright (c) 2007 The Sanger Institute

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 ^

SYNOPSIS ^

  my $dbiHydra = Bio::Das::ProServer::SourceHydra::dbi->new();

SUBROUTINES/METHODS ^

sources : DBI sources

  Effectively returns the results of a SHOW TABLES LIKE '$basename%'
  query. In Oracle I guess this would need changing to table_name from
  all_tables where like '$basename%' or something.

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

  $basename comes from $self->config->{'basename'};

  This routine caches results for $CACHE_TIMEOUT as show tables can be
  slow for a few thousand sources.

last_modified : machine time of last data change

  Gets the most recent update time for any of the hydra's tables.
  Only knows how to do this for MySQL databases.

  my $unixtime = $dbihydra->last_modified();

DIAGNOSTICS ^

Run ProServer with the -debug flag.

CONFIGURATION AND ENVIRONMENT ^

  [mysimplehydra]
  adaptor   = simpledb           # SourceAdaptor to clone
  hydra     = dbi                # Hydra implementation to use
  transport = dbi
  basename  = hydra              # dbi: basename for db tables containing servable data
  dbname    = proserver
  dbhost    = mysql.example.com
  dbuser    = proserverro
  dbpass    = topsecret

DEPENDENCIES ^

Bio::Das::ProServer::SourceHydra

INCOMPATIBILITIES ^

BUGS AND LIMITATIONS ^

The last_modified method only works for MySQL databases.

syntax highlighting: