NAME

SQL::Entity::Relationship - Entities Relationship abstraction layer.

SYNOPSIS

    use SQL::Entity::Relationship ':all';
    use SQL::Entity::Column ':all';
    use SQL::Entity::Table;
    use SQL::Entity::Condition ':all';

    my $dept = SQL::Entity::Table->new(
        name    => 'dept',
        alias   => 'd',
        columns => [
            sql_column(name => 'deptno'),
            sql_column(name => 'dname')
        ],
    );
    my $emp  = SQL::Entity->new(
        name                  => 'emp',
        primary_key               => ['empno'],
        unique_expression     => 'rowid',
        columns               => [
            sql_column(name => 'ename'),
            sql_column(name => 'empno'),
            sql_column(name => 'deptno')
        ],
    );
    $emp->add_to_one_relationships(sql_relationship(
        target_entity => $dept,
        condition     => sql_cond($dept->column('deptno'), '=', $entity->column('deptno'))
    ));

DESCRIPTION

Represents relationship between entities.

EXPORT

sql_relationship by all tag.

ATTRIBUTES

name: Name of the relationship
target_entity
condition
join_columns
order_by

METHODS

initialise
join_condition: Return join condition.
join_condition_as_string: Return SQL condition fragment.
join_columns_values: Returns join columns values.
join_columns_condition: Returns condition for join columns.
order_by_clause: Returns order by sql fragment.
associate_the_other_end: Associated the other end.
sql_relationship: Creates a new relation object.

COPYRIGHT AND LICENSE

The SQL::Entity::Relationship 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

CPAN RT