filisko/pdo-plus

PDO+ extends PDO in order to log all your queries. It also includes a Bar Panel for Tracy

v4.0.2 2021-07-23 14:58 UTC

Requires

• php: >=8.0
• ext-pdo: *

Requires (Dev)

• ext-sqlite3: *
• friendsofphp/php-cs-fixer: ^2.16
• infection/infection: ^0.23.0
• php-coveralls/php-coveralls: ^2.4
• phpstan/phpstan: ^0.12.89
• phpunit/phpunit: ^9.5
• tracy/tracy: ^2.8

Suggests

• jdorn/sql-formatter: Highlights your SQL queries inside Tracy Bar Panel
• tracy/tracy: Tracy debugger. Remember this package includes a Bar Panel that shows logged SQL queries

MIT

• Filis Futsarov

• log
• sql
• debug
• pdo
• queries
• tracy
• php8

README

PDO plus extends PDO in order to log all your queries. This package also includes a Bar Panel for Tracy (useful for legacy projects), see the result below.

Versions

Installation

Install via composer:

composer require filisko/pdo-plus

How to use

In this example we are using two different PDO instances just to show that it's doable.

// Create an instance using PDO plus
$pdoConnection1 = new \Filisko\PDOplus\PDO('mysql:host=127.0.0.1;dbname=my_db', 'my_user', 'my_pass');
$pdoConnection2 = new \Filisko\PDOplus\PDO('mysql:host=127.0.0.1;dbname=my_other_db', 'my_user', 'my_pass');

// ... our SQL queries ...

// Dump logged queries of PDO connection 1
var_dump($pdoConnection1->getLog());

// --- the following code shows how to integrate with Tracy debugger

// Instance for Tracy BarPanel for connection 1
$db1Panel = new \Filisko\PDOplus\Tracy\BarPanel($pdoConnection1);
$db1Panel->title = "DB 1 Panel";

// Instance for Tracy BarPanel for connection 2
$db2Panel = new \Filisko\PDOplus\Tracy\BarPanel($pdoConnection2);
$db2Panel->title = "DB 2 Panel";

// Enables Tracy debugger and adds panels for each connection (easy to integrate with legacy apps!)
\Tracy\Debugger::enable();
\Tracy\Debugger::getBar()->addPanel($db1Panel);
\Tracy\Debugger::getBar()->addPanel($db2Panel);

Tests

Run tests:

composer run-script test