• NAME
• SYNOPSIS
• DESCRIPTION
• CONTACT
• APPENDIX
  • new
  • querytype
  • sql

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