NAME

Bio::DOOP::DBSQL - MySQL control object

VERSION

Version 0.04

SYNOPSIS

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

DESCRIPTION

This object provides low level access to the MySQL database. In most
cases you do not need to use it, because the DOOP API handles the database
queries. Still if you need some special query and the DOOP 
API can't help you, use the query method to access the database.

AUTHOR

Tibor Nagy, Godollo, Hungary and Endre Sebestyen, Martonvasar, Hungary

METHODS

connect

$db = Bio::DOOP::DBSQL->connect("doopuser","dooppass","database","localhost");

You can connect to the database with this method. The arguments are the 
following : username, password, database name, host. The return value
is a Bio::DOOP::DBSQL object. You must use this object 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.
Returns an arrayref to the results.