`mini\Table\InMemoryTable` class

Show private and protected members

Documentation

SQLite-backed in-memory table implementation

Intended as a ground-truth oracle for testing - all operations are translated to SQL and executed by SQLite, which provides well-defined semantics for filtering, sorting, and set operations.

$table = new InMemoryTable(
    new ColumnDef('id', ColumnType::Int, IndexType::Primary),
    new ColumnDef('name', ColumnType::Text, IndexType::Index),
    new ColumnDef('age', ColumnType::Int),
);

$table->insert(['id' => 1, 'name' => 'Alice', 'age' => 30]);
$table->insert(['id' => 2, 'name' => 'Bob', 'age' => 25]);

foreach ($table->gt('age', 20)->order('name ASC') as $id => $row) {
    echo "$row->name is $row->age\n";
}

Inheritance

Extends: mini\Table\AbstractTable

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

Properties (9)

private SQLite3 $db

private string $tableName

private array $where

private array $orGroups

OR groups - when non-empty, WHERE becomes: (group1) OR (group2) OR ...

private array $orderBy

private int $paramCounter

protected ?Closure $compareFn

protected ?int $limit

protected int $offset

Methods (53)

public `__construct()`

Create a new in-memory table with the given schema

public `__clone()`

Share database connection on clone (filters are query-level state)

private `quoteIdentifier()`

Quote a SQLite identifier (column/table name).

private `createTable()`

Create the SQLite table with proper schema

public `insert()`

Documentation missing

private `coerceValue()`

Coerce a value based on column type

private `coerceFilterValue()`

Coerce a filter value based on column type

public `update()`

Documentation missing

public `delete()`

Documentation missing

private `validateQuery()`

Validate that a query is derived from this table

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 `order()`

Documentation missing

public `union()`

Documentation missing

public `except()`

Documentation missing

public `or()`

Documentation missing

private `sqlUnion()`

Create SQL UNION of two InMemoryTable queries on same DB

private `renumberConditions()`

Renumber parameter names in condition groups to avoid collision

private `sqlExcept()`

Create SQL EXCEPT (NOT IN) of two InMemoryTable queries on same DB

private `extractPredicateConditions()`

Extract filter conditions from a Predicate

private `buildInCondition()`

Build IN condition from SetInterface

private `buildWhereClause()`

Build WHERE clause and parameter bindings

private `buildConditionGroup()`

Build a group of AND conditions

private `buildOrderByClause()`

Build ORDER BY clause

private `buildLimitClause()`

Build LIMIT/OFFSET clause

protected `materialize()`

Documentation missing

private `formatDecimalColumns()`

Format Decimal column values from scaled integer to decimal string

public `load()`

Documentation missing