Fix "inserting audit_log twice" bug, start on allowing using the same schema
[dbsrgits/DBIx-Class-Journal.git] / lib / DBIx / Class / Schema / Journal.pm
CommitLineData
f0f14c64 1package DBIx::Class::Schema::Journal;
2
3use base qw/DBIx::Class/;
4
d27ed438 5use Scalar::Util 'blessed';
b5851590 6use DBIx::Class::Schema::Journal::DB;
d27ed438 7
8__PACKAGE__->mk_classdata('journal_storage_type');
9__PACKAGE__->mk_classdata('journal_connection');
f0f14c64 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
f3602465 14sub throw_exception
15{
16}
17
18sub exception_action
19{
20 my $self = shift;
8092c4ed 21# print STDERR Carp::longmess;
f3602465 22
23 $self->next::method(@_);
24}
25
d19af369 26# sub load_classes
27# {
28# my $class = shift;
29
30
31# $class->next::method(@_);
32
33# }
34
b5851590 35sub connection
f0f14c64 36{
37 my $self = shift;
38 $self->next::method(@_);
39
8092c4ed 40# print STDERR join(":", $self->sources), "\n";
a5222e78 41
d19af369 42 my $journal_schema;
43 if(!defined($self->journal_connection))
44 {
45 ## If no connection, use the same schema/storage etc as the user
46 DBIx::Class::Componentised->inject_base(ref $self, 'DBIx::Class::Schema::Journal::DB');
47 $journal_schema = $self;
48 }
49 else
d27ed438 50 {
d19af369 51 $journal_schema = DBIx::Class::Schema::Journal::DB->connect(@{ $self->journal_connection });
52 if($self->journal_storage_type)
53 {
54 $journal_schema->storage_type($self->journal_storage_type);
55 }
d27ed438 56 }
57
58 ## get our own private version of the journaling sources
a5222e78 59 $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
f0f14c64 60
74f04ccc 61 ## Create auditlog+history per table
f0f14c64 62 my %j_sources = @{$self->journal_sources} ? map { $_ => 1 } @{$self->journal_sources} : map { $_ => 1 } $self->sources;
63 foreach my $s_name ($self->sources)
64 {
65 next unless($j_sources{$s_name});
66 $self->create_journal_for($s_name);
c5fba518 67 $self->class($s_name)->load_components('Journal');
a5222e78 68# print STDERR "$s_name :", $self->class($s_name), "\n";
f0f14c64 69 }
70
71 ## Set up relationship between changeset->user_id and this schema's user
72 if(!@{$self->journal_user})
73 {
74 warn "No Journal User set!";
75 return;
76 }
77
f4f0b7c9 78 $self->_journal_schema->deploy();
c5fba518 79 $self->_journal_schema->class('ChangeSet')->belongs_to('user', @{$self->journal_user});
f4f0b7c9 80 $self->_journal_schema->storage->disconnect();
f0f14c64 81}
82
83sub get_audit_log_class_name
84{
85 my ($self, $sourcename) = @_;
86
d27ed438 87 return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
f0f14c64 88}
89
90sub get_audit_history_class_name
91{
92 my ($self, $sourcename) = @_;
93
d27ed438 94 return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
f0f14c64 95}
96
97sub create_journal_for
98{
99 my ($self, $s_name) = @_;
100
101 my $source = $self->source($s_name);
102 my $newclass = $self->get_audit_log_class_name($s_name);
d27ed438 103 DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
c5fba518 104 $newclass->table(lc($s_name) . "_audit_log");
105 $self->_journal_schema->register_class("${s_name}AuditLog", $newclass);
f0f14c64 106
107
c5fba518 108 my $histclass = $self->get_audit_history_class_name($s_name);
d27ed438 109 DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
c5fba518 110 $histclass->table(lc($s_name) . "_audit_history");
111# $histclass->result_source_instance->name(lc($s_name) . "_audit_hisory");
f0f14c64 112 $histclass->add_columns(
f0f14c64 113 map { $_ => $source->column_info($_) } $source->columns
114 );
f0f14c64 115
c5fba518 116 $self->_journal_schema->register_class("${s_name}AuditHistory", $histclass);
f0f14c64 117}
118
f4f0b7c9 119sub txn_do
74f04ccc 120{
121 my ($self, $code) = @_;
122
123 ## Create a new changeset, then run $code as a transaction
f4f0b7c9 124 my $cs = $self->_journal_schema->resultset('ChangeSet');
8092c4ed 125
126 $self->txn_begin;
f3602465 127 my $changeset = $cs->create({ ( $self->_journal_schema->current_user() ? ( user_id => $self->_journal_schema->current_user()) : () ),
128# user_id => $self->_journal_schema->current_user(),
f4f0b7c9 129 session_id => $self->_journal_schema->current_session(),
74f04ccc 130 });
f4f0b7c9 131 $self->_journal_schema->current_changeset($changeset->ID);
74f04ccc 132
f4f0b7c9 133 $self->next::method($code);
74f04ccc 134}
135
f0f14c64 1361;