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_no_automatic_deploy');
  11 __PACKAGE__->mk_classdata('journal_sources'); ## [ source names ]
  12 __PACKAGE__->mk_classdata('journal_user'); ## [ class, field for user id ]
  13 __PACKAGE__->mk_classdata('_journal_schema'); ## schema object for journal
  14
  15 our $VERSION = '0.01';
  16
  17 use strict;
  18 use warnings;
  19
  20 # sub throw_exception
  21 # {
  22 # }
  23
  24 # sub exception_action
  25 # {
  26 #     my $self = shift;
  27 # #    print STDERR Carp::longmess;
  28
  29 #     $self->next::method(@_);
  30 # }
  31
  32 # sub load_classes
  33 # {
  34 #     my $class = shift;
  35
  36
  37 #     $class->next::method(@_);
  38
  39 # }
  40
  41 sub connection
  42 {
  43     my $self = shift;
  44     my $schema = $self->next::method(@_);
  45
  46 #   print STDERR join(":", $self->sources), "\n";
  47
  48     my $journal_schema;
  49     if(!defined($self->journal_connection))
  50     {
  51         ## If no connection, use the same schema/storage etc as the user
  52         DBIx::Class::Componentised->inject_base(ref $self, 'DBIx::Class::Schema::Journal::DB');
  53           $journal_schema = $self;
  54     }
  55     else
  56     {
  57         $journal_schema = DBIx::Class::Schema::Journal::DB->connect(@{ $self->journal_connection });
  58         if($self->journal_storage_type)
  59         {
  60             $journal_schema->storage_type($self->journal_storage_type);
  61         }
  62     }
  63
  64     ## get our own private version of the journaling sources
  65    $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
  66
  67     ## Create auditlog+history per table
  68     my %j_sources = map { $_ => 1 } $self->journal_sources
  69                                       ? @{$self->journal_sources}
  70                                       : $self->sources;
  71     foreach my $s_name ($self->sources)
  72     {
  73         next unless($j_sources{$s_name});
  74         $self->create_journal_for($s_name);
  75         $self->class($s_name)->load_components('Journal');
  76 #        print STDERR "$s_name :", $self->class($s_name), "\n";
  77     }
  78
  79
  80     $self->journal_schema_deploy()
  81         unless $self->journal_no_automatic_deploy;
  82
  83     ## Set up relationship between changeset->user_id and this schema's user
  84     if(!@{$self->journal_user || []})
  85     {
  86         warn "No Journal User set!";
  87         return $schema;
  88     }
  89
  90     $self->_journal_schema->class('ChangeSet')->belongs_to('user', @{$self->journal_user});
  91     $self->_journal_schema->storage->disconnect();
  92
  93     return $schema;
  94 }
  95
  96 sub journal_schema_deploy
  97 {
  98     my ( $self, @args ) = @_;
  99     $self->_journal_schema->deploy( @args );
 100 }
 101
 102 sub get_audit_log_class_name
 103 {
 104     my ($self, $sourcename) = @_;
 105
 106     return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
 107 }
 108
 109 sub get_audit_history_class_name
 110 {
 111     my ($self, $sourcename) = @_;
 112
 113     return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
 114 }
 115
 116 sub create_journal_for
 117 {
 118     my ($self, $s_name) = @_;
 119
 120     my $source = $self->source($s_name);
 121     my $newclass = $self->get_audit_log_class_name($s_name);
 122     DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
 123     $newclass->table(lc($s_name) . "_audit_log");
 124     $self->_journal_schema->register_class("${s_name}AuditLog", $newclass);
 125
 126
 127     my $histclass = $self->get_audit_history_class_name($s_name);
 128     DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
 129     $histclass->table(lc($s_name) . "_audit_history");
 130 #    $histclass->result_source_instance->name(lc($s_name) . "_audit_hisory");
 131     $histclass->add_columns(
 132                             map { $_ => $source->column_info($_) } $source->columns
 133                            );
 134
 135     $self->_journal_schema->register_class("${s_name}AuditHistory", $histclass);
 136 }
 137
 138 sub txn_do
 139 {
 140     my ($self, $code) = @_;
 141
 142     ## Create a new changeset, then run $code as a transaction
 143     my $cs = $self->_journal_schema->resultset('ChangeSet');
 144
 145     $self->txn_begin;
 146     my %changesetdata;
 147     if( defined $self->_journal_schema->current_user() )
 148     {
 149         $changesetdata{user_id} = $self->_journal_schema->current_user();
 150     }
 151     if( defined $self->_journal_schema->current_session() )
 152     {
 153         $changesetdata{session_id} = $self->_journal_schema->current_session();
 154     }
 155
 156 #         (
 157 #           $self->_journal_schema->current_user()
 158 #           ? ( user_id => $self->_journal_schema->current_user())
 159 #           : (),
 160 #           $self->_journal_schema->current_session()
 161 #           ? ( session_id => $self->_journal_schema->current_session() )
 162 #           : ()
 163 #         );
 164     if(!%changesetdata)
 165     {
 166         %changesetdata = ( ID => undef );
 167     }
 168     my $changeset = $cs->create({ %changesetdata });
 169     $self->_journal_schema->current_changeset($changeset->ID);
 170
 171     $self->next::method($code);
 172 }
 173
 174 sub changeset_user
 175 {
 176     my ($self, $userid) = @_;
 177
 178     return $self->_journal_schema->current_user() if(@_ == 1);
 179
 180     $self->_journal_schema->current_user($userid);
 181 }
 182
 183 sub changeset_session
 184 {
 185     my ($self, $sessionid) = @_;
 186
 187     return $self->_journal_schema->current_session() if(@_ == 1);
 188
 189     $self->_journal_schema->current_session($sessionid);
 190 }
 191
 192
 193 1;