d3/oxid-sql-logger

Returns all SQL queries in the browser.

2.0.0 2024-02-02 10:39 UTC

Requires

• php: ^8.0
• firephp/firephp-core: ^0.5.3
• monolog/monolog: ^1
• nilportugues/sql-query-formatter: ^1.2.2

Requires (Dev)

• friendsofphp/php-cs-fixer: ~3.13.0
• phpstan/phpstan: ^1.10

GPL-3.0

• Tobias Matthaiou
• D3 Data Development (Inh. Thomas Dartsch)

README

Returns all SQL queries into console of a Browser.

Install

composer require --dev d3/oxid-sql-logger

Usage

Just set the function D3StartSQLLog() somewhere and from that point on all SQLs will be logged.

\D3StartSQLLog('specific log message');

$db = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
$list = $db->getAll('SELECT * FROM oxarticles WHERE oxprice < ? LIMIT 100', [49.99]);

\D3StopSQLLog();

Screenshots

Browser:

CLI:

Configuration

Add the sections to the config.inc.php of the shop if needed:

$this->SqlLoggerGUIHandlers = [
    \Monolog\Handler\BrowserConsoleHandler::class,
    \D3\OxidSqlLogger\Handler\d3FirePHPHandler::class
];

Standard handlers are BrowserConsoleHandler and d3FirePHPHandler.

$this->SqlLoggerCLIHandlers = [
    ...
];

Standard handler is StreamHandler.

$this->d3FirePHPOptions = [
    \D3\OxidSqlLogger\Handler\d3FirePHPHandler::ADD_TRACE
];

Credits

Many thanks to Tobias Matthaiou for his inspiration.