zk2/sps-dbal-component

SQL query builder for Doctrine DBAL

v2.0.3 2024-04-12 14:04 UTC

README

Often there is a need to provide the end user with the possibility of complex filtering any data. It is quite problematic to correctly place parentheses in the AND / OR set. It is even more problematic to filter / sort by value from the aggregating function.

The component is intended for building valid blocks "WHERE", "OFFSET", "LIMIT" and "ORDER BY" in Doctrine\DBAL\Query\QueryBuilder. Also, the component allows you to use result of aggregating functions in the blocks "WHERE" and "ORDER BY".

Documentation

Quick start

Definitions

Usage

Running the Tests

Environment for tests inside Docker

It provides 3 DataBase engine (MySql, Postgres and SQLite) with fixtures.

For run tests:

cd tests/docker
docker-compose up -d
docker-compose exec php ./vendor/bin/phpunit

License

This bundle is released under the MIT license. See the complete license in the bundle:

LICENSE