Bio::DOOP::DBSQL - MySQL control object
$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"; }
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 from the database and the DOOP API can not help you, you can make a query with the query method.
Tibor Nagy, Godollo, Hungary
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.
You can run special SQL statements on the database. The return is an arrayref to the results.
To install Bio::DOOP::DOOP, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Bio::DOOP::DOOP
CPAN shell
perl -MCPAN -e shell install Bio::DOOP::DOOP
For more information on module installation, please visit the detailed CPAN module installation guide.