The following module was proposed for inclusion in the Module List:
modid: DBIx::ShowCaller
DSLIP: MdpOp
description: Adds a Perl caller info to the SQL command
userid: JANPAZ (Jan Pazdziora)
chapterid: 7 (Database_Interfaces)
communities:
Mailinglists, newsgroups
similar:
rationale:
This module can be used instead of the DBI module. For each SQL
command that is prepared (both using $dbh->prepare and via do,
selectall_* and the like) it prepends a /* */ style comment
containing information about file and line that called that
prepare/selectall_*/other method. Thus it makes it easier to see
where a particular SQL command came from.
Only database servers that log the whole SQL command (like Oracle
or MySQL) can make reasonable use of this. Also, if you call the
same SQL from different places of your code, the comment will be
different and the SQL server won't be able to reuse parsed info.
Consider the speed tradeoff here.
enteredby: JANPAZ (Jan Pazdziora)
enteredon: Fri Jun 27 10:04:50 2003 GMT
The resulting entry would be:
DBIx::
::ShowCaller MdpOp Adds a Perl caller info to the SQL command JANPAZ
Thanks for registering,
--
The PAUSE
PS: The following links are only valid for module list maintainers:
Registration form with editing capabilities:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=4f500000_9a890242efb0fc5b&SUBMIT_pause99_add_mod_preview=1
Immediate (one click) registration:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=4f500000_9a890242efb0fc5b&SUBMIT_pause99_add_mod_insertit=1
