NAME

SQL::Maker::Plugin::JoinSelect - Plugin of SQL::Maker for making SQL contained `JOIN`

SYNOPSIS

            

              
              
use SQL::Maker;
SQL::Maker->load_plugin('JoinSelect');
my $builder = SQL::Maker->new(driver => 'SQLite', new_line => ' ');
my ($sql, @binds) = $builder->join_select(
    user => [
        item => 'user.id = item.user_id',
    ],
    ['*'],
    {
        'user.id' => 1,
    },
);
print $sql; #=> 'SELECT * FROM "user" INNER JOIN "item" ON user.id = item.user_id WHERE ("user"."id" = ?)';
            
          

DESCRIPTION

SQL::Maker::Plugin::JoinSelect is Plugin of SQL::Maker for making SQL contained `JOIN`.

INTERFACE

Method

($sql, @binds) = $sql_maker->join_select($table, $join_conds, \@fields, \%where, \%opt)

$table, \@fields, \%where and \%opt are same as arguments of $sql_maker->select.

$join_conds is an ArrayRef containing sequenced pair of $table and $join_cond as follows.

            

              
              
[
    'user_item' => {'user.id' => 'user_item.user_id'},
    'item'      => 'user_item.item_id => item.id',
    ...
]
            
          

Each $join_cond can be ArrayRef, HashRef and String same as condition argument of SQL::Maker::Select's add_join method.

Join type is 'inner' by default. If you want to specify join type, you can use ArrayRef like follows.

            

              
              
[
    'item' => ['outer' => {'user.id' => 'item.user_id'}],
]
            
          

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>