line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package DBIx::EAV; |
2
|
|
|
|
|
|
|
|
3
|
10
|
|
|
10
|
|
1216178
|
use Moo; |
|
10
|
|
|
|
|
81975
|
|
|
10
|
|
|
|
|
42
|
|
4
|
10
|
|
|
10
|
|
14130
|
use strictures 2; |
|
10
|
|
|
|
|
10990
|
|
|
10
|
|
|
|
|
323
|
|
5
|
10
|
|
|
10
|
|
1593
|
use DBI; |
|
10
|
|
|
|
|
20
|
|
|
10
|
|
|
|
|
284
|
|
6
|
10
|
|
|
10
|
|
6840
|
use Lingua::EN::Inflect (); |
|
10
|
|
|
|
|
179349
|
|
|
10
|
|
|
|
|
399
|
|
7
|
10
|
|
|
10
|
|
67
|
use Data::Dumper; |
|
10
|
|
|
|
|
12
|
|
|
10
|
|
|
|
|
473
|
|
8
|
10
|
|
|
10
|
|
3058
|
use DBIx::EAV::EntityType; |
|
10
|
|
|
|
|
19
|
|
|
10
|
|
|
|
|
279
|
|
9
|
10
|
|
|
10
|
|
3424
|
use DBIx::EAV::Entity; |
|
10
|
|
|
|
|
17
|
|
|
10
|
|
|
|
|
263
|
|
10
|
10
|
|
|
10
|
|
3178
|
use DBIx::EAV::ResultSet; |
|
10
|
|
|
|
|
169
|
|
|
10
|
|
|
|
|
304
|
|
11
|
10
|
|
|
10
|
|
3188
|
use DBIx::EAV::Schema; |
|
10
|
|
|
|
|
22
|
|
|
10
|
|
|
|
|
359
|
|
12
|
10
|
|
|
10
|
|
51
|
use Carp qw' croak confess '; |
|
10
|
|
|
|
|
11
|
|
|
10
|
|
|
|
|
550
|
|
13
|
10
|
|
|
10
|
|
39
|
use Scalar::Util 'blessed'; |
|
10
|
|
|
|
|
12
|
|
|
10
|
|
|
|
|
369
|
|
14
|
10
|
|
|
10
|
|
10228
|
use Class::Load qw' try_load_class '; |
|
0
|
|
|
|
|
|
|
|
0
|
|
|
|
|
|
|
15
|
|
|
|
|
|
|
use namespace::clean; |
16
|
|
|
|
|
|
|
|
17
|
|
|
|
|
|
|
our $VERSION = "0.08"; |
18
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
# required |
20
|
|
|
|
|
|
|
has 'dbh', is => 'ro', required => 1; |
21
|
|
|
|
|
|
|
|
22
|
|
|
|
|
|
|
# options |
23
|
|
|
|
|
|
|
has 'default_attribute_type', is => 'ro', default => 'varchar'; |
24
|
|
|
|
|
|
|
has 'schema_config', is => 'ro', default => sub { {} }; |
25
|
|
|
|
|
|
|
has 'entity_namespaces', is => 'ro', default => sub { [] }; |
26
|
|
|
|
|
|
|
has 'resultset_namespaces', is => 'ro', default => sub { [] }; |
27
|
|
|
|
|
|
|
|
28
|
|
|
|
|
|
|
# internal |
29
|
|
|
|
|
|
|
has 'schema', is => 'ro', lazy => 1, builder => 1, init_arg => undef, handles => [qw/ table dbh_do /]; |
30
|
|
|
|
|
|
|
has '_types', is => 'ro', default => sub { {} }; |
31
|
|
|
|
|
|
|
has '_types_by_id', is => 'ro', default => sub { {} }; |
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
# group schema_config params |
34
|
|
|
|
|
|
|
around BUILDARGS => sub { |
35
|
|
|
|
|
|
|
my ( $orig, $class, @args ) = @_; |
36
|
|
|
|
|
|
|
my $params = @args == 1 && ref $args[0] ? $args[0] : { @args }; |
37
|
|
|
|
|
|
|
my $schema_config = delete $params->{schema_config} || {}; |
38
|
|
|
|
|
|
|
|
39
|
|
|
|
|
|
|
my @schema_params = grep { exists $params->{$_} } qw/ |
40
|
|
|
|
|
|
|
tenant_id data_types database_cascade_delete static_attributes |
41
|
|
|
|
|
|
|
table_prefix id_type default_attribute_type |
42
|
|
|
|
|
|
|
/; |
43
|
|
|
|
|
|
|
|
44
|
|
|
|
|
|
|
@{$schema_config}{@schema_params} = delete @{$params}{@schema_params}; |
45
|
|
|
|
|
|
|
|
46
|
|
|
|
|
|
|
$class->$orig(%$params, schema_config => $schema_config); |
47
|
|
|
|
|
|
|
}; |
48
|
|
|
|
|
|
|
|
49
|
|
|
|
|
|
|
|
50
|
|
|
|
|
|
|
sub _build_schema { |
51
|
|
|
|
|
|
|
my $self = shift; |
52
|
|
|
|
|
|
|
DBIx::EAV::Schema->new(%{$self->schema_config}, dbh => $self->dbh); |
53
|
|
|
|
|
|
|
} |
54
|
|
|
|
|
|
|
|
55
|
|
|
|
|
|
|
sub connect { |
56
|
|
|
|
|
|
|
my ($class, $dsn, $user, $pass, $attrs, $constructor_params) = @_; |
57
|
|
|
|
|
|
|
|
58
|
|
|
|
|
|
|
croak 'Missing $dsn argument for connect()' unless $dsn; |
59
|
|
|
|
|
|
|
|
60
|
|
|
|
|
|
|
croak "connect() must be called as a class method." |
61
|
|
|
|
|
|
|
if ref $class; |
62
|
|
|
|
|
|
|
|
63
|
|
|
|
|
|
|
$constructor_params //= {}; |
64
|
|
|
|
|
|
|
|
65
|
|
|
|
|
|
|
$constructor_params->{dbh} = DBI->connect($dsn, $user, $pass, $attrs) |
66
|
|
|
|
|
|
|
or die $DBI::errstr; |
67
|
|
|
|
|
|
|
|
68
|
|
|
|
|
|
|
$class->new($constructor_params); |
69
|
|
|
|
|
|
|
} |
70
|
|
|
|
|
|
|
|
71
|
|
|
|
|
|
|
sub type { |
72
|
|
|
|
|
|
|
my ($self, $value) = @_; |
73
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
return $self->_types->{$value} |
75
|
|
|
|
|
|
|
if exists $self->_types->{$value}; |
76
|
|
|
|
|
|
|
|
77
|
|
|
|
|
|
|
my $type = $self->_load_type('name', $value); |
78
|
|
|
|
|
|
|
|
79
|
|
|
|
|
|
|
# not registered, try to find a custom entity class and register it |
80
|
|
|
|
|
|
|
if (!$type && (my $entity_class = $self->_resolve_entity_class($value))) { |
81
|
|
|
|
|
|
|
|
82
|
|
|
|
|
|
|
($type) = $self->register_types({$value => $entity_class->type_definition}); |
83
|
|
|
|
|
|
|
} |
84
|
|
|
|
|
|
|
|
85
|
|
|
|
|
|
|
confess "EntityType '$value' does not exist." |
86
|
|
|
|
|
|
|
unless $type; |
87
|
|
|
|
|
|
|
|
88
|
|
|
|
|
|
|
$type; |
89
|
|
|
|
|
|
|
} |
90
|
|
|
|
|
|
|
|
91
|
|
|
|
|
|
|
sub type_by_id { |
92
|
|
|
|
|
|
|
my ($self, $value) = @_; |
93
|
|
|
|
|
|
|
|
94
|
|
|
|
|
|
|
return $self->_types_by_id->{$value} |
95
|
|
|
|
|
|
|
if exists $self->_types_by_id->{$value}; |
96
|
|
|
|
|
|
|
|
97
|
|
|
|
|
|
|
$self->_load_type('id', $value) |
98
|
|
|
|
|
|
|
or confess "EntityType 'id=$value' does not exist."; |
99
|
|
|
|
|
|
|
} |
100
|
|
|
|
|
|
|
|
101
|
|
|
|
|
|
|
sub _load_type { |
102
|
|
|
|
|
|
|
my ($self, $field, $value) = @_; |
103
|
|
|
|
|
|
|
|
104
|
|
|
|
|
|
|
my $type_row = $self->table('entity_types')->select_one({ $field => $value }); |
105
|
|
|
|
|
|
|
return unless $type_row; |
106
|
|
|
|
|
|
|
|
107
|
|
|
|
|
|
|
my $type = DBIx::EAV::EntityType->load({ %$type_row, core => $self}); |
108
|
|
|
|
|
|
|
$self->_types->{$type->name} = $type; |
109
|
|
|
|
|
|
|
$self->_types_by_id->{$type->id} = $type; |
110
|
|
|
|
|
|
|
$type; |
111
|
|
|
|
|
|
|
} |
112
|
|
|
|
|
|
|
|
113
|
|
|
|
|
|
|
sub _resolve_entity_class { |
114
|
|
|
|
|
|
|
my ($self, $name) = @_; |
115
|
|
|
|
|
|
|
|
116
|
|
|
|
|
|
|
foreach my $ns (@{ $self->entity_namespaces }) { |
117
|
|
|
|
|
|
|
|
118
|
|
|
|
|
|
|
my $entity_class = join '::', $ns, $name; |
119
|
|
|
|
|
|
|
my ($is_loaded, $error) = try_load_class $entity_class; |
120
|
|
|
|
|
|
|
|
121
|
|
|
|
|
|
|
return $entity_class if $is_loaded; |
122
|
|
|
|
|
|
|
|
123
|
|
|
|
|
|
|
# rethrow compilation errors |
124
|
|
|
|
|
|
|
die $error if $error =~ /^Can't locate .* in \@INC/; |
125
|
|
|
|
|
|
|
} |
126
|
|
|
|
|
|
|
|
127
|
|
|
|
|
|
|
return; |
128
|
|
|
|
|
|
|
} |
129
|
|
|
|
|
|
|
|
130
|
|
|
|
|
|
|
sub _resolve_resultset_class { |
131
|
|
|
|
|
|
|
my ($self, $name) = @_; |
132
|
|
|
|
|
|
|
|
133
|
|
|
|
|
|
|
foreach my $ns (@{ $self->resultset_namespaces }) { |
134
|
|
|
|
|
|
|
|
135
|
|
|
|
|
|
|
my $class = join '::', $ns, $name; |
136
|
|
|
|
|
|
|
my ($is_loaded, $error) = try_load_class $class; |
137
|
|
|
|
|
|
|
|
138
|
|
|
|
|
|
|
return $class if $is_loaded; |
139
|
|
|
|
|
|
|
|
140
|
|
|
|
|
|
|
# rethrow compilation errors |
141
|
|
|
|
|
|
|
die $class; |
142
|
|
|
|
|
|
|
} |
143
|
|
|
|
|
|
|
|
144
|
|
|
|
|
|
|
return; |
145
|
|
|
|
|
|
|
} |
146
|
|
|
|
|
|
|
|
147
|
|
|
|
|
|
|
sub resultset { |
148
|
|
|
|
|
|
|
my ($self, $name) = @_; |
149
|
|
|
|
|
|
|
|
150
|
|
|
|
|
|
|
my $rs_class = $self->_resolve_resultset_class($name) |
151
|
|
|
|
|
|
|
|| 'DBIx::EAV::ResultSet'; |
152
|
|
|
|
|
|
|
|
153
|
|
|
|
|
|
|
$rs_class->new({ |
154
|
|
|
|
|
|
|
eav => $self, |
155
|
|
|
|
|
|
|
type => $self->type($name), |
156
|
|
|
|
|
|
|
}); |
157
|
|
|
|
|
|
|
} |
158
|
|
|
|
|
|
|
|
159
|
|
|
|
|
|
|
|
160
|
|
|
|
|
|
|
sub register_types { |
161
|
|
|
|
|
|
|
my ($self, $schema) = @_; |
162
|
|
|
|
|
|
|
my %skip; |
163
|
|
|
|
|
|
|
|
164
|
|
|
|
|
|
|
# register only not-installed entities to |
165
|
|
|
|
|
|
|
# allow multiple calls to this method |
166
|
|
|
|
|
|
|
my @new_types = grep { not exists $self->_types->{$_} } keys %$schema; |
167
|
|
|
|
|
|
|
|
168
|
|
|
|
|
|
|
# create or update each entity type on database |
169
|
|
|
|
|
|
|
my @registered_types; |
170
|
|
|
|
|
|
|
foreach my $name (@new_types) { |
171
|
|
|
|
|
|
|
next if exists $self->_types->{$name}; |
172
|
|
|
|
|
|
|
push @registered_types, |
173
|
|
|
|
|
|
|
$self->_register_entity_type($name, $schema->{$name}, $schema); |
174
|
|
|
|
|
|
|
} |
175
|
|
|
|
|
|
|
|
176
|
|
|
|
|
|
|
# register relationships |
177
|
|
|
|
|
|
|
foreach my $name (@new_types) { |
178
|
|
|
|
|
|
|
|
179
|
|
|
|
|
|
|
my $spec = $schema->{$name}; |
180
|
|
|
|
|
|
|
my $entity_type = $self->type($name); |
181
|
|
|
|
|
|
|
|
182
|
|
|
|
|
|
|
foreach my $reltype (qw/ has_one has_many many_to_many /) { |
183
|
|
|
|
|
|
|
|
184
|
|
|
|
|
|
|
next unless defined $spec->{$reltype}; |
185
|
|
|
|
|
|
|
|
186
|
|
|
|
|
|
|
$spec->{$reltype} ||= []; |
187
|
|
|
|
|
|
|
$spec->{$reltype} = [$spec->{$reltype}] |
188
|
|
|
|
|
|
|
unless ref $spec->{$reltype} eq 'ARRAY'; |
189
|
|
|
|
|
|
|
|
190
|
|
|
|
|
|
|
foreach my $rel (@{$spec->{$reltype}}) { |
191
|
|
|
|
|
|
|
$entity_type->register_relationship($reltype, $rel); |
192
|
|
|
|
|
|
|
} |
193
|
|
|
|
|
|
|
} |
194
|
|
|
|
|
|
|
} |
195
|
|
|
|
|
|
|
|
196
|
|
|
|
|
|
|
@registered_types; |
197
|
|
|
|
|
|
|
} |
198
|
|
|
|
|
|
|
|
199
|
|
|
|
|
|
|
|
200
|
|
|
|
|
|
|
sub _register_entity_type { |
201
|
|
|
|
|
|
|
my ($self, $name, $spec, $schema) = @_; |
202
|
|
|
|
|
|
|
|
203
|
|
|
|
|
|
|
# parent type first |
204
|
|
|
|
|
|
|
my $parent_type; |
205
|
|
|
|
|
|
|
if ($spec->{extends}) { |
206
|
|
|
|
|
|
|
|
207
|
|
|
|
|
|
|
unless ($parent_type = $self->_types->{$spec->{extends}}) { |
208
|
|
|
|
|
|
|
|
209
|
|
|
|
|
|
|
die "Unknown type '$spec->{extends}' specified in 'extents' option for type '$name'." |
210
|
|
|
|
|
|
|
unless exists $schema->{$spec->{extends}}; |
211
|
|
|
|
|
|
|
|
212
|
|
|
|
|
|
|
$parent_type = $self->_register_entity_type($spec->{extends}, $schema->{$spec->{extends}}, $schema); |
213
|
|
|
|
|
|
|
} |
214
|
|
|
|
|
|
|
} |
215
|
|
|
|
|
|
|
|
216
|
|
|
|
|
|
|
# find or create entity type |
217
|
|
|
|
|
|
|
my $types_table = $self->table('entity_types'); |
218
|
|
|
|
|
|
|
my $hierarchy_table = $self->table('type_hierarchy'); |
219
|
|
|
|
|
|
|
my $type = $types_table->select_one({ name => $name }); |
220
|
|
|
|
|
|
|
|
221
|
|
|
|
|
|
|
if (defined $type) { |
222
|
|
|
|
|
|
|
|
223
|
|
|
|
|
|
|
# change parent |
224
|
|
|
|
|
|
|
} |
225
|
|
|
|
|
|
|
else { |
226
|
|
|
|
|
|
|
|
227
|
|
|
|
|
|
|
# TODO implement rename |
228
|
|
|
|
|
|
|
# if ($spec->{rename_from}) { ... } |
229
|
|
|
|
|
|
|
|
230
|
|
|
|
|
|
|
my $id = $types_table->insert({ name => $name }); |
231
|
|
|
|
|
|
|
$type = $types_table->select_one({ id => $id }); |
232
|
|
|
|
|
|
|
die "Error inserting entity type '$name'!" unless $type; |
233
|
|
|
|
|
|
|
|
234
|
|
|
|
|
|
|
if ($parent_type) { |
235
|
|
|
|
|
|
|
$hierarchy_table->insert({ |
236
|
|
|
|
|
|
|
parent_type_id => $parent_type->{id}, |
237
|
|
|
|
|
|
|
child_type_id => $type->{id} |
238
|
|
|
|
|
|
|
}); |
239
|
|
|
|
|
|
|
|
240
|
|
|
|
|
|
|
$type->{parent} = $parent_type; |
241
|
|
|
|
|
|
|
} |
242
|
|
|
|
|
|
|
} |
243
|
|
|
|
|
|
|
|
244
|
|
|
|
|
|
|
# update or create attributes |
245
|
|
|
|
|
|
|
my $attributes = $self->table('attributes'); |
246
|
|
|
|
|
|
|
my %static_attributes = map { $_ => {name => $_, is_static => 1} } @{$self->table('entities')->columns}; |
247
|
|
|
|
|
|
|
$type->{attributes} = {}; |
248
|
|
|
|
|
|
|
|
249
|
|
|
|
|
|
|
my %inherited_attributes = $parent_type ? map { $_->{name} => $_ } $parent_type->attributes( no_static => 1 ) |
250
|
|
|
|
|
|
|
: (); |
251
|
|
|
|
|
|
|
|
252
|
|
|
|
|
|
|
foreach my $attr_spec (@{$spec->{attributes}}) { |
253
|
|
|
|
|
|
|
|
254
|
|
|
|
|
|
|
# expand string to name/type |
255
|
|
|
|
|
|
|
unless (ref $attr_spec) { |
256
|
|
|
|
|
|
|
my ($name, $type) = split ':', $attr_spec; |
257
|
|
|
|
|
|
|
$attr_spec = { |
258
|
|
|
|
|
|
|
name => $name, |
259
|
|
|
|
|
|
|
type => $type || $self->default_attribute_type |
260
|
|
|
|
|
|
|
}; |
261
|
|
|
|
|
|
|
} |
262
|
|
|
|
|
|
|
|
263
|
|
|
|
|
|
|
die sprintf("Error registering attribute '%s' for entity '%s'. Can't use names of static attributes (real table columns).", $attr_spec->{name}, $type->{name}) |
264
|
|
|
|
|
|
|
if exists $static_attributes{$attr_spec->{name}}; |
265
|
|
|
|
|
|
|
|
266
|
|
|
|
|
|
|
printf STDERR "[warn] entity '%s' is overriding inherited attribute '%s'", $name, $attr_spec->{name} |
267
|
|
|
|
|
|
|
if $inherited_attributes{$attr_spec->{name}}; |
268
|
|
|
|
|
|
|
|
269
|
|
|
|
|
|
|
my $attr = $attributes->select_one({ |
270
|
|
|
|
|
|
|
entity_type_id => $type->{id}, |
271
|
|
|
|
|
|
|
name => $attr_spec->{name} |
272
|
|
|
|
|
|
|
}); |
273
|
|
|
|
|
|
|
|
274
|
|
|
|
|
|
|
if (defined $attr) { |
275
|
|
|
|
|
|
|
# update |
276
|
|
|
|
|
|
|
} |
277
|
|
|
|
|
|
|
else { |
278
|
|
|
|
|
|
|
delete $attr_spec->{id}; # safety |
279
|
|
|
|
|
|
|
|
280
|
|
|
|
|
|
|
my %data = %$attr_spec; |
281
|
|
|
|
|
|
|
|
282
|
|
|
|
|
|
|
$data{entity_type_id} = $type->{id}; |
283
|
|
|
|
|
|
|
$data{data_type} = delete($data{type}) || $self->default_attribute_type; |
284
|
|
|
|
|
|
|
|
285
|
|
|
|
|
|
|
die sprintf("Attribute '%s' has unknown data type '%s'.", $data{name}, $data{data_type}) |
286
|
|
|
|
|
|
|
unless $self->schema->has_data_type($data{data_type}); |
287
|
|
|
|
|
|
|
|
288
|
|
|
|
|
|
|
$attributes->insert(\%data); |
289
|
|
|
|
|
|
|
$attr = $attributes->select_one(\%data); |
290
|
|
|
|
|
|
|
die "Error inserting attribute '$attr_spec->{name}'!" unless $attr; |
291
|
|
|
|
|
|
|
} |
292
|
|
|
|
|
|
|
|
293
|
|
|
|
|
|
|
$type->{attributes}{$attr->{name}} = $attr; |
294
|
|
|
|
|
|
|
} |
295
|
|
|
|
|
|
|
|
296
|
|
|
|
|
|
|
$self->_types->{$name} = |
297
|
|
|
|
|
|
|
$self->_types_by_id->{$type->{id}} = DBIx::EAV::EntityType->new(%$type, core => $self); |
298
|
|
|
|
|
|
|
} |
299
|
|
|
|
|
|
|
|
300
|
|
|
|
|
|
|
|
301
|
|
|
|
|
|
|
|
302
|
|
|
|
|
|
|
1; |
303
|
|
|
|
|
|
|
|
304
|
|
|
|
|
|
|
__END__ |