NAME

ActiveRecord::Simple::QueryManager - query manager for ActiveRecord classes

DESCRIPTION

Query manager for ActiveRecord classes.

SYNOPSIS

            

              
              
my $qm = ActiveRecord::Simple::QueryManager->new;
$qm->{caller} = 'User';
my @users = $qm->all(); # SELECT * FROM user;
my @johns = $qm->find({ name => 'John' })->fetch;
            
          

sql_fetch_all

Execute any SQL code and fetch data. Returns list of objects. Accessors for all not specified fields will be created as read-only.

            

              
              
my @values = Purchase->sql_fetch_all('SELECT id, amount FROM purchase WHERE amount > ?', 100);
print $_->id, " ", $_->amount for, "\n" @values;
            
          

sql_fetch_row

Execute any SQL and fetch data. Returns an object.

            

              
              
my $customer = Customer->sql_fetch_row('SELECT id, name FORM customer WHERE id = ?', 1);
print $customer->name, "\n";
            
          

find

Returns ActiveRecord::Simple::Find object.

            

              
              
my $finder = Customer->find(); # it's like ActiveRecord::Simple::Find->new();
$finder->order_by('id');
my @customers = $finder->fetch;
            
          

all

Same as __PACKAGE__->find->fetch;

get

Get object by primary_key

            

              
              
my $customer = Customer->get(1);
# same as Customer->find({ id => 1 })->fetch;