2 package Debbugs::DB::Result::Bug;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Debbugs::DB::Result::Bug - Bugs
16 use base 'DBIx::Class::Core';
18 =head1 COMPONENTS LOADED
22 =item * L<DBIx::Class::InflateColumn::DateTime>
24 =item * L<DBIx::Class::TimeStamp>
30 __PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp");
36 __PACKAGE__->table("bug");
49 data_type: 'timestamp with time zone'
50 default_value: current_timestamp
52 original: {default_value => \"now()"}
58 data_type: 'timestamp with time zone'
59 default_value: current_timestamp
61 original: {default_value => \"now()"}
63 Time bug log was last modified
67 data_type: 'timestamp with time zone'
68 default_value: current_timestamp
70 original: {default_value => \"now()"}
72 Time bug status was last modified
80 True if bug has been archived
84 data_type: 'timestamp with time zone'
87 Time bug was last unarchived; null if bug has never been unarchived
92 default_value: (empty string)
95 Where bug has been forwarded to; empty if it has not been forwarded
100 default_value: (empty string)
103 Summary of the bug; empty if it has no summary
108 default_value: (empty string)
111 Outlook of the bug; empty if it has no outlook
132 Individual who did the -done; empty if it has never been -done
137 default_value: (empty string)
146 Individual who owns this bug; empty if no one owns it
151 default_value: (empty string)
160 Individual who submitted this bug; empty if there is no submitter
162 =head2 submitter_full
165 default_value: (empty string)
168 =head2 unknown_packages
171 default_value: (empty string)
174 Package name if the package is not known
176 =head2 unknown_affects
179 default_value: (empty string)
182 Package name if the affected package is not known
186 __PACKAGE__->add_columns(
188 { data_type => "integer", is_nullable => 0 },
191 data_type => "timestamp with time zone",
192 default_value => \"current_timestamp",
194 original => { default_value => \"now()" },
198 data_type => "timestamp with time zone",
199 default_value => \"current_timestamp",
201 original => { default_value => \"now()" },
205 data_type => "timestamp with time zone",
206 default_value => \"current_timestamp",
208 original => { default_value => \"now()" },
211 { data_type => "boolean", default_value => \"false", is_nullable => 0 },
213 { data_type => "timestamp with time zone", is_nullable => 1 },
215 { data_type => "text", default_value => "", is_nullable => 0 },
217 { data_type => "text", default_value => "", is_nullable => 0 },
219 { data_type => "text", default_value => "", is_nullable => 0 },
221 { data_type => "text", is_nullable => 0 },
223 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
225 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
227 { data_type => "text", default_value => "", is_nullable => 0 },
229 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
231 { data_type => "text", default_value => "", is_nullable => 0 },
233 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
235 { data_type => "text", default_value => "", is_nullable => 0 },
237 { data_type => "text", default_value => "", is_nullable => 0 },
239 { data_type => "text", default_value => "", is_nullable => 0 },
252 __PACKAGE__->set_primary_key("id");
256 =head2 bug_affects_binpackages
260 Related object: L<Debbugs::DB::Result::BugAffectsBinpackage>
264 __PACKAGE__->has_many(
265 "bug_affects_binpackages",
266 "Debbugs::DB::Result::BugAffectsBinpackage",
267 { "foreign.bug" => "self.id" },
268 { cascade_copy => 0, cascade_delete => 0 },
271 =head2 bug_affects_srcpackages
275 Related object: L<Debbugs::DB::Result::BugAffectsSrcpackage>
279 __PACKAGE__->has_many(
280 "bug_affects_srcpackages",
281 "Debbugs::DB::Result::BugAffectsSrcpackage",
282 { "foreign.bug" => "self.id" },
283 { cascade_copy => 0, cascade_delete => 0 },
286 =head2 bug_binpackages
290 Related object: L<Debbugs::DB::Result::BugBinpackage>
294 __PACKAGE__->has_many(
296 "Debbugs::DB::Result::BugBinpackage",
297 { "foreign.bug" => "self.id" },
298 { cascade_copy => 0, cascade_delete => 0 },
301 =head2 bug_blocks_blocks
305 Related object: L<Debbugs::DB::Result::BugBlock>
309 __PACKAGE__->has_many(
311 "Debbugs::DB::Result::BugBlock",
312 { "foreign.blocks" => "self.id" },
313 { cascade_copy => 0, cascade_delete => 0 },
316 =head2 bug_blocks_bugs
320 Related object: L<Debbugs::DB::Result::BugBlock>
324 __PACKAGE__->has_many(
326 "Debbugs::DB::Result::BugBlock",
327 { "foreign.bug" => "self.id" },
328 { cascade_copy => 0, cascade_delete => 0 },
331 =head2 bug_merged_bugs
335 Related object: L<Debbugs::DB::Result::BugMerged>
339 __PACKAGE__->has_many(
341 "Debbugs::DB::Result::BugMerged",
342 { "foreign.bug" => "self.id" },
343 { cascade_copy => 0, cascade_delete => 0 },
346 =head2 bug_mergeds_merged
350 Related object: L<Debbugs::DB::Result::BugMerged>
354 __PACKAGE__->has_many(
355 "bug_mergeds_merged",
356 "Debbugs::DB::Result::BugMerged",
357 { "foreign.merged" => "self.id" },
358 { cascade_copy => 0, cascade_delete => 0 },
365 Related object: L<Debbugs::DB::Result::BugMessage>
369 __PACKAGE__->has_many(
371 "Debbugs::DB::Result::BugMessage",
372 { "foreign.bug" => "self.id" },
373 { cascade_copy => 0, cascade_delete => 0 },
376 =head2 bug_srcpackages
380 Related object: L<Debbugs::DB::Result::BugSrcpackage>
384 __PACKAGE__->has_many(
386 "Debbugs::DB::Result::BugSrcpackage",
387 { "foreign.bug" => "self.id" },
388 { cascade_copy => 0, cascade_delete => 0 },
391 =head2 bug_status_caches
395 Related object: L<Debbugs::DB::Result::BugStatusCache>
399 __PACKAGE__->has_many(
401 "Debbugs::DB::Result::BugStatusCache",
402 { "foreign.bug" => "self.id" },
403 { cascade_copy => 0, cascade_delete => 0 },
410 Related object: L<Debbugs::DB::Result::BugTag>
414 __PACKAGE__->has_many(
416 "Debbugs::DB::Result::BugTag",
417 { "foreign.bug" => "self.id" },
418 { cascade_copy => 0, cascade_delete => 0 },
425 Related object: L<Debbugs::DB::Result::BugUserTag>
429 __PACKAGE__->has_many(
431 "Debbugs::DB::Result::BugUserTag",
432 { "foreign.bug" => "self.id" },
433 { cascade_copy => 0, cascade_delete => 0 },
440 Related object: L<Debbugs::DB::Result::BugVer>
444 __PACKAGE__->has_many(
446 "Debbugs::DB::Result::BugVer",
447 { "foreign.bug" => "self.id" },
448 { cascade_copy => 0, cascade_delete => 0 },
455 Related object: L<Debbugs::DB::Result::Correspondent>
459 __PACKAGE__->belongs_to(
461 "Debbugs::DB::Result::Correspondent",
466 on_delete => "NO ACTION",
467 on_update => "NO ACTION",
475 Related object: L<Debbugs::DB::Result::Correspondent>
479 __PACKAGE__->belongs_to(
481 "Debbugs::DB::Result::Correspondent",
486 on_delete => "NO ACTION",
487 on_update => "NO ACTION",
495 Related object: L<Debbugs::DB::Result::Severity>
499 __PACKAGE__->belongs_to(
501 "Debbugs::DB::Result::Severity",
502 { id => "severity" },
503 { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
510 Related object: L<Debbugs::DB::Result::Correspondent>
514 __PACKAGE__->belongs_to(
516 "Debbugs::DB::Result::Correspondent",
517 { id => "submitter" },
521 on_delete => "NO ACTION",
522 on_update => "NO ACTION",
527 # Created by DBIx::Class::Schema::Loader v0.07048 @ 2018-04-11 13:06:55
528 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qxkLXbv8JGoV9reebbOUEw
531 use List::AllUtils qw(uniq);
533 __PACKAGE__->many_to_many(tags => 'bug_tags','tag');
534 __PACKAGE__->many_to_many(user_tags => 'bug_user_tags','user_tag');
535 __PACKAGE__->many_to_many(srcpackages => 'bug_srcpackages','src_pkg');
536 __PACKAGE__->many_to_many(binpackages => 'bug_binpackages','bin_pkg');
537 __PACKAGE__->many_to_many(affects_binpackages => 'bug_affects_binpackages','bin_pkg');
538 __PACKAGE__->many_to_many(affects_srcpackages => 'bug_affects_srcpackages','src_pkg');
539 __PACKAGE__->many_to_many(messages => 'bug_messages','message');
541 sub sqlt_deploy_hook {
542 my ($self, $sqlt_table) = @_;
543 # CREATE INDEX bug_idx_owner ON bug(owner);
544 # CREATE INDEX bug_idx_submitter ON bug(submitter);
545 # CREATE INDEX bug_idx_done ON bug(done);
546 # CREATE INDEX bug_idx_forwarded ON bug(forwarded);
547 # CREATE INDEX bug_idx_last_modified ON bug(last_modified);
548 # CREATE INDEX bug_idx_severity ON bug(severity);
549 # CREATE INDEX bug_idx_creation ON bug(creation);
550 # CREATE INDEX bug_idx_log_modified ON bug(log_modified);
551 for my $idx (qw(owner submitter done forwarded last_modified),
552 qw(severity creation log_modified),
554 $sqlt_table->add_index(name => 'bug_idx'.$idx,
559 =head1 Utility Functions
563 =head2 set_related_packages
565 $b->set_related_packages($relationship,
570 Set bug-related packages.
574 sub set_related_packages {
575 my ($self,$relationship,$pkgs,$pkg_cache) = @_;
579 if ($relationship =~ /binpackages/) {
580 for my $pkg (@{$pkgs}) {
582 $self->result_source->schema->resultset('BinPkg')->
583 get_bin_pkg_id($pkg);
584 if (not defined $pkg_id) {
585 push @unset_packages,$pkg;
587 push @pkg_ids, $pkg_id;
590 } elsif ($relationship =~ /srcpackages/) {
591 for my $pkg (@{$pkgs}) {
593 $self->result_source->schema->resultset('SrcPkg')->
594 get_src_pkg_id($pkg);
595 if (not defined $pkg_id) {
596 push @unset_packages,$pkg;
598 push @pkg_ids,$pkg_id;
602 croak "Unsupported relationship $relationship";
604 @pkg_ids = uniq @pkg_ids;
605 if ($relationship eq 'binpackages') {
606 $self->set_binpackages([map {{id => $_}} @pkg_ids]);
607 } elsif ($relationship eq 'srcpackages') {
608 $self->set_srcpackages([map {{id => $_}} @pkg_ids]);
609 } elsif ($relationship eq 'affects_binpackages') {
610 $self->set_affects_binpackages([map {{id => $_}} @pkg_ids]);
611 } elsif ($relationship eq 'affects_srcpackages') {
612 $self->set_affects_srcpackages([map {{id => $_}} @pkg_ids]);
614 croak "Unsupported relationship $relationship";
616 return @unset_packages
618 # You can replace this text with custom code or comments, and it will be preserved on regeneration