Download the PHP package k-kinzal/ztd-query-php without Composer
On this page you can find all versions of the php package k-kinzal/ztd-query-php. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download k-kinzal/ztd-query-php
More information about k-kinzal/ztd-query-php
Files in k-kinzal/ztd-query-php
Download k-kinzal/ztd-query-php
More information about k-kinzal/ztd-query-php
Files in k-kinzal/ztd-query-php
Vendor k-kinzal
Package ztd-query-php
Short Description Zero Table Dependencies query layer for PHP
License MIT
Package ztd-query-php
Short Description Zero Table Dependencies query layer for PHP
License MIT
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package ztd-query-php
ZTD Query PHP
A Zero Table Dependency testing library for PHP 8.1+ that enables SQL unit testing without modifying physical databases.
Overview
ZTD Query PHP wraps PDO to intercept and transform SQL queries using CTE (Common Table Expression) shadowing. This allows you to:
- Test SQL queries against fixture data without migrations, data seeding, or cleanup
- Use the real MySQL engine for query execution (not mocks)
- Run tests in parallel with complete isolation
- Treat SQL as pure functions: input (fixtures) -> output (results)
How It Works
CTE Shadowing - Table references in SELECT queries are replaced with CTEs containing your fixture data:
Result Select Query - INSERT/UPDATE/DELETE statements are converted to SELECT queries that return the affected rows:
Requirements
- PHP 8.1 or higher
- MySQL 5.6 - 9.1
- PDO extension
Installation
Usage
Basic Example
Wrapping Existing PDO
Testing Write Operations
Enabling/Disabling ZTD Mode
Configuration
Configuration Options
| Option | Values | Description |
|---|---|---|
unsupportedBehavior |
Ignore, Notice, Exception |
Default behavior when unsupported SQL is executed |
unknownSchemaBehavior |
Passthrough, Exception |
Behavior when unknown table is referenced |
behaviorRules |
array<string, UnsupportedSqlBehavior> |
Per-pattern behavior overrides (first match wins) |
SQL Support
Fully Supported
- SELECT: All clauses including JOIN, GROUP BY, HAVING, ORDER BY, LIMIT, UNION, subqueries, CTEs, window functions
- INSERT: VALUES, SELECT, ON DUPLICATE KEY UPDATE, IGNORE
- REPLACE
- UPDATE: Single/multi-table with ORDER BY/LIMIT
- DELETE: Single/multi-table with ORDER BY/LIMIT
- TRUNCATE
- DDL: CREATE TABLE, ALTER TABLE, DROP TABLE (virtual schema)
- WITH: CTE and recursive CTE
Ignored (No-op)
- Transaction control: BEGIN, COMMIT, ROLLBACK, SAVEPOINT
Unsupported
- Stored procedures, triggers, functions, views
- Database/schema operations
- User/permission management
- Server operations (FLUSH, RESET, etc.)
Development
License
MIT License. See LICENSE for details.
All versions of ztd-query-php with dependencies
PHP Build Version
Package Version
Requires
php Version
^8.1
The package k-kinzal/ztd-query-php contains the following files
Loading the files please wait ...