The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
Webservice-InterMine-0.9404a
River stage one • 1 direct dependent • 1 total dependent
++
/ Webservice::InterMine::Query

NAME

Webservice::InterMine::Query - an object representation of a query on an InterMine database

SYNOPSIS

  # Queries should be created by their webservices, or through
  # the Webservice::InterMine factory module

  my $query = $service->new_query;

  $query->name('Genes_Annotated_Biological_Process');
  $query->description(
      'Get all genes in Drosophilids annotated with GO Terms in the Biological Process namespace'
  );

  $query->add_view(
      'Gene.name',
      'Gene.primaryIdentifier',
      'Gene.goAnnotation.ontologyTerm.name',
  );

  $query->set_sort_order('Gene.primaryIdentifier', 'asc');

  $query->add_constraint(
      path  => 'Gene.goAnnotation.ontologyTerm.namespace',
      op    => '=',
      value => 'biological_process',
  );

  $query->add_constraint(
      path  => 'Gene.organism.name',
      op    => 'CONTAINS',
      value => 'Drosophila',
  );

  my $results = $query->results(as => 'arrayrefs');

  for my $row (@$results) {
      my ($name, $id, $go_term) = @$row;
      print "$name ($id): $go_term\n";
  }

DESCRIPTION

This module is allows you to construct complex queries and obtain results from webservices which implement InterMine genomic databases.

METHODS

add_view( [@paths] | [$comma_sep_paths] | [$space_sep_paths])

Adds the paths to the view (result columns). If the argument to add_view is a comma or space separated string, it will be split automatically. All paths must be valid for the model being used, or an exception will be thrown.

set_sort_order( $path, [$direction] )

Defines the sort order for the results to be a particular column in the view (this column must already be in the view, or an exception will be thrown). You do not have to set the sort order manually, the default column is the first column of the view, and the default direction is 'asc'.

constraint methods:

  • add_constraint(%args or $string)

    Adds a constraint the the query. Returns the constraint object. See Webservice::InterMine::Cookbook::Recipe2 and Webservice::InterMine::Cookbook::Recipe3.

  • all_constraints

    Get a list of all the constraint objects attached to the query.

  • remove_constraint($constraint_obj)

    Removes the constraint from the query

  • find_constraints( \&coderef )

    Finds all constraints that match the code reference criterion - eg:

      my @eq_cons = $query->find_constraints(sub {$_->op eq '='});

  • count_constraints

    Returns the number of constraints on the query (or 0 if none)

  • clear_constraints

    Removes all the constraints from the query

  • coded_constraints

    Returns only the constraints that have codes (and can thus be combined to define the logic)

  • constraint_codes

    Returns the contraint codes currently being used by the constraints on the query.

add_join(%args or $path)

Adds a join description to the query (see Webservice::InterMine::Cookbook::Recipe4).

add_pathdescription(%args)

Adds a path description to the query (see Webservice::InterMine::Cookbook::Recipe4).

logic([EXPR or $str])

Gets or sets the current logic for the query as an object (calling code on the logic object gets a human readable string version). Illegal logic expressions or strings will cause exceptions to be thrown.

results([as => $format])

Gets the results for this query in a variety of formats. (see Webservice::InterMine::Cookbook::Recipe5) The four default formats are:

  • string

    Returns all rows as one string, with fields separated by tabs and lines separated by new-lines ("\n"). If you are wanting to simply store the results in a flat file, this is probably what you want.

  • strings

    Returns all rows as strings (without new-lines) in an arrayref.

  • hashref[s] [default]

    Returns an arrayref of hashrefs, where the keys are the view columns.

  • arrayref[s]

    Returns an arrayref of arrayrefs, where the fields are in the same order as the view columns.

results_iterator

returns a results object that allows you to iterate through the results row by row, in whatever format you choose. Please see Webservice::InterMine::Cookbook::Recipe6 and Webservice::InterMine::Cookbook::Recipe7.

suspend_validation | resume_validation | validate

Queries will by default check for errors in construction as they are being defined. You can choose to turn this off, which might be useful if you don't want to care about the order you add elements to the query (ie. you might call set_sort_order before add_view), or if you are concerned about speed. In most cases the recommendation is to not turn validation off, unless of course, you really know what you are doing. Calling validate at any point will always perform the validation checks, even if you have suspended validation.

to_xml

Returns an xml string representation of the query. This is suitable for serialisation of queries.

SEE ALSO

AUTHOR

Alex Kalderimis dev@intermine.org

BUGS

Please report any bugs or feature requests to dev@intermine.org.

SUPPORT

You can find documentation for this module with the perldoc command.

    perldoc Webservice::InterMine::Query

You can also look for information at:

COPYRIGHT AND LICENSE

Copyright 2006 - 2010 FlyMine, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.