NAME

SQL::Builder::JoinGroup - Represent a group of JOINs

SYNOPSIS

This class can build the following SQL:

        (NATURAL JOIN foo LEFT JOIN bar USING (bar_id)) AS alias

or without an alias

        (NATURAL JOIN foo LEFT JOIN bar USING (bar_id))

or an empty join list

        "" #an empty string

or more flexibly speaking

        anything [AS anything]

Typically, one would do something like:

        my $jgroup = SQL::Builder::JoinGroup->new;
        
        $jgroup->add_join(
                type => "LEFT",
                table => "foo"
                on => "foozle = boozle"
        );

        $jgroup->add_join(
                type => "RIGHT",
                table => "bar",
                using => "omghi"
        );

        $jgroup->alias("alias");

        # (JOIN foo ON foozle = boozle RIGHT JOIN bar USING (omghi)) AS alias
        print $jgroup->sql

DESCRIPTION

This is a SQL::Builder::List(3) subclass

METHODS

alias([$alias])

Get/set the alias. Returns the current object when called with arguments and sets the current value, otherwise returns the current value

init()

This calls init() on the parent class, parens(1), and sets the joiner() to "\n"

joins([@list])

This is a wrapper to SQL::Builder::List::list()

sql()

Returns the SQL serialization or an empty string. The alias is only used if it is defined and has a length. SQL::Builder::List::sql() is used here. The value of alias() is passed through SQL::Builder::Base::dosql()

SEE ALSO

SQL::Builder::List(3) SQL::Builder::Join(3) SQL::Builder::Base(3) SQL::Builder(3)