-
-
07 Oct 2014 09:21:20 UTC
- Distribution: DBIx-Class-PgLog
- Source (raw)
- Browse (raw)
- Changes
- How to Contribute
- Issues (2)
- Testers (98 / 431 / 0)
- Kwalitee
Bus factor: 0- % Coverage
- License: unknown
- Activity
24 month- Tools
- Download (19.16KB)
- MetaCPAN Explorer
- Permissions
- Subscribe to distribution
- Permalinks
- This version
- Latest version
++ed by:1 non-PAUSE user- Dependencies
- unknown
- Reverse dependencies
- CPAN Testers List
- Dependency graph
- NAME
- VERSION
- SYNOPSIS
- DESCRIPTION
- DBIx::Class::ResultSet OVERRIDDEN METHODS
- AUTHORS
- COPYRIGHT AND LICENSE
NAME
DBIx::Class::ResultSet::PgLog - ResultSet base class for DBIx::Class::PgLog
VERSION
version 0.1
SYNOPSIS
Either create your own resultset-classes for each audited result-class, and load PgLogs resultset-component:
package MySchema::ResultSet::MyAuditedSource; use base "DBIx::Class::ResultSet"; # or use Moose and MooseX::NonMoose; __PACKAGE__->load_components("ResultSet::PgLog");
Or set the default resultset-class in your Schema:
package MySchema; use base "DBIx::Class::Schema"; ... __PACKAGE__->load_namespaces( default_resultset_class => "PgLog" );
DESCRIPTION
This resultset class enables logging for database updates made by calling "delete" in DBIx::Class::ResultSet and "update" in DBIx::Class::ResultSet. This includes any updates made by methods which rely on the above, like "set_\$rel" in DBIx::Class::Relationship::Base.
If you want full logging in a relational database, you most likely want to use this component.
NOTE:
The current implementation enables logging in the resultset by simply delegating 'delete' and 'update' to 'delete_all' and 'update_all', which call the required triggers. As a result, a database query like
"DELETE FROM table WHERE id IN '1', '2', '3'"
will result in 3 atomic queries:
"DELETE FROM table WHERE id = '1'"; "DELETE FROM table WHERE id = '2'"; "DELETE FROM table WHERE id = '3'";
which is much slower. It is therefore recommended to use this module only for resultset classes where it is needed. Specifying this module as default resultset class is only recommended if logging is needed for all tables.
DBIx::Class::ResultSet OVERRIDDEN METHODS
delete
Calls "delete_all" in DBIx::Class::ResultSet to ensure that triggers defined by DBIx::Class::PgLog are run.
update
Calls "update_all" in DBIx::Class::ResultSet to ensure that triggers defined by DBIx::Class::PgLog are run.
AUTHORS
See "AUTHOR" in DBIx::Class::PgLog and "CONTRIBUTORS" in DBIx::Class::PgLog
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Mark Jubenville.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
Module Install Instructions
To install DBIx::Class::PgLog, copy and paste the appropriate command in to your terminal.
cpanm DBIx::Class::PgLog
perl -MCPAN -e shell install DBIx::Class::PgLog
For more information on module installation, please visit the detailed CPAN module installation guide.