← Back to team overview

launchpad-reviewers team mailing list archive

  1. launchpad-reviewers team
  2. Mailing list archive
  3. Message #07299

[Merge] lp:~wgrant/launchpad/bugtaskflat-by-default-0 into lp:launchpad

  Thread Previous • Date Previous • • Thread Next 
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('foo.bar@xxxxxxxxxxxxx')
     >>> 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.

Follow ups

  Thread Previous • Date Previous • • Thread Next