Roger Pettett > Bio-Das-ProServer > Bio::Das::ProServer::SourceAdaptor::Transport::dbi

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

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 688   Source  

NAME ^

Bio::Das::ProServer::SourceAdaptor::Transport::dbi - A DBI transport layer (actually customised for MySQL)

VERSION ^

$Revision: 688 $

SYNOPSIS ^

DESCRIPTION ^

Transport helper class for database access, acting as a wrapper for DBI.

SUBROUTINES/METHODS ^

dbh - Database handle (mysqlish by default)

  my $dbh = Bio::Das::ProServer::SourceAdaptor::Transport::dbi->dbh();

query - Execute a given query with given args

  my $arrayref = $dbitransport->query(qq(SELECT ... WHERE x = ? AND y = ?),
                                      $x,
                                      $y);

prepare - DBI pass-through of 'prepare'

  my $sth = $dbitransport->prepare($query);

disconnect - DBI pass-through of disconnect

  $dbitransport->disconnect();

last_modified - machine time of last data change

  Only knows how to do this for MySQL databases.

  $dbitransport->last_modified();

  This method is only implemented for mysql databases.

DIAGNOSTICS ^

CONFIGURATION AND ENVIRONMENT ^

  [mysource]
  transport      = dbi
  driver         = dbdmodule (default: mysql)
  dbhost         = myserver  (default: localhost)
  dbport         = myport    (default: 3306)
  dbuser         = me        (default: test)
  dbpass         = password
  dbname         = mydb
  autodisconnect = yes|no|#

DEPENDENCIES ^

Bio::Das::ProServer::SourceAdaptor::Transport::generic
DBI

INCOMPATIBILITIES ^

BUGS AND LIMITATIONS ^

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.

syntax highlighting: