1 package DBIx::Class::Schema::Journal;
3 use base qw/DBIx::Class/;
5 use Scalar::Util 'blessed';
6 use DBIx::Class::Schema::Journal::DB;
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');
14 our $VERSION = '0.01';
23 # print STDERR Carp::longmess;
25 $self->next::method(@_);
33 # $class->next::method(@_);
40 $self->next::method(@_);
42 # print STDERR join(":", $self->sources), "\n";
45 if(!defined($self->journal_connection))
47 ## If no connection, use the same schema/storage etc as the user
48 DBIx::Class::Componentised->inject_base(ref $self, 'DBIx::Class::Schema::Journal::DB');
49 $journal_schema = $self;
53 $journal_schema = DBIx::Class::Schema::Journal::DB->connect(@{ $self->journal_connection });
54 if($self->journal_storage_type)
56 $journal_schema->storage_type($self->journal_storage_type);
60 ## get our own private version of the journaling sources
61 $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
63 ## Create auditlog+history per table
64 my %j_sources = @{$self->journal_sources} ? map { $_ => 1 } @{$self->journal_sources} : map { $_ => 1 } $self->sources;
65 foreach my $s_name ($self->sources)
67 next unless($j_sources{$s_name});
68 $self->create_journal_for($s_name);
69 $self->class($s_name)->load_components('Journal');
70 # print STDERR "$s_name :", $self->class($s_name), "\n";
73 ## Set up relationship between changeset->user_id and this schema's user
74 if(!@{$self->journal_user})
76 warn "No Journal User set!";
80 $self->_journal_schema->deploy();
81 $self->_journal_schema->class('ChangeSet')->belongs_to('user', @{$self->journal_user});
82 $self->_journal_schema->storage->disconnect();
85 sub get_audit_log_class_name
87 my ($self, $sourcename) = @_;
89 return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
92 sub get_audit_history_class_name
94 my ($self, $sourcename) = @_;
96 return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
99 sub create_journal_for
101 my ($self, $s_name) = @_;
103 my $source = $self->source($s_name);
104 my $newclass = $self->get_audit_log_class_name($s_name);
105 DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
106 $newclass->table(lc($s_name) . "_audit_log");
107 $self->_journal_schema->register_class("${s_name}AuditLog", $newclass);
110 my $histclass = $self->get_audit_history_class_name($s_name);
111 DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
112 $histclass->table(lc($s_name) . "_audit_history");
113 # $histclass->result_source_instance->name(lc($s_name) . "_audit_hisory");
114 $histclass->add_columns(
115 map { $_ => $source->column_info($_) } $source->columns
118 $self->_journal_schema->register_class("${s_name}AuditHistory", $histclass);
123 my ($self, $code) = @_;
125 ## Create a new changeset, then run $code as a transaction
126 my $cs = $self->_journal_schema->resultset('ChangeSet');
129 my $changeset = $cs->create({ ( $self->_journal_schema->current_user() ? ( user_id => $self->_journal_schema->current_user()) : () ),
130 # user_id => $self->_journal_schema->current_user(),
131 session_id => $self->_journal_schema->current_session(),
133 $self->_journal_schema->current_changeset($changeset->ID);
135 $self->next::method($code);