launchpad-reviewers team mailing list archive

Thread
Date

[Merge] lp:~wgrant/launchpad/ubuntu-sso-celeb into lp:launchpad

To: mp+291614@xxxxxxxxxxxxxxxxxx
From: William Grant <me@xxxxxxxxxxxxxxxxxx>
Date: Tue, 12 Apr 2016 11:09:24 -0000
Reply-to: mp+291614@xxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

William Grant has proposed merging lp:~wgrant/launchpad/ubuntu-sso-celeb into lp:launchpad.

Commit message:
Define an ubuntu-sso celebrity for privileged API actions.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~wgrant/launchpad/ubuntu-sso-celeb/+merge/291614

Define an ubuntu-sso celebrity for privileged API actions.

Initially this will just be for setting and getting username placeholders.
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~wgrant/launchpad/ubuntu-sso-celeb into lp:launchpad.

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2016-02-24 06:08:16 +0000
+++ database/sampledata/current-dev.sql	2016-04-12 11:08:15 +0000
@@ -85,6 +85,7 @@
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436241, '2008-11-04 12:59:26.965843', 8, 20, '2008-11-04 13:09:43.807125', 'PPA key guard', NULL);
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436242, '2009-03-17 07:26:14.024613', 1, 20, '2009-03-17 07:26:14.024613', 'Ubuntu-branches-owner', 'Activated when the preferred email was set.');
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436243, '2009-08-04 10:50:39.383407', 1, 20, '2009-08-04 10:50:39.383407', 'Techboard Owner', 'Activated when the preferred email was set.');
+INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436244, '2016-03-11 08:23:55.060903', 1, 20, '2016-03-11 08:23:55.060903', 'Ubuntu-sso', NULL);
 
 
 ALTER TABLE account ENABLE TRIGGER ALL;
@@ -944,6 +945,7 @@
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243651, 'Software-center-agent', NULL, NULL, 'software-center-agent', NULL, NULL, NULL, NULL, 1, NULL, '2010-07-12 09:48:27.198885', NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 243637, NULL);
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243652, 'Launchpad PPA Self Admins', 243621, NULL, 'launchpad-ppa-self-admins', NULL, NULL, NULL, NULL, 3, NULL, '2013-05-10 05:40:34.64279', NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL, NULL);
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243653, 'Launchpad PPA Admins', 243621, NULL, 'launchpad-ppa-admins', NULL, NULL, NULL, NULL, 3, NULL, '2015-11-25 11:06:11.767934', NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL, NULL);
+INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243654, 'Ubuntu-sso', NULL, NULL, 'ubuntu-sso', NULL, NULL, NULL, NULL, 3, NULL, '2016-03-11 08:23:55.060903', NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 2436244, NULL);
 
 
 ALTER TABLE person ENABLE TRIGGER ALL;
@@ -1710,6 +1712,16 @@
 
 
 
+ALTER TABLE archivefile DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE archivefile ENABLE TRIGGER ALL;
+
+
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -3670,6 +3682,7 @@
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843');
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407');
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (94, 'ubuntu-sso@xxxxxxxxxxx', 243654, 4, '2016-03-11 08:23:55.060903');
 
 
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
@@ -4752,6 +4765,7 @@
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436241, 'cF4PNk3');
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436242, 'GMX7shE');
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436243, 'kYFxQYP');
+INSERT INTO lp_account (id, openid_identifier) VALUES (2436244, 'ubuntu-sso_oid');
 
 
 ALTER TABLE lp_account ENABLE TRIGGER ALL;
@@ -4824,6 +4838,7 @@
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
+INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:23:55.060903');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
@@ -4931,6 +4946,7 @@
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243651, 'Software-center-agent', NULL, NULL, 'software-center-agent', NULL, NULL, NULL, NULL, 1, NULL, '2010-07-12 09:48:27.198885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 243637);
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243652, 'Launchpad PPA Self Admins', 243621, NULL, 'launchpad-ppa-self-admins', NULL, NULL, NULL, NULL, 3, NULL, '2013-05-10 05:40:34.64279', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL);
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243653, 'Launchpad PPA Admins', 243621, NULL, 'launchpad-ppa-admins', NULL, NULL, NULL, NULL, 3, NULL, '2015-11-25 11:06:11.767934', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL);
+INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243654, 'Ubuntu-sso', NULL, NULL, 'ubuntu-sso', NULL, NULL, NULL, NULL, 3, NULL, '2016-03-11 08:23:55.060903', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 2436244);
 
 
 ALTER TABLE lp_person ENABLE TRIGGER ALL;
@@ -5154,6 +5170,7 @@
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (258, 243653, 243653);
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (259, 243653, 243621);
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (260, 243653, 243622);
+INSERT INTO lp_teamparticipation (id, team, person) VALUES (261, 243654, 243654);
 
 
 ALTER TABLE lp_teamparticipation ENABLE TRIGGER ALL;
@@ -5854,6 +5871,7 @@
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
+INSERT INTO openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:23:55.060903');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
@@ -6243,6 +6261,7 @@
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243654, false, false);
 
 
 ALTER TABLE personsettings ENABLE TRIGGER ALL;
@@ -10344,6 +10363,7 @@
 INSERT INTO teamparticipation (id, team, person) VALUES (258, 243653, 243653);
 INSERT INTO teamparticipation (id, team, person) VALUES (259, 243653, 243621);
 INSERT INTO teamparticipation (id, team, person) VALUES (260, 243653, 243622);
+INSERT INTO teamparticipation (id, team, person) VALUES (261, 243654, 243654);
 
 
 ALTER TABLE teamparticipation ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2016-03-18 03:07:48 +0000
+++ database/sampledata/current.sql	2016-04-12 11:08:15 +0000
@@ -85,6 +85,7 @@
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436241, '2008-11-04 12:59:26.965843', 8, 20, '2008-11-04 13:09:43.807125', 'PPA key guard', NULL);
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436242, '2009-03-17 07:26:14.024613', 1, 20, '2009-03-17 07:26:14.024613', 'Ubuntu-branches-owner', 'Activated when the preferred email was set.');
 INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436243, '2009-08-04 10:50:39.383407', 1, 20, '2009-08-04 10:50:39.383407', 'Techboard Owner', 'Activated when the preferred email was set.');
+INSERT INTO account (id, date_created, creation_rationale, status, date_status_set, displayname, status_comment) VALUES (2436244, '2016-03-11 08:24:55.495042', 1, 20, '2016-03-11 08:24:55.495042', 'Ubuntu-sso', NULL);
 
 
 ALTER TABLE account ENABLE TRIGGER ALL;
@@ -944,6 +945,7 @@
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243651, 'Software-center-agent', NULL, NULL, 'software-center-agent', NULL, NULL, NULL, NULL, 1, NULL, '2010-07-12 09:48:27.198885', NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 243637, NULL);
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243652, 'Launchpad PPA Self Admins', 243621, NULL, 'launchpad-ppa-self-admins', NULL, NULL, NULL, NULL, 3, NULL, '2013-05-10 05:43:04.018122', NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL, NULL);
 INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243653, 'Launchpad PPA Admins', 243621, NULL, 'launchpad-ppa-admins', NULL, NULL, NULL, NULL, 3, NULL, '2015-11-25 11:06:11.767934', NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL, NULL);
+INSERT INTO person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account, description) VALUES (243654, 'Ubuntu-sso', NULL, NULL, 'ubuntu-sso', NULL, NULL, NULL, NULL, 3, NULL, '2016-03-11 08:24:55.495042', NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 2436244, NULL);
 
 
 ALTER TABLE person ENABLE TRIGGER ALL;
@@ -1703,6 +1705,16 @@
 
 
 
+ALTER TABLE archivefile DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE archivefile ENABLE TRIGGER ALL;
+
+
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -3599,6 +3611,7 @@
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843');
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407');
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (94, 'ubuntu-sso@xxxxxxxxxxx', 243654, 4, '2016-03-11 08:24:55.495042');
 
 
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
@@ -4667,6 +4680,7 @@
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436241, 'cF4PNk3');
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436242, 'GMX7shE');
 INSERT INTO lp_account (id, openid_identifier) VALUES (2436243, 'kYFxQYP');
+INSERT INTO lp_account (id, openid_identifier) VALUES (2436244, 'ubuntu-sso_oid');
 
 
 ALTER TABLE lp_account ENABLE TRIGGER ALL;
@@ -4739,6 +4753,7 @@
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
+INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:24:55.495042');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
@@ -4846,6 +4861,7 @@
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243651, 'Software-center-agent', NULL, NULL, 'software-center-agent', NULL, NULL, NULL, NULL, 1, NULL, '2010-07-12 09:48:27.198885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 243637);
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243652, 'Launchpad PPA Self Admins', 243621, NULL, 'launchpad-ppa-self-admins', NULL, NULL, NULL, NULL, 3, NULL, '2013-05-10 05:43:04.018122', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL);
 INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243653, 'Launchpad PPA Admins', 243621, NULL, 'launchpad-ppa-admins', NULL, NULL, NULL, NULL, 3, NULL, '2015-11-25 11:06:11.767934', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, NULL);
+INSERT INTO lp_person (id, displayname, teamowner, teamdescription, name, language, fti, defaultmembershipperiod, defaultrenewalperiod, subscriptionpolicy, merged, datecreated, addressline1, addressline2, organization, city, province, country, postcode, phone, homepage_content, icon, mugshot, hide_email_addresses, creation_rationale, creation_comment, registrant, logo, renewal_policy, personal_standing, personal_standing_reason, mail_resumption_date, mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates, visibility, verbose_bugnotifications, account) VALUES (243654, 'Ubuntu-sso', NULL, NULL, 'ubuntu-sso', NULL, NULL, NULL, NULL, 3, NULL, '2016-03-11 08:24:55.495042', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, NULL, NULL, NULL, 10, 0, NULL, NULL, 1, true, 1, true, 2436244);
 
 
 ALTER TABLE lp_person ENABLE TRIGGER ALL;
@@ -5069,6 +5085,7 @@
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (258, 243653, 243653);
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (259, 243653, 243621);
 INSERT INTO lp_teamparticipation (id, team, person) VALUES (260, 243653, 243622);
+INSERT INTO lp_teamparticipation (id, team, person) VALUES (261, 243654, 243654);
 
 
 ALTER TABLE lp_teamparticipation ENABLE TRIGGER ALL;
@@ -5769,6 +5786,7 @@
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
+INSERT INTO openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:24:55.495042');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
@@ -6158,6 +6176,7 @@
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243654, false, false);
 
 
 ALTER TABLE personsettings ENABLE TRIGGER ALL;
@@ -10259,6 +10278,7 @@
 INSERT INTO teamparticipation (id, team, person) VALUES (258, 243653, 243653);
 INSERT INTO teamparticipation (id, team, person) VALUES (259, 243653, 243621);
 INSERT INTO teamparticipation (id, team, person) VALUES (260, 243653, 243622);
+INSERT INTO teamparticipation (id, team, person) VALUES (261, 243654, 243654);
 
 
 ALTER TABLE teamparticipation ENABLE TRIGGER ALL;

=== modified file 'lib/lp/app/interfaces/launchpad.py'
--- lib/lp/app/interfaces/launchpad.py	2016-02-05 06:41:16 +0000
+++ lib/lp/app/interfaces/launchpad.py	2016-04-12 11:08:15 +0000
@@ -65,6 +65,7 @@
     ubuntu_archive_mirror = Attribute("The main archive mirror for Ubuntu.")
     ubuntu_bugzilla = Attribute("The Ubuntu Bugzilla.")
     ubuntu_cdimage_mirror = Attribute("The main cdimage mirror for Ubuntu.")
+    ubuntu_sso = Attribute("The Ubuntu One login service.")
     ubuntu_techboard = Attribute("The Ubuntu technical board.")
     vcs_imports = Attribute("The 'vcs-imports' team.")
 

=== modified file 'lib/lp/app/utilities/celebrities.py'
--- lib/lp/app/utilities/celebrities.py	2015-11-26 15:46:38 +0000
+++ lib/lp/app/utilities/celebrities.py	2016-04-12 11:08:15 +0000
@@ -153,6 +153,7 @@
     sourceforge_tracker = CelebrityDescriptor(IBugTrackerSet, 'sf')
     ubuntu = CelebrityDescriptor(IDistributionSet, 'ubuntu')
     ubuntu_bugzilla = CelebrityDescriptor(IBugTrackerSet, 'ubuntu-bugzilla')
+    ubuntu_sso = PersonCelebrityDescriptor('ubuntu-sso')
     ubuntu_techboard = PersonCelebrityDescriptor('techboard')
     vcs_imports = PersonCelebrityDescriptor('vcs-imports')

Follow ups

[Merge] lp:~wgrant/launchpad/ubuntu-sso-celeb into lp:launchpad
From: noreply, 2016-04-26
Re: [Merge] lp:~wgrant/launchpad/ubuntu-sso-celeb into lp:launchpad
From: Colin Watson, 2016-04-12