Group :: Development/Perl
RPM: perl-DBIx-Class-QueryLog
Main Changelog Spec Patches Sources Download Gear Bugs and FR Repocop
Current version: 1.005001-alt2
Build date: 21 march 2016, 17:02 ( 423.5 weeks ago )
Size: 21.78 Kb
Home page: https://github.com/frioux/DBIx-Class-QueryLog
License: perl
Summary: Log queries for later analysis.
Description:
List of contributors List of rpms provided by this srpm:
ACL:
Build date: 21 march 2016, 17:02 ( 423.5 weeks ago )
Size: 21.78 Kb
Home page: https://github.com/frioux/DBIx-Class-QueryLog
License: 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);
Current maintainer: Igor Vlasenko 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);
List of contributors List of rpms provided by this srpm:
- perl-DBIx-Class-QueryLog