Tags: rkrx/php-mysql-query-builder
Tags
Implement Mock Database and Update JSON_TABLE syntax in Tests - Added `MockDatabase` class for in-memory database operations to facilitate testing. - Created `MockPDOStatement, `MockQueryStatement`, and `MockRunnableSelect` for simulating query executions. - Updated `JsonTable.php` and related tests to adjust JSON_TABLE syntax with appropriate quoting. - Updated `tests.php` for environment setup and adjusted PHPUnit bootstrap configuration. - Included `symfony/dotenv` in `composer.json` to handle environment variables.
Add support for temporary tables with `RunnableTemporaryTable` interf… …ace and implementation - Introduced `RunnableTemporaryTable` interface in `Builder`. - Implemented `MySQLTemporaryTable` to handle lifecycle and functionality of temporary tables. - Enhanced `Select` with `temporary()` method to create and manage temporary tables. - Added comprehensive unit tests for `MockDatabase` to test DQL, DML, DDL stacks, and temporary table functionality. - Updated `TableNameBuilder` and `MySQLSelect` to integrate new temporary table logic.
PreviousNext