2 package Debbugs::DB::Result::BugPackage;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Debbugs::DB::Result::BugPackage
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");
31 __PACKAGE__->table_class("DBIx::Class::ResultSource::View");
33 =head1 TABLE: C<bug_package>
37 __PACKAGE__->table("bug_package");
63 __PACKAGE__->add_columns(
65 { data_type => "integer", is_nullable => 1 },
67 { data_type => "integer", is_nullable => 1 },
69 { data_type => "text", is_nullable => 1 },
71 { data_type => "text", is_nullable => 1 },
75 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-11-30 21:56:51
76 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ok2J+mjxvBcgdiqigiCBQA
78 __PACKAGE__->result_source_instance->view_definition(<<EOF);
79 SELECT b.bug,b.bin_pkg,'binary',bp.pkg FROM bug_binpackage b JOIN bin_pkg bp ON bp.id=b.bin_pkg UNION
80 SELECT s.bug,s.src_pkg,'source',sp.pkg FROM bug_srcpackage s JOIN src_pkg sp ON sp.id=s.src_pkg;
84 # You can replace this text with custom code or comments, and it will be preserved on regeneration