NAME

Teng::Plugin::SearchJoined - Teng plugin for Joined query

SYNOPSIS

            

              
              
package MyDB;
use parent qw/Teng/;
__PACKAGE__->load_plugin('SearchJoined');
package main;
my $db = MyDB->new(...);
my $itr = $db->search_joined(user_item => [
    user => {'user_item.user_id' => 'user.id'},
    item => {'user_item.item_id' => 'item.id'},
], {
    'user.id' => 2,
}, {
    order_by => 'user_item.item_id',
});
while (my ($user_item, $user, $item) = $itr->next) {
    ...
}
            
          

DESCRIPTION

Teng::Plugin::SearchJoined is a Plugin of Teng for joined query.

INTERFACE

Method

$itr:Teng::Plugin::SearchJoined::Iterator = $db->search_joined($table, $join_conds, \%where, \%opts)

Return Teng::Plugin::SearchJoined::Iterator object.

$table, \%where and \%opts are same as arguments of Teng's search method.

$join_conds is same as argument of SQL::Maker::Plugin::JoinSelect's join_select method.

SEE ALSO

Teng

SQL::Maker::Plugin::JoinSelect

LICENSE

Copyright (C) Masayuki Matsuki.

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

AUTHOR

Masayuki Matsuki <y.songmu@gmail.com>