1 package DBIx::Class::Journal;
3 use base qw/DBIx::Class/;
8 our $VERSION = '0.02_01';
10 ## On create/insert, add new entry to AuditLog
14 # my ($class, $attrs, @rest) = @_;
16 # $class->result_source->schema->_journal_schema->current_user(delete $attrs->{user_id});
18 # $class->next::method($attrs, @rest);
25 return if($self->in_storage);
26 ## create new transaction here?
27 my $res = $self->next::method();
30 my $s_name = $self->result_source->source_name();
31 my $al = $self->result_source->schema->_journal_schema->resultset("${s_name}AuditLog");
33 my %id = map { $_ => $self->get_column($_)} $self->primary_columns;
35 my $change = { changeset_id => $al->result_source->schema->current_changeset };
37 if ( my $log = $al->find(\%id) ) {
38 #$log->created($change); # FIXME should this work?
39 $log->created($al->related_resultset("created")->create($change));
42 $al->create({ %id, created => $change });
49 ## On delete, update delete_id of AuditLog
53 my ($self, @rest) = @_;
54 $self->next::method(@rest);
56 if(!$self->in_storage)
58 my $s_name = $self->result_source->source_name();
59 my $al = $self->result_source->schema->_journal_schema->resultset("${s_name}AuditLog");
60 my $alentry = $al->find_or_create({ map { $_ => $self->get_column($_)} $self->primary_columns });
62 ## bulk_update doesnt do "create new item on update of rel-accessor with hashref, yet
63 my $change = $self->result_source->schema->_journal_schema->resultset('ChangeLog')->create({ changeset_id => $self->result_source->schema->_journal_schema->current_changeset });
64 $alentry->delete_id($change->id);
70 ## On update, copy previous row's contents to AuditHistory
74 my ($self, $upd, @rest) = @_;
78 my $s_name = $self->result_source->source_name();
79 my $ah = $self->result_source->schema->_journal_schema->resultset("${s_name}AuditHistory");
81 my $obj = $self->result_source->resultset->find( $self->ident_condition );
84 change => { changeset_id => $ah->result_source->schema->current_changeset },
88 $self->next::method($upd, @rest);
93 DBIx::Class::Journal - auditing for tables managed by DBIx::Class
98 use base 'DBIx::Class::Schema';
100 __PACKAGE__->load_components(qw/+DBIx::Class::Schema::Journal/);
102 __PACKAGE__->journal_connection(['dbi:SQLite:t/var/Audit.db']);
103 __PACKAGE__->journal_user(['My::Schema::User', {'foreign.userid' => 'self.user_id'}]);
108 $schema->changeset_user($user->id);
109 my $new_artist = $schema->txn_do( sub {
110 return = $schema->resultset('Artist')->create({ name => 'Fred' });
116 The purpose of this L<DBIx::Class> component module is to create an
117 audit-trail for all changes made to the data in your database (via a
118 DBIx::Class schema). It creates changesets and assigns each
119 create/update/delete operation an id. The creation and deletion date
120 of each row is stored, as well as the previous contents of any row
123 All queries which want auditing should be called using
124 L<DBIx::Class::Schema/txn_do>, which is used to create changesets for
127 To track who did which changes, the user_id (an integer) of the
128 current user can be set, a session_id can also be set, both are
131 To access the auditing schema to look at the auditdata or revert a
132 change, use C<< $schema->_journal_schema >>.
136 The journal schema contains a number of tables.
142 Each changeset row has an auto-incremented ID, optional user_id and
143 session_id, and a set_date which defaults to the current datetime.
145 A ChangeSet has_many Changes.
149 Each change/operation done in the transaction is recorded as a row in
150 the ChangeLog table. It contains an auto-incrementing ID, the
151 changeset_id and an order column for the ordering of each change in
156 For every table in the original database that is to be audited, an
157 AuditLog table is created. Each auditlog row has an id which will
158 contain the primary key of the table it is associated with. (NB:
159 currently only supports integer-based single column PKs). The
160 create_id and delete_id fields contain the IDs of the Changes that
161 created or deleted this row.
165 For every table in the original database to be audited, an
166 AuditHistory table is created. Each row has a change_id field
167 containing the ID of the ChangeLog row. The other fields correspond to
168 all the fields from the original table. Each time a column value in
169 the original table is changed, the entire row contents before the
170 change are added as a new row in this table.
178 =item journal_connection \@connect_info
180 Set the connection information for the database to save your audit
183 Leaving this blank assumes you want to store the audit data into your current
184 database. The storage object will be shared by the regular schema and the
187 =item journal_sources \@source_names
189 Set a list of source names you would like to audit, if unset, all
192 NOTE: Currently only sources with a single-column PK are supported, so
193 use this method if you have sources with multi-column PKs.
195 =item journal_storage_type $type
197 Enter the special storage type of your journal schema if needed. See
198 L<DBIx::Class::Storage::DBI> for more information on storage types.
200 =item journal_user \@rel
202 The user_id column in the L</ChangeSet> will be linked to your user id
203 with a belongs_to relation, if this is set with the appropriate
206 =item journal_deploy_on_connect $bool
208 If set to a true value will cause C<journal_schema_deploy> to be called on
211 Not reccomended, but present for backwards compatibility.
213 =item changeset_user $user_id
215 Set the user_id for the following changeset(s). This must be an integer.
217 =item changeset_session $session_id
219 Set the session_id for the following changeset(s). This must be an integer.
221 =item txn_do $code_ref, @args
223 Overloaded L<DBIx::Class::Schema/txn_do>, this must be used to start a
224 new changeset to cover a group of changes. Each subsequent change to
225 an audited table will use the changeset_id created in the most recent
228 Currently nested C<txn_do> calls cause a single ChangeSet object to be created.
234 L<DBIx::Class> - You'll need it to use this.
238 Only single-column integer primary key'd tables are supported for auditing so far.
240 Updates made via L<DBIx::Class::ResultSet/update> are not yet supported.
242 No API for viewing or restoring changes yet.
244 Patches for the above welcome ;)
248 Jess Robinson <castaway@desert-island.me.uk>
250 Matt S. Trout <mst@shadowcatsystems.co.uk> (ideas and prodding)
254 You may distribute this code under the same terms as Perl itself.