`mini\Table\Wrappers\SqlIntersectTable` class

Show private and protected members

Documentation

SQL INTERSECT - rows from left that also exist in right

Uses positional column matching (SQL standard for set operations). Predicates push down to both sides since a row must exist in both.

// SELECT * FROM a INTERSECT SELECT * FROM b
new SqlIntersectTable($tableA, $tableB)

Inheritance

Extends: mini\Table\AbstractTable

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

Properties (5)

private mini\Table\Contracts\TableInterface $left

private mini\Table\Contracts\TableInterface $right

protected ?Closure $compareFn

protected ?int $limit

protected int $offset

Methods (38)

public `__construct()`

Documentation missing

protected `materialize()`

Documentation missing

private `hasUsefulIndex()`

Check if a table has useful indexes for membership testing

private `remapRow()`

Remap row from source columns to target columns (positional)

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

private `mapColumnToRight()`

Map a column name from left to corresponding right column (positional)

public `count()`

Documentation missing

public `order()`

Documentation missing

public `has()`

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

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/SqlIntersectTable.php:24-270