API

Установка

composer require mindy/query_builder

Пример использования

require('vendor/autoload.php'); // Composer autoloader

use Mindy\QueryBuilder\QueryFactory;
use Mindy\QueryBuilder\Mysql\Adapter;
use Mindy\QueryBuilder\LegacyLookupBuilder;

$pdo = new PDO(...);
// PDO является не обязательным, используется для экранирования
$factory = new QueryFactory(new Adapter($pdo), new LegacyLookupBuilder);

$qb = $factory->getQueryBuilder();
$qb->setTypeSelect()->setFrom('test')->setSelect('*');
echo $qb->toSQL();
// Output: SELECT * FROM `test`

Добавление lookup'ов

$lookups = [
	'foo' => function (IAdapter $adapter, $column, $value) {
		return $adapter->quoteColumn($column) . ' ??? ' . $adapter->quoteValue($value);
	}
];
$factory = new QueryFactory(new Adapter($pdo, $lookups), new LegacyLookupBuilder);
$qb = $factory->getQueryBuilder()->setTypeSelect()->setSelect('*')->setFrom('test')->setWhere([
	'name__foo' => 1
]);
echo $qb->toSQL();
// Output: SELECT * FROM `test` WHERE `name` ??? 1

Lookup

Lookup	SQL	PHP
raw	foo REGEX ?	$qb->setWhere(['foo__raw' => 'REGEX ?')
range	foo BETWEEN 1 AND 2	$qb->setWhere(['foo__range' => [1,2])
in	foo IN (1,2)	$qb->setWhere(['foo__in' => [1,2])
iendswith	lower(foo) LIKE %bar	$qb->setWhere(['foo__iendswith' => 'BAR'])
endswith	foo LIKE %bar	$qb->setWhere(['foo__endswith' => 'bar'])
istartswith	lower(foo) LIKE bar%	$qb->setWhere(['foo__istartswith' => 'BAR'])
startswith	foo LIKE bar%	$qb->setWhere(['foo__startswith' => 'bar'])
icontains	lower(foo) LIKE %bar%	$qb->setWhere(['foo__icontains' => 'BAR'])
contains	foo LIKE % bar%	$qb->setWhere(['foo__contains' => 'bar'])
exact	foo = 10	$qb->setWhere(['foo' => 10])
gte	foo >= 10	$qb->setWhere(['foo__gte' => 10])
gt	foo > 10	$qb->setWhere(['foo__gt' => 10])
lte	foo <= 10	$qb->setWhere(['foo__lte' => 10])
lt	foo < 10	$qb->setWhere(['foo__lt' => 10])
isnull	foo IS NOT NULL	$qb->setWhere(['foo__isnull' => false])

LegacyLookupBuilder

$qb = new QueryBuilder(new MysqlAdapter($pdo), new LegacyLookupBuilder);
$qb
	->setTypeSelect()
	->setSelect('*')
	->setFrom('comment')
	->setWhere(['id__gte' => 1])
	->setOrder(['created_at']);
$pdo->query($qb->toSQL())->fetchAll();

LookupBuilder

$qb = new QueryBuilder(new MysqlAdapter($pdo), new LookupBuilder);
$qb
	->setTypeSelect()
	->setSelect('*')
	->setFrom('comment')
	->setWhere(['id' => ['gte' => 1]])
	->setOrder(['created_at']);
$pdo->query($qb->toSQL())->fetchAll();

Известные проблемы

При использовании LegacyLookupBuilder невозможно использовать вложенные lookupы.

Пример:

['created_at__second__gte' => 200]

second, day, month, year, week_day, minute, hour работают только в режиме exact.