koriym/query-locator

A SQL query locator

1.5.0 2021-11-09 15:05 UTC

Requires

• php: >=7.1.0

Requires (Dev)

• doctrine/coding-standard: ^9.0
• phpunit/phpunit: ^9.5.10
• ray/di: ^2.7.2
• vimeo/psalm: ^4.12

Suggests

• ext-apcu: *

MIT

• sql

README

Installation

Composer install

$ composer require koriym/query-locator

Usage

use Koriym\QueryLocator\QueryLocator;

$query = new QueryLocator($sqlDir);
$sql = $query['admin/user'];                // SELECT * FROM user;
$sql = $query->getCountQuery('admin/user'); // SELECT COUNT(*) FROM user;

SQL files

└── sql
    └── admin
        └── user.sql