/ 
DBIx-Class-QueryLog-0.03
River stage two • 8 direct dependents • 14 total dependents
/ DBIx::Class::QueryLog

NAME

DBIx::Class::QueryLog - Log queries for later analysis.

VERSION

Version 0.03

SYNOPSIS

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;

	my $schema = ... # Get your schema!
    my $ql = new DBIx::Class::QueryLog();
	$schema->storage->debugobj($ql);
	$schema->storage->debug(1);
    ... # do some stuff!

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.

METHODS

new

Create a new DBIx::Class::QueryLog.

time_elapsed

Returns the total time elapsed for ALL transactions and queries in this log.

count

Returns the number of queries executed in this QueryLog

get_sorted_queries

Returns all the queries in this log, sorted by elapsed time (descending).

reset

Reset this QueryLog by removing all transcations and queries.

add_to_log

Add this provided Transaction or Query to the log.

txn_begin

Called by DBIx::Class when a transaction is begun.

txn_commit

Called by DBIx::Class when a transaction is commited.

txn_rollback

Called by DBIx::Class when a transaction is rolled back.

query_start

Called by DBIx::Class when a query is begun.

query_end

Called by DBIx::Class when a query is completed.

AUTHOR

Cory 'G' Watson, <gphat at cpan.org>

BUGS

Please report any bugs or feature requests to bug-dbix-class-querylog at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBIx-Class-QueryLog. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc DBIx::Class::QueryLog

You can also look for information at:

ACKNOWLEDGEMENTS

COPYRIGHT & LICENSE

Copyright 2007 Cory 'G' Watson, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.