XP is just a number | |
PerlMonks |
Re: DBI.pm: composing and debugging MySql placeholdersby mje (Curate) |
on Oct 13, 2015 at 16:40 UTC ( [id://1144723]=note: print w/replies, xml ) | Need Help?? |
Look at DBIx-Log4perl or DBIx-LogAny for a way to get placeholders from the statement handle e.g., ParamValues and ParamTypes. Both of those modules can log SQL and placeholders. Look at DBI callbacks and you can intercept the execute and do methods. If you actually want to recreate the SQL with the placeholders in place that is slightly more difficult but not impossible
In Section
Seekers of Perl Wisdom
|
|