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 use DBIx::Class::Schema::Journal::DB;
   7
   8 __PACKAGE__->mk_classdata('journal_storage_type');
   9 __PACKAGE__->mk_classdata('journal_connection');
  10 __PACKAGE__->mk_classdata('journal_sources'); ## [ source names ]
  11 __PACKAGE__->mk_classdata('journal_user'); ## [ class, field for user id ]
  12 __PACKAGE__->mk_classdata('_journal_schema');
  13
  14 sub connection
  15 {
  16     my $self = shift;
  17     $self->next::method(@_);
  18
  19    print STDERR join(":", $self->sources), "\n";
  20
  21     my $journal_schema = DBIx::Class::Schema::Journal::DB->connect(@{ $self->journal_connection || $self->storage->connect_info });
  22 #    print STDERR "conn", $journal_schema->storage->connect_info;
  23     if($self->journal_storage_type)
  24     {
  25         $journal_schema->storage_type($self->journal_storage_type);
  26     }
  27
  28     ## get our own private version of the journaling sources
  29    $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
  30
  31     ## Create auditlog+history per table
  32     my %j_sources = @{$self->journal_sources} ? map { $_ => 1 } @{$self->journal_sources} : map { $_ => 1 } $self->sources;
  33     foreach my $s_name ($self->sources)
  34     {
  35         next unless($j_sources{$s_name});
  36         $self->create_journal_for($s_name);
  37         $self->class($s_name)->load_components('Journal');
  38 #        print STDERR "$s_name :", $self->class($s_name), "\n";
  39     }
  40
  41     ## Set up relationship between changeset->user_id and this schema's user
  42     if(!@{$self->journal_user})
  43     {
  44         warn "No Journal User set!";
  45         return;
  46     }
  47
  48     $self->_journal_schema->deploy();
  49     $self->_journal_schema->class('ChangeSet')->belongs_to('user', @{$self->journal_user});
  50     $self->_journal_schema->storage->disconnect();
  51 }
  52
  53 sub get_audit_log_class_name
  54 {
  55     my ($self, $sourcename) = @_;
  56
  57     return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
  58 }
  59
  60 sub get_audit_history_class_name
  61 {
  62     my ($self, $sourcename) = @_;
  63
  64     return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
  65 }
  66
  67 sub create_journal_for
  68 {
  69     my ($self, $s_name) = @_;
  70
  71     my $source = $self->source($s_name);
  72     my $newclass = $self->get_audit_log_class_name($s_name);
  73     DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
  74     $newclass->table(lc($s_name) . "_audit_log");
  75     $self->_journal_schema->register_class("${s_name}AuditLog", $newclass);
  76
  77
  78     my $histclass = $self->get_audit_history_class_name($s_name);
  79     DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
  80     $histclass->table(lc($s_name) . "_audit_history");
  81 #    $histclass->result_source_instance->name(lc($s_name) . "_audit_hisory");
  82     $histclass->add_columns(
  83                             map { $_ => $source->column_info($_) } $source->columns
  84                            );
  85
  86     $self->_journal_schema->register_class("${s_name}AuditHistory", $histclass);
  87 }
  88
  89 sub txn_do
  90 {
  91     my ($self, $code) = @_;
  92
  93     ## Create a new changeset, then run $code as a transaction
  94     my $cs = $self->_journal_schema->resultset('ChangeSet');
  95     my $changeset = $cs->create({
  96         user_id => $self->_journal_schema->current_user(),
  97         session_id => $self->_journal_schema->current_session(),
  98     });
  99     $self->_journal_schema->current_changeset($changeset->ID);
 100
 101     $self->next::method($code);
 102 }
 103
 104 1;