`mini\Table\Wrappers\SqlExceptTable` class

Show private and protected members

Documentation

SQL EXCEPT - rows from left that don't exist in right

Uses positional column matching (SQL standard for set operations). Predicates push down to left side only (we're filtering left, right is exclusion set).

// SELECT * FROM a EXCEPT SELECT * FROM b
new SqlExceptTable($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 (37)

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

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/SqlExceptTable.php:24-211