Debug mode tools PDO query suggestions

[adrian]

Hey Ryan,

A couple of quick suggestions for the debug mode tools PDO queries section. 

First one should be simple - force queries to wrap so they aren't truncated. I know they are still there and can be viewed in the page source, but would make life easier still. Along with break-word etc, I actually quite like how it looks with white-space: pre; as well, although it does make for a long page

The other thing might be more difficult - any chance you could decode the bindValue of the variables so we can see what is actually being queried. I haven't looked to see how/when this debug table is built, so maybe this isn't possible, but it sure would be helpful!

[ryan]

First one should be simple - force queries to wrap so they aren't truncated. 

Not sure I understand. Queries wrap for me at least?

The other thing might be more difficult - any chance you could decode the bindValue of the variables so we can see what is actually being queried. I haven't looked to see how/when this debug table is built, so maybe this isn't possible, but it sure would be helpful!

I don't think there is (unless getting into some internals of PDO). The prepare() method where queries are logged comes before variables are bound. Plus, variables are bound internally via PDO statement objects and not via ProcessWire. 

[adrian]

Hey Ryan - I actually get this is some cases and not others:

Not sure why - not a big deal.

I thought as much - just thought maybe you could store an array matching values to the variables and replace them on display. Again, no big deal - much more important things to do