William Grant has proposed merging
lp:~wgrant/launchpad/bugtaskflat-by-default-0 into lp:launchpad.
Requested reviews:
Launchpad code reviewers (launchpad-reviewers)
For more details, see:
https://code.launchpad.net/~wgrant/launchpad/bugtaskflat-by-default-0/+merge/103612
This is the first piece of preparation for making BugTaskFlat the default
search method. Sampledata has been populated by the garbo job, and two tests
have been fixed to work with either mode. xx-person-subscriptions.txt ordered
two bugs created at the same time by date_last_updated, and xx-security.txt
wasn't setting information_type.
--
https://code.launchpad.net/~wgrant/launchpad/bugtaskflat-by-default-0/+merge/103612
Your team Launchpad code reviewers is requested to review the proposed merge of
lp:~wgrant/launchpad/bugtaskflat-by-default-0 into lp:launchpad.
=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql 2012-04-24 13:35:22 +0000
+++ database/sampledata/current-dev.sql 2012-04-26 06:52:19 +0000
@@ -3677,6 +3677,41 @@
ALTER TABLE bugtask ENABLE TRIGGER ALL;
+ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
+
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (3, 2, '2004-01-03 03:49:22.908491', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, 1, NULL, NULL, NULL, NULL, 10, 20, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (4, 1, '2004-01-04 03:49:22.79024', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 3, NULL, 1, 20, 20, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (5, 2, '2004-01-05 03:49:22.824591', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, 3, NULL, 1, 20, 20, 12, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (6, 3, '2004-01-06 03:49:22.825533', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, 3, NULL, 1, 10, 999, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (13, 4, '2004-01-13 17:20:12.820778', NULL, 12, NULL, 1, '2006-07-14 08:49:17.124885', 0, 4, NULL, NULL, NULL, NULL, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (14, 5, '2004-01-14 17:27:03.702622', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, 4, NULL, NULL, NULL, NULL, 10, 50, 12, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (15, 6, '2004-01-15 17:35:39.548665', 5, 12, NULL, 1, '2006-05-19 06:37:40.389193', 0, 4, NULL, NULL, NULL, NULL, 10, 40, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (16, 5, '2004-01-16 14:43:02.452716', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, NULL, NULL, 1, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (17, 1, '2004-01-17 01:15:48.241836', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 1, NULL, 1, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (18, 3, '2004-01-18 16:30:32.295049', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (19, 3, '2004-01-19 16:30:47.448639', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 7, 1, 10, 30, NULL, 2, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (20, 2, '2004-01-20 13:54:57.840344', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (21, 7, '2004-01-21 15:12:29.602117', NULL, 16, NULL, 1, '2006-05-19 06:37:40.391822', 0, 5, NULL, NULL, NULL, NULL, 10, 30, 16, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (22, 8, '2004-01-22 09:10:17.13237', NULL, 12, NULL, 1, '2006-05-19 06:37:40.393303', 0, NULL, NULL, 3, NULL, 1, 30, 30, 16, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (23, 9, '2004-01-23 16:42:14.080227', NULL, 16, NULL, 1, '2006-07-14 08:45:10.600579', 0, NULL, NULL, 1, NULL, 18, 20, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (24, 9, '2004-01-24 16:43:25.744534', NULL, 16, NULL, 1, '2006-07-14 08:45:10.600579', 0, 8, NULL, NULL, NULL, NULL, 999, 999, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (25, 10, '2004-01-25 19:42:21.890299', NULL, 16, NULL, 1, '2006-07-14 08:54:19.453881', 0, NULL, NULL, 1, NULL, 22, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (26, 2, '2004-01-26 10:11:02.729077', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, 1, NULL, NULL, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (27, 7, '2004-01-27 16:45:45.054836', NULL, 16, NULL, 1, '2006-05-19 06:37:40.391822', 0, NULL, NULL, 3, NULL, 9, 999, 999, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (28, 2, '2006-08-21 22:23:08.163936', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, 1, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (29, 5, '2007-01-04 15:00:50.431687', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, 2, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (30, 11, '2007-03-15 20:33:56.67893', NULL, 16, NULL, 1, '2007-03-15 20:37:51.603369', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (31, 12, '2007-03-15 20:41:18.635493', NULL, 16, NULL, 1, '2007-03-15 20:46:49.909153', 0, 20, NULL, NULL, NULL, NULL, 20, 50, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (32, 13, '2007-07-27 20:00:58.299796', NULL, 12, NULL, 1, '2007-07-27 20:29:46.336737', 0, 17, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (33, 14, '2007-08-09 11:39:16.836856', NULL, 63, NULL, 3, '2007-08-09 11:39:16.836856', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 63, true, '{2}', '{14,63}');
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (34, 15, '2007-12-18 16:30:19.103679', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 22, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (35, 15, '2007-12-18 16:30:47.889614', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 8, NULL, NULL, NULL, NULL, 10, 999, NULL, NULL, 16, true, NULL, NULL);
+
+
+ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
+
+
ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql 2012-04-24 13:35:22 +0000
+++ database/sampledata/current.sql 2012-04-26 06:52:19 +0000
@@ -3611,6 +3611,41 @@
ALTER TABLE bugtask ENABLE TRIGGER ALL;
+ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
+
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (3, 2, '2004-01-03 03:49:22.908491', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, 1, NULL, NULL, NULL, NULL, 10, 20, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (4, 1, '2004-01-04 03:49:22.79024', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 3, NULL, 1, 20, 20, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (5, 2, '2004-01-05 03:49:22.824591', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, 3, NULL, 1, 20, 20, 12, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (6, 3, '2004-01-06 03:49:22.825533', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, 3, NULL, 1, 10, 999, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (13, 4, '2004-01-13 17:20:12.820778', NULL, 12, NULL, 1, '2006-07-14 08:49:17.124885', 0, 4, NULL, NULL, NULL, NULL, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (14, 5, '2004-01-14 17:27:03.702622', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, 4, NULL, NULL, NULL, NULL, 10, 50, 12, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (15, 6, '2004-01-15 17:35:39.548665', 5, 12, NULL, 1, '2006-05-19 06:37:40.389193', 0, 4, NULL, NULL, NULL, NULL, 10, 40, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (16, 5, '2004-01-16 14:43:02.452716', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, NULL, NULL, 1, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (17, 1, '2004-01-17 01:15:48.241836', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 1, NULL, 1, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (18, 3, '2004-01-18 16:30:32.295049', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (19, 3, '2004-01-19 16:30:47.448639', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 7, 1, 10, 30, NULL, 2, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (20, 2, '2004-01-20 13:54:57.840344', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (21, 7, '2004-01-21 15:12:29.602117', NULL, 16, NULL, 1, '2006-05-19 06:37:40.391822', 0, 5, NULL, NULL, NULL, NULL, 10, 30, 16, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (22, 8, '2004-01-22 09:10:17.13237', NULL, 12, NULL, 1, '2006-05-19 06:37:40.393303', 0, NULL, NULL, 3, NULL, 1, 30, 30, 16, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (23, 9, '2004-01-23 16:42:14.080227', NULL, 16, NULL, 1, '2006-07-14 08:45:10.600579', 0, NULL, NULL, 1, NULL, 18, 20, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (24, 9, '2004-01-24 16:43:25.744534', NULL, 16, NULL, 1, '2006-07-14 08:45:10.600579', 0, 8, NULL, NULL, NULL, NULL, 999, 999, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (25, 10, '2004-01-25 19:42:21.890299', NULL, 16, NULL, 1, '2006-07-14 08:54:19.453881', 0, NULL, NULL, 1, NULL, 22, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (26, 2, '2004-01-26 10:11:02.729077', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, 1, NULL, NULL, 10, 30, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (27, 7, '2004-01-27 16:45:45.054836', NULL, 16, NULL, 1, '2006-05-19 06:37:40.391822', 0, NULL, NULL, 3, NULL, 9, 999, 999, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (28, 2, '2006-08-21 22:23:08.163936', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, 1, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (29, 5, '2007-01-04 15:00:50.431687', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, 2, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (30, 11, '2007-03-15 20:33:56.67893', NULL, 16, NULL, 1, '2007-03-15 20:37:51.603369', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (31, 12, '2007-03-15 20:41:18.635493', NULL, 16, NULL, 1, '2007-03-15 20:46:49.909153', 0, 20, NULL, NULL, NULL, NULL, 20, 50, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (32, 13, '2007-07-27 20:00:58.299796', NULL, 12, NULL, 1, '2007-07-27 20:29:46.336737', 0, 17, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 12, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (33, 14, '2007-08-09 11:39:16.836856', NULL, 63, NULL, 3, '2007-08-09 11:39:16.836856', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 63, true, '{2}', '{14,63}');
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (34, 15, '2007-12-18 16:30:19.103679', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 22, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL);
+INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants) VALUES (35, 15, '2007-12-18 16:30:47.889614', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 8, NULL, NULL, NULL, NULL, 10, 999, NULL, NULL, 16, true, NULL, NULL);
+
+
+ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
+
+
ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
=== modified file 'lib/lp/registry/stories/person/xx-person-subscriptions.txt'
--- lib/lp/registry/stories/person/xx-person-subscriptions.txt 2012-02-22 21:42:44 +0000
+++ lib/lp/registry/stories/person/xx-person-subscriptions.txt 2012-04-26 06:52:19 +0000
@@ -24,13 +24,14 @@
>>> login('[email protected]')
>>> scofflaw = factory.makeProduct(name='scofflaw')
+ >>> subscriber = factory.makePerson(name='webster')
>>> bugA = factory.makeBug(product=scofflaw,
... title='Word needs more popularity')
>>> affluenza = factory.makeProduct(name='affluenza')
+ >>> subscriptionA = bugA.subscribe(subscriber, subscriber)
+ >>> transaction.commit()
>>> bugB = factory.makeBug(product=affluenza,
... title='A terrible affliction')
- >>> subscriber = factory.makePerson(name='webster')
- >>> subscriptionA = bugA.subscribe(subscriber, subscriber)
>>> subscriptionB = bugB.subscribe(subscriber, subscriber)
>>> logout()
@@ -43,11 +44,11 @@
Summary
In
...
- Word needs more popularity
- Scofflaw
- ...
A terrible affliction
Affluenza
+ ...
+ Word needs more popularity
+ Scofflaw
The bug subscriptions table also includes an unsubscribe link, if the user has
permission to remove the subscription, for bugs to which the person or team is
=== modified file 'lib/lp/services/feeds/stories/xx-security.txt'
--- lib/lp/services/feeds/stories/xx-security.txt 2012-03-29 05:53:23 +0000
+++ lib/lp/services/feeds/stories/xx-security.txt 2012-04-26 06:52:19 +0000
@@ -9,7 +9,9 @@
>>> from lp.services.database.lpstorm import IStore
>>> import transaction
>>> from lp.bugs.model.bug import Bug
- >>> IStore(Bug).find(Bug).set(_private=True)
+ >>> from lp.registry.enums import InformationType
+ >>> IStore(Bug).find(Bug).set(
+ ... information_type=InformationType.USERDATA, _private=True)
>>> transaction.commit()
There should be zero entries in these feeds, since all the bugs are private.
_______________________________________________
Mailing list: https://launchpad.net/~launchpad-reviewers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~launchpad-reviewers
More help : https://help.launchpad.net/ListHelp
