zk2/sps-component

SQL/DQL query builder for Doctrine 2

v1.5.2 2021-02-08 04:44 UTC

Requires

• php: >=7.2
• ext-pdo: *
• doctrine/annotations: ^1.0
• doctrine/cache: ^1.6
• doctrine/dbal: ^2.6
• doctrine/orm: ^2.6

Requires (Dev)

• ext-json: *
• monolog/monolog: ^2.1
• phpunit/phpunit: ^8.5
• symfony/var-dumper: ^5.0

MIT

• Evgeniy Budanov

• sql
• query builder
• dql

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 | Doctrine\ORM\QueryBuilder. Also, the component allows you to use aggregating functions in the blocks "WHERE" and "ORDER BY".

Documentation

Quick start

Definitions

Usage

Running the Tests

Install the Composer dev dependencies:

php composer.phar install --dev

Then, run the test suite using PHPUnit:

vendor/bin/phpunit

License

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

LICENSE