1 package DBIx::Class::Schema::Journal;
3 use base qw/DBIx::Class/;
5 use Scalar::Util 'blessed';
7 __PACKAGE__->mk_classdata('journal_storage_type');
8 __PACKAGE__->mk_classdata('journal_connection');
9 __PACKAGE__->mk_classdata('journal_sources'); ## [ source names ]
10 __PACKAGE__->mk_classdata('journal_user'); ## [ class, field for user id ]
11 __PACKAGE__->mk_classdata('_journal_schema');
16 $self->next::method(@_);
18 my $journal_schema = (__PACKAGE__ . '::DB')->connect($self->journal_connection || $self->storage->connect_info);
19 if($self->journal_storage_type)
21 $journal_schema->storage_type($self->journal_storage_type);
24 ## get our own private version of the journaling sources
25 $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
27 ## Create auditlog+history per table
28 my %j_sources = @{$self->journal_sources} ? map { $_ => 1 } @{$self->journal_sources} : map { $_ => 1 } $self->sources;
29 foreach my $s_name ($self->sources)
31 next unless($j_sources{$s_name});
32 $self->create_journal_for($s_name);
33 $self->source($s_name)->load_component('Journal');
36 ## Set up relationship between changeset->user_id and this schema's user
37 if(!@{$self->journal_user})
39 warn "No Journal User set!";
43 $self->_journal_schema->source('ChangeSet')->belongs_to('user', @{$self->journal_user});
46 sub get_audit_log_class_name
48 my ($self, $sourcename) = @_;
50 return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
53 sub get_audit_history_class_name
55 my ($self, $sourcename) = @_;
57 return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
60 sub create_journal_for
62 my ($self, $s_name) = @_;
64 my $source = $self->source($s_name);
65 my $newclass = $self->get_audit_log_class_name($s_name);
66 DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
67 $newclass->table(lc($s_name) . "_audit_log");
70 my $histclass = $self->get_audit_hisory_class_name($s_name);
71 DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
72 $histclass->table(lc($s_name) . "_audit_hisory");
73 $histclass->add_columns(
74 map { $_ => $source->column_info($_) } $source->columns
81 my ($self, $code) = @_;
83 ## Create a new changeset, then run $code as a transaction
84 my $cs = $self->result_source->schema->_journal_schema->resultset('ChangeSet');
85 my $changeset = $cs->create({
86 user_id => $self->result_source->schema->_journal_schema->current_user(),
87 session_id => $self->result_source->schema->_journal_schema->current_session(),
89 $self->result_source->schema->_journal_schema->current_changeset($changeset->ID);