Fix "inserting audit_log twice" bug, start on allowing using the same schema
[dbsrgits/DBIx-Class-Journal.git] / 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_sources'); ## [ source names ]
11 __PACKAGE__->mk_classdata('journal_user'); ## [ class, field for user id ]
12 __PACKAGE__->mk_classdata('_journal_schema');
13
14 sub throw_exception
15 {
16 }
17
18 sub exception_action
19 {
20     my $self = shift;
21 #    print STDERR Carp::longmess;
22     
23     $self->next::method(@_);
24 }
25
26 # sub load_classes
27 # {
28 #     my $class = shift;
29
30
31 #     $class->next::method(@_);
32     
33 # }
34
35 sub connection
36 {
37     my $self = shift;
38     $self->next::method(@_);
39
40 #   print STDERR join(":", $self->sources), "\n";
41
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
50     {
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         }
56     }
57
58     ## get our own private version of the journaling sources
59    $self->_journal_schema($journal_schema->compose_namespace(blessed($self) . '::Journal'));
60
61     ## Create auditlog+history per table
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);
67         $self->class($s_name)->load_components('Journal');
68 #        print STDERR "$s_name :", $self->class($s_name), "\n";
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
78     $self->_journal_schema->deploy();
79     $self->_journal_schema->class('ChangeSet')->belongs_to('user', @{$self->journal_user});
80     $self->_journal_schema->storage->disconnect();
81 }
82
83 sub get_audit_log_class_name
84 {
85     my ($self, $sourcename) = @_;
86
87     return blessed($self->_journal_schema) . "::${sourcename}AuditLog";
88 }
89
90 sub get_audit_history_class_name
91 {
92     my ($self, $sourcename) = @_;
93
94     return blessed($self->_journal_schema) . "::${sourcename}AuditHistory";
95 }
96
97 sub 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);
103     DBIx::Class::Componentised->inject_base($newclass, 'DBIx::Class::Schema::Journal::DB::AuditLog');
104     $newclass->table(lc($s_name) . "_audit_log");
105     $self->_journal_schema->register_class("${s_name}AuditLog", $newclass);
106                            
107
108     my $histclass = $self->get_audit_history_class_name($s_name);
109     DBIx::Class::Componentised->inject_base($histclass, 'DBIx::Class::Schema::Journal::DB::AuditHistory');
110     $histclass->table(lc($s_name) . "_audit_history");
111 #    $histclass->result_source_instance->name(lc($s_name) . "_audit_hisory");
112     $histclass->add_columns(
113                             map { $_ => $source->column_info($_) } $source->columns
114                            );
115                            
116     $self->_journal_schema->register_class("${s_name}AuditHistory", $histclass);
117 }
118
119 sub txn_do
120 {
121     my ($self, $code) = @_;
122
123     ## Create a new changeset, then run $code as a transaction
124     my $cs = $self->_journal_schema->resultset('ChangeSet');
125
126     $self->txn_begin;
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(),
129         session_id => $self->_journal_schema->current_session(),
130     });
131     $self->_journal_schema->current_changeset($changeset->ID);
132
133     $self->next::method($code);
134 }
135
136 1;