Atsushi Kobayashi > DBIx-Skinny-0.0742 > DBIx::Skinny::Profiler::Trace

Download:
DBIx-Skinny-0.0742.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source  

NAME ^

DBIx::Skinny::Profiler::Trace - support query profile.

SYNOPSIS ^

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

METHODS ^

$profiler->query_log()

get all execute SQLs.

syntax highlighting: