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;
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
