`mini\Table\Wrappers\FullJoinTable` class

Show private and protected members

Documentation

Full outer join of two tables with ON condition

Yields all rows from both tables:

Matched rows have data from both tables
Unmatched left rows have NULL for right columns
Unmatched right rows have NULL for left columns

Uses property-based binding: left table must have 'bind' property with Predicate.

// SELECT * FROM users u FULL JOIN orders o ON u.id = o.user_id
new FullJoinTable(
    $users->withAlias('u')->withProperty('__bind__', p->eqBind('u.id', ':o.user_id')),
    $orders->withAlias('o')
)

Inheritance

Extends: mini\Table\AbstractTable

Implements: mini\Table\Contracts\SetInterface IteratorAggregate Countable Traversable mini\Table\Contracts\TableInterface

Properties (9)

private mini\Table\Predicate $bindPredicate

private array $bindParams

private array $leftColNames

private array $rightColNames

private mini\Table\Contracts\TableInterface $left

private mini\Table\Contracts\TableInterface $right

protected ?Closure $compareFn

protected ?int $limit

protected int $offset

Methods (39)

public `__construct()`

Documentation missing

protected `materialize()`

Documentation missing

private `extractBindings()`

Extract binding values from a right row

private `mergeRows()`

Merge two rows into a single object

private `mergeLeftWithNulls()`

Merge left row with NULL values for right columns

private `mergeRightWithNulls()`

Merge right row with NULL values for left columns

public `order()`

Documentation missing

public `eq()`

Documentation missing

public `lt()`

Documentation missing

public `lte()`

Documentation missing

public `gt()`

Documentation missing

public `gte()`

Documentation missing

public `in()`

Documentation missing

public `like()`

Documentation missing

public `count()`

Documentation missing

public `__clone()`

inherited from Table\AbstractTable

Hook for subclasses to customize clone behavior

public `getRowKeyColumns()`

inherited from Table\AbstractTable

Get column name(s) that the row key represents

protected `getCompareFn()`

inherited from Table\AbstractTable

Get the string comparison function for sorting

public `limit()`

inherited from Table\AbstractTable

Documentation missing

public `offset()`

inherited from Table\AbstractTable

Documentation missing

public `getLimit()`

inherited from Table\AbstractTable

Documentation missing

public `getOffset()`

inherited from Table\AbstractTable

Documentation missing

public `withAlias()`

inherited from Table\AbstractTable

Documentation missing

public `getTableAlias()`

inherited from Table\AbstractTable

Get the current table alias (null if not set)

public `union()`

inherited from Table\AbstractTable

Documentation missing

public `except()`

inherited from Table\AbstractTable

Documentation missing

public `distinct()`

inherited from Table\AbstractTable

Documentation missing

public `or()`

inherited from Table\AbstractTable

Filter rows matching any of the given predicates (OR semantics)

public `exists()`

inherited from Table\AbstractTable

Documentation missing

public `has()`

inherited from Table\AbstractTable

Check if value(s) exist in the table's projected columns

protected `getPrimaryKeyColumn()`

inherited from Table\AbstractTable

Get the primary key column definition (cached)

public final `getIterator()`

inherited from Table\AbstractTable

Iterate over rows with visible columns only

public `getColumns()`

inherited from Table\AbstractTable

Get columns available for output

public `getAllColumns()`

inherited from Table\AbstractTable

Get all column definitions regardless of projection

public `columns()`

inherited from Table\AbstractTable

Narrow to specific columns

public `load()`

inherited from Table\AbstractTable

Load a single row by its row ID

public `getProperty()`

inherited from Table\AbstractTable

Get a property value

public `hasProperty()`

inherited from Table\AbstractTable

Check if a property exists (including null values)

public `withProperty()`

inherited from Table\AbstractTable

Return table with property set

Source

src/Table/Wrappers/FullJoinTable.php:31-276