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