Wallogit.com
2017 © Pedro Peláez
A SQL query locator
, (*1)
Koriym.QueryLocator is a PHP library that helps you manage SQL queries by locating and loading them from the file system. This approach simplifies query management and enhances code readability., (*2)
Install the library using Composer:, (*3)
$ composer require koriym/query-locator
To use the QueryLocator class, instantiate it with the directory where your SQL files are stored. You can then retrieve queries using keys that correspond to the directory structure., (*4)
SQL Files Directory Structure, (*5)
└── sql
└── admin
└── user.sql
Code Example, (*6)
use Koriym\QueryLocator\QueryLocator;
// Define the directory where your SQL files are stored
$sqlDir = 'path/to/sql/files';
// Instantiate the QueryLocator
$query = new QueryLocator($sqlDir);
// Retrieve a query
$sql = $query['admin/user']; // This will load the contents of 'admin/user.sql'
// Retrieve a count query
$countSql = $query->getCountQuery('admin/user'); // This will generate 'SELECT COUNT(*) FROM user'
A SQL query locator
MIT
sql
A SQL query locator
MIT
sql
A SQL query locator
MIT
sql