DBIx::Skinny::Profiler::Trace - support query profile.
in your script:
use Your::Model; my $row = Your::Model->insert('user', { id => 1, } ); $row->update({name => 'nekokak'}); $row = Your::Model->search_by_sql(q{SELECT id, name FROM user WHERE id = ?}, [ 1 ]); $row->delete('user')
execute script: It is output to STDERR in default.
$ SKINNY_TRACE=1 perl ./sample.pl INSERT INTO user (id) VALUES (?) :binds 1 UPDATE user set name = ? WHERE = id = ? :binds nekokak 1 SELECT id, name FROM user WHERE id = ? :binds 1 DELETE user WHERE id = ? :binds 1
or
The file can be specified.
$ SKINNY_TRACE=1=./query.log perl ./sample.pl $ cat ./query.log INSERT INTO user (id) VALUES (?) :binds 1 UPDATE user set name = ? WHERE = id = ? :binds nekokak 1 SELECT id, name FROM user WHERE id = ? :binds 1 DELETE user WHERE id = ? :binds 1
get all execute SQLs.
1 POD Error
The following errors were encountered while parsing the POD:
=over without closing =back
To install DBIx::Skinny, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Skinny
CPAN shell
perl -MCPAN -e shell install DBIx::Skinny
For more information on module installation, please visit the detailed CPAN module installation guide.