Alternative to Devel's dpq(), with added linebreaks and indentation for readability.
Example of a nested query:
$q_nested = db_select(..);
...
$q = db_select(..);
$q->leftJoin($q_nested, ...);
...
nicedpq($q);
Result (in the message area):
SELECT
nested.*,
b.width AS width,
b.height AS height
FROM
bbb b
LEFT OUTER JOIN (
SELECT
a.x AS x,
a.y AS y,
a.b_id AS b_id
FROM
aaa a
WHERE
(z = 5) AND
(y > 2.2)
GROUP BY
a.b_id
) nested ON
nested.b_id = b.id
ORDER BY
b.width ASC
Explanation:
Devel dpq() simply uses the SelectQuery::__toString() method.
nicedpq() has its own way to generate a more readable output.
Project information
- Project categories: Developer tools
5 sites report using this module
- Created by donquixote on , updated
Stable releases for this project are covered by the security advisory policy.
There are currently no supported stable releases.
