2 package Debbugs::DB::Result::BugStatus;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Debbugs::DB::Result::BugStatus
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_status>
37 __PACKAGE__->table("bug_status");
38 __PACKAGE__->result_source_instance->view_definition(" SELECT b.id,\n b.id AS bug_num,\n string_agg(t.tag, ','::text) AS tags,\n b.subject,\n ( SELECT s.severity\n FROM severity s\n WHERE (s.id = b.severity)) AS severity,\n ( SELECT string_agg(package.package, ','::text ORDER BY package.package) AS string_agg\n FROM ( SELECT bp.pkg AS package\n FROM (bug_binpackage bbp\n JOIN bin_pkg bp ON ((bbp.bin_pkg = bp.id)))\n WHERE (bbp.bug = b.id)\n UNION\n SELECT concat('src:', sp.pkg) AS package\n FROM (bug_srcpackage bsp\n JOIN src_pkg sp ON ((bsp.src_pkg = sp.id)))\n WHERE (bsp.bug = b.id)) package) AS package,\n b.submitter_full AS originator,\n date_part('epoch'::text, b.log_modified) AS log_modified,\n date_part('epoch'::text, b.creation) AS date,\n date_part('epoch'::text, b.last_modified) AS last_modified,\n b.done_full AS done,\n string_agg((bb.blocks)::text, ' '::text ORDER BY bb.blocks) AS blocks,\n string_agg((bbb.bug)::text, ' '::text ORDER BY bbb.bug) AS blockedby,\n ( SELECT string_agg((bug.bug)::text, ' '::text ORDER BY bug.bug) AS string_agg\n FROM ( SELECT bm.merged AS bug\n FROM bug_merged bm\n WHERE (bm.bug = b.id)\n UNION\n SELECT bm.bug\n FROM bug_merged bm\n WHERE (bm.merged = b.id)) bug) AS mergedwith,\n ( SELECT string_agg(bv.ver_string, ' '::text) AS string_agg\n FROM bug_ver bv\n WHERE ((bv.bug = b.id) AND (bv.found IS TRUE))) AS found_versions,\n ( SELECT string_agg(bv.ver_string, ' '::text) AS string_agg\n FROM bug_ver bv\n WHERE ((bv.bug = b.id) AND (bv.found IS FALSE))) AS fixed_versions\n FROM ((((bug b\n LEFT JOIN bug_tag bt ON ((bt.bug = b.id)))\n LEFT JOIN tag t ON ((bt.tag = t.id)))\n LEFT JOIN bug_blocks bb ON ((bb.bug = b.id)))\n LEFT JOIN bug_blocks bbb ON ((bbb.blocks = b.id)))\n GROUP BY b.id");
79 data_type: 'double precision'
84 data_type: 'double precision'
89 data_type: 'double precision'
112 =head2 found_versions
117 =head2 fixed_versions
124 __PACKAGE__->add_columns(
126 { data_type => "integer", is_nullable => 1 },
128 { data_type => "integer", is_nullable => 1 },
130 { data_type => "text", is_nullable => 1 },
132 { data_type => "text", is_nullable => 1 },
134 { data_type => "text", is_nullable => 1 },
136 { data_type => "text", is_nullable => 1 },
138 { data_type => "text", is_nullable => 1 },
140 { data_type => "double precision", is_nullable => 1 },
142 { data_type => "double precision", is_nullable => 1 },
144 { data_type => "double precision", is_nullable => 1 },
146 { data_type => "text", is_nullable => 1 },
148 { data_type => "text", is_nullable => 1 },
150 { data_type => "text", is_nullable => 1 },
152 { data_type => "text", is_nullable => 1 },
154 { data_type => "text", is_nullable => 1 },
156 { data_type => "text", is_nullable => 1 },
160 # Created by DBIx::Class::Schema::Loader v0.07048 @ 2018-04-16 14:58:16
161 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0my1krU3Y/icl24IUojITw
164 # You can replace this text with custom code or comments, and it will be preserved on regeneration