NAME

Persistence::Entity::Query - Database entity query.

CLASS HIERARCHY

SQL::Query
   |
   +----Persistence::Entity::Query

SYNOPSIS

 my $entity_manager = $class->new(connection_name => 'my_connection');


 $entity_manager->add_entities(SQL::Entity->new(
     name                  => 'emp',
     unique_expression     => 'empno',
     columns               => [
         sql_column(name => 'ename'),
         sql_column(name => 'empno'),
         sql_column(name => 'deptno')
     ],
     indexes => [
         sql_index(name => 'emp_idx1', columns => ['empno'])
     ]
 ));

 package Employee;

 use Abstract::Meta::Class ':all';
 use Persistence::ORM ':all';
 entity 'emp';

 column empno => has('$.no') ;
 column ename => has('$.name');
 column deptno => has('$.deptno');

 my $query = $entity_manager->query(emp => 'Employee');
 $query->set_offset(20);
 $query->set_limit(5);
 my @emp = $query->execute();
# do stuff $emp[0]->name

 my $query = $entity_manager->query('emp');
 $query->set_offset(20);
 $query->set_limit(5);
 my @emp = $query->execute();
 # do stuff $emp[0]->{ename}

DESCRIPTION

Represents database query based on entity definition.

EXPORT

None

ATTRIBUTES

name

cursor_callback

condition_converter_callback

METHODS

execute

query_setup

SEE ALSO

SQL::Query Persistence::Entity

COPYRIGHT AND LICENSE

The Persistence::Entity::Query module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

AUTHOR

Adrian Witas, adrian@webapp.strefa.pl