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.