-
-
15 Apr 2011 19:35:57 UTC
- Distribution: BioPerl-DB
- Source (raw)
- Browse (raw)
- Changes
- How to Contribute
- Issues
- Testers (1 / 74 / 1)
- Kwalitee
Bus factor: 2- % Coverage
- License: perl_5
- Perl: v5.6.1
- Activity
24 month- Tools
- Download (481.25KB)
- MetaCPAN Explorer
- Permissions
- Subscribe to distribution
- Permalinks
- This version
- Latest version
and 1 contributors-
BioPerl Team
- Dependencies
- Bio::Root::Version
- DBI
- and possibly others
- Reverse dependencies
- CPAN Testers List
- Dependency graph
NAME
Bio::DB::Query::SqlQuery - Object representing an SQL Query
SYNOPSIS
$q = Bio::DB::Query::SqlQuery->new(-datacollections=>\@tables, -select=>\@selectcols); $q->flags("distinct", 1); $q->where("or", "colA=x", "colB=y", "colC=y");
DESCRIPTION
This class inherits from Bio::DB::Query::AbstractQuery
CONTACT
Chris Mungall, cmungall@fruitfly.org
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
new
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)
querytype
Usage: $query->querytype($val); # setting OR return $query->querytype(); # getting
one of : select, select distinct, insert, update, delete
ignored for now...
sql
Usage: $query->sql($val); # setting OR return $query->sql(); # getting
Module Install Instructions
To install Bio::BioEntry, copy and paste the appropriate command in to your terminal.
cpanm Bio::BioEntry
perl -MCPAN -e shell install Bio::BioEntry
For more information on module installation, please visit the detailed CPAN module installation guide.