Bio::DB::Query::SqlQuery - Object representing an SQL Query
$q = Bio::DB::Query::SqlQuery->new(-datacollections=>\@tables, -select=>\@selectcols); $q->flags("distinct", 1); $q->where("or", "colA=x", "colB=y", "colC=y");
This class inherits from Bio::DB::Query::AbstractQuery
Chris Mungall, cmungall@fruitfly.org
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
Usage: $sqlq = $self->new("table1", "col=val", "*"); OR $sqlq = $self->new(-select=>["col1", "col2"], -table=>["table1", "table2"], -where=>["col3='val1'", "col4='val4'"]); OR $sqlq = $self->new("col1, col2", "col1.fk=col2.pk", "*", "col2,col1"); OR $sqlq = $self->new("col1", {col1=>$val1, col2=>$val2}); Args: tables, where, select, order, group, sql
all arguments except table are optional (select defaults to *)
the arguments can either be array references or a comma delimited string
the where argument can also be passed as a hash reference (in which case the values are autoquoted)
Usage: $query->querytype($val); # setting OR return $query->querytype(); # getting
one of : select, select distinct, insert, update, delete
ignored for now...
Usage: $query->sql($val); # setting OR return $query->sql(); # getting
To install Bio::BioEntry, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Bio::BioEntry
CPAN shell
perl -MCPAN -e shell install Bio::BioEntry
For more information on module installation, please visit the detailed CPAN module installation guide.