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