brinda/abstract-filter-query

There is no license information available for the latest version (dev-master) of this package.

Abstract filter query lib for use only one query builder for all filters in the world (SQL, Youtrack search, jql...)

dev-master 2022-05-06 13:46 UTC

Requires

• php: ^8.0.0
• ext-mbstring: *

Requires (Dev)

• phpunit/phpunit: 9.2.3

Unknown License

README

The library allows you to abstract from various query builders and use a common interface for everything. To do this, you just need to write your own hotkey, which will be inherited from AFQ\Converter\AbstractConverter.

Here is example of using it

<?php

use AFQ\Block\AndFilterBlock;
use AFQ\Comparison\Equal;
use AFQ\Comparison\In;
use AFQ\Converter\FilterBlockToSqlWhereConverter;
use AFQ\Converter\FilterBlockToYoutrackConverter;
use AFQ\FilterQuery;
use AFQ\Sorting\Sorting;

require_once '../vendor/autoload.php';

$queryFilter = new FilterQuery();
$queryFilter->setFilterBlock(new AndFilterBlock([
    new Equal('someKey', 'someValue'),
    new In('someKey2', ['value1', 'value2', 'value3'])
]));
$queryFilter->setSorting((new Sorting([
    ['someKey', Sorting::DESC],
    ['someKey2', Sorting::ASC]
])));

$sqlConverter = new FilterBlockToSqlWhereConverter();
$ytConverter = new FilterBlockToYoutrackConverter();

echo "Sql will be:\n";
echo $sqlConverter->convertFilterQuery($queryFilter);
echo "\n\n";
echo "Youtrack will be:\n";
echo $ytConverter->convertFilterQuery($queryFilter);