launchpad-reviewers team mailing list archive

[Colin Watson <cjwatson@xxxxxxxxxxxxx>]

Colin Watson has proposed merging lp:~cjwatson/launchpad/dsp-sampledata into lp:launchpad.

Commit message:
Add DistributionSourcePackage rows to sampledata matching current SourcePackagePublishingHistory rows.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/dsp-sampledata/+merge/300870

PublishingSet.newSourcePublication has called DistributionSourcePackage.ensure for about six years now.  Create corresponding DistributionSourcePackage rows in sampledata as if this had been done.  This makes it easier to experiment with the DistributionSourcePackage vocabulary.
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~cjwatson/launchpad/dsp-sampledata into lp:launchpad.

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2016-06-28 21:04:41 +0000
+++ database/sampledata/current-dev.sql	2016-07-22 11:12:59 +0000
@@ -3465,6 +3465,23 @@
 
 ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
 
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (5, 1, 20, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (6, 1, 23, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (7, 1, 9, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (8, 1, 24, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (9, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (10, 8, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (11, 3, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (12, 1, 21, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (13, 9, 1, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (14, 1, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (15, 1, 26, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (16, 9, 9, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (17, 1, 27, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (18, 1, 14, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (19, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (20, 1, 10, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (21, 9, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
 
 
 ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2016-06-28 21:04:41 +0000
+++ database/sampledata/current.sql	2016-07-22 11:12:59 +0000
@@ -3402,6 +3402,20 @@
 
 ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
 
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (1, 1, 20, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (2, 1, 26, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (3, 1, 23, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (4, 1, 9, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (5, 1, 24, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (6, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (7, 1, 27, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (8, 8, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (9, 1, 14, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (10, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (11, 1, 21, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (12, 3, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (13, 1, 10, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
+INSERT INTO distributionsourcepackage (id, distribution, sourcepackagename, bug_reporting_guidelines, max_bug_heat, bug_reported_acknowledgement, total_bug_heat, bug_count, po_message_count, is_upstream_link_allowed, enable_bugfiling_duplicate_search) VALUES (14, 1, 19, NULL, NULL, NULL, NULL, NULL, NULL, false, true);
 
 
 ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;