lib/DBIx/Class/Schema/Journal.pm

   1 package DBIx::Class::Schema::Journal;
   2
   3 use base qw/DBIx::Class/;
   4
   5 use Scalar::Util 'blessed';
   6
   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');
  12
  13 sub load_classes
  14 {
  15     my $self = shift;
  16     $self->next::method(@_);
  17
  18     my $journal_schema = (__PACKAGE__ . '::DB')->connect($self->journal_connection || $self->storage->connect_info);
  19     if($self->journal_storage_type)
  20     {
  21         $journal_schema->storage_type($self->journal_storage_type);
  22     }
  23
  24     ## get our own private version of the journaling sources
  25     $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
  26
  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)
  30     {
  31         next unless($j_sources{$s_name});
  32         $self->create_journal_for($s_name);
  33         $self->source($s_name)->load_component('Journal');
  34     }
  35
  36     ## Set up relationship between changeset->user_id and this schema's user
  37     if(!@{$self->journal_user})
  38     {
  39         warn "No Journal User set!";
  40         return;
  41     }
  42
  43     $self->_journal_schema->source('ChangeSet')->belongs_to('user', @{$self->journal_user});
  44 }
  45
  46 sub get_audit_log_class_name
  47 {
  48     my ($self, $sourcename) = @_;
  49
  50     return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
  51 }
  52
  53 sub get_audit_history_class_name
  54 {
  55     my ($self, $sourcename) = @_;
  56
  57     return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
  58 }
  59
  60 sub create_journal_for
  61 {
  62     my ($self, $s_name) = @_;
  63
  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");
  68
  69
  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
  75                            );
  76
  77 }
  78
  79 sub create_changeset
  80 {
  81     my ($self, $code) = @_;
  82
  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(),
  88     });
  89     $self->result_source->schema->_journal_schema->current_changeset($changeset->ID);
  90
  91     $self->txn_do($code);
  92 }
  93
  94 1;