Download the PHP package k-kinzal/ztd-query-postgres without Composer

On this page you can find all versions of the php package k-kinzal/ztd-query-postgres. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

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:
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.
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?

Example code of k-kinzal/ztd-query-postgres

Informations about the package ztd-query-postgres

ZTD Query PostgreSQL

License: MIT Docs PHP Version Ask DeepWiki

ZTD Query is a Zero Table Dependency testing library for PHP: it runs the SQL of an application on a real database engine without reading or writing any physical table. Before a query reaches the database, every table it references is replaced by a CTE holding the rows the test has written, and every INSERT, UPDATE, and DELETE is turned into a SELECT whose result is kept in the session, so later queries see the change. Tests therefore need no migrations, seeding, or cleanup, and they can run in parallel against one empty database. This package is the PostgreSQL platform: it reads PostgreSQL statements, rewrites them, and keeps track of the tables the session defines. Use it through the PDO adapter.

Requirements

Installation

With PDO:

Usage

ZtdPdo extends PDO, so it can be passed wherever the application expects a PDO connection. Tables are created and filled through the same connection; they exist only in the session.

ZtdPdo::fromPdo($pdo) wraps an existing connection instead of opening a new one, and disableZtd() and enableZtd() switch between the physical database and the session.

Configuration

Ignore skips the statement, Notice skips it and raises a PHP notice, and Exception throws an exception.

SQL Support

Statement PostgreSQL
SELECT, including joins, grouping, set operations, subqueries, CTEs, recursive CTEs, and window functions Supported
INSERT with VALUES or SELECT Supported
Upsert ON CONFLICT
UPDATE and DELETE Supported, including UPDATE ... FROM and DELETE ... USING
RETURNING Supported
TRUNCATE Supported
CREATE TABLE, DROP TABLE Supported
ALTER TABLE Unsupported
BEGIN, COMMIT, ROLLBACK Applied to the session: ROLLBACK discards the writes made since BEGIN
Views, indexes, routines, triggers, SET, and server or user administration Unsupported

Unsupported statements are handled as configured by unsupportedBehavior. The full specification is in docs/spec.md.

License

MIT License. See LICENSE for details.

All versions of ztd-query-postgres with dependencies

PHP Build Version
Package Version
Requires php Version ^8.1
k-kinzal/ztd-query-core Version ^0.1
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package k-kinzal/ztd-query-postgres contains the following files

Loading the files please wait ...