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.