Package perl-DBIx-Class-QueryLog: Information
Source package: perl-DBIx-Class-QueryLog
Version: 1.005001-alt2
Build time: Mar 21, 2016, 08:10 PM in the task #161792
Category: Development/Perl
Report package bugLicense: perl
Summary: Log queries for later analysis.
Description:
DBIx::Class::QueryLog 'logs' each transaction and query executed so you can
analyze what happened in the 'session'. It must be installed as the debugobj
in DBIx::Class:
use DBIx::Class::QueryLog;
use DBIx::Class::QueryLog::Analyzer;
my $schema = ... # Get your schema!
my $ql = DBIx::Class::QueryLog->new;
$schema->storage->debugobj($ql);
$schema->storage->debug(1);
... # do some stuff!
my $ana = DBIx::Class::QueryLog::Analyzer->new({ querylog => $ql });
my @queries = $ana->get_sorted_queries;
Every transaction and query executed will have a corresponding Transaction
and Query object stored in order of execution, like so:
Query
Query
Transaction
Query
This array can be retrieved with the log method. Queries executed inside
a transaction are stored inside their Transaction object, not inside the
QueryLog directly.
See the DBIx::Class::QueryLog::Analyzer manpage for options on digesting the results
of a QueryLog session.
If you wish to have the QueryLog collecting results, and the normal trace
output of SQL queries from DBIx::Class, then set `passthrough' to 1
$ql->passthrough(1);Maintainer: Igor Vlasenko
Last changed
March 21, 2016 Igor Vlasenko 1.005001-alt2
- to Sisyphus
Dec. 15, 2015 Igor Vlasenko 1.005001-alt1
- regenerated from template by package builder
Dec. 1, 2015 Igor Vlasenko 1.004001-alt1
- regenerated from template by package builder