NAME

  Bio::DOOP::DBSQL - MySQL control object

VERSION

Version 0.03

SYNOPSIS

  $db  = Bio::DOOP::DBSQL->connect("doopuser","dooppass","doop-plant-1_5","localhost");
  $res = $db->query("SELECT * FROM sequence LIMIT 10");
  foreach (@$res){
     @fields = @{$_};
     print"@fields\n";
  }

DESCRIPTION

  This object is a low level access to the MySQL database. Most of
  the cases you would not need to use because the DOOP API is substitute
  the database manipulations. But if you need special query and the DOOP 
  API can not help you, you can make a query with the query method.

AUTHOR

  Tibor Nagy, Godollo, Hungary

METHODS

connect

  $db = Bio::DOOP::DBSQL->connect("doopuser","dooppass","doop-plant-1_5","localhost");

  You can connect to the database. The arguments is the following:
  user name, password, database name, database host. The return value
  is a Bio::DOOP::DBSQL object. You must use this objects in the argument
  of other objects.

query

  $db->query("SELECT COUNT(*) FROM Cluster;");

  You can run special SQL statements on the database. In this example we count
  the number of clusters.
  Return type: arrayref to the results.