Launchpad itself

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

  1. ubuntu-sso-celeb
  2. Merge into devel
Proposed by William Grant
Status: Merged
Merged at revision: 18002
Proposed branch: lp:~wgrant/launchpad/ubuntu-sso-celeb
Merge into: lp:launchpad
Diff against target: 217 lines (+26/-0)
6 files modified
database/sampledata/current-dev.sql (+10/-0)
database/sampledata/current.sql (+10/-0)
lib/lp/app/interfaces/launchpad.py (+1/-0)
lib/lp/app/utilities/celebrities.py (+1/-0)
lib/lp/registry/doc/person.txt (+1/-0)
lib/lp/registry/interfaces/role.py (+3/-0)
To merge this branch: bzr merge lp:~wgrant/launchpad/ubuntu-sso-celeb
Reviewer Review Type Date Requested Status
Colin Watson (community) Approve
Review via email: mp+291614@code.launchpad.net

Commit message

Define an ubuntu-sso celebrity for privileged API actions.

Description of the change

Define an ubuntu-sso celebrity for privileged API actions.

Initially this will just be for setting and getting username placeholders.

To post a comment you must log in.
Revision history for this message
Colin Watson (cjwatson) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2016-04-05 15:55:16 +0000
3+++ database/sampledata/current-dev.sql 2016-04-26 10:31:34 +0000
4@@ -85,6 +85,7 @@
5 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);
6 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.');
7 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.');
8+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 Single Sign On', NULL);
9
10
11 ALTER TABLE account ENABLE TRIGGER ALL;
12@@ -944,6 +945,7 @@
13 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);
14 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);
15 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);
16+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 Single Sign On', 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);
17
18
19 ALTER TABLE person ENABLE TRIGGER ALL;
20@@ -3680,6 +3682,7 @@
21 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843');
22 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407');
23 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885');
24+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (94, 'ubuntu-sso@example.com', 243654, 4, '2016-03-11 08:23:55.060903');
25
26
27 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
28@@ -4762,6 +4765,7 @@
29 INSERT INTO lp_account (id, openid_identifier) VALUES (2436241, 'cF4PNk3');
30 INSERT INTO lp_account (id, openid_identifier) VALUES (2436242, 'GMX7shE');
31 INSERT INTO lp_account (id, openid_identifier) VALUES (2436243, 'kYFxQYP');
32+INSERT INTO lp_account (id, openid_identifier) VALUES (2436244, 'ubuntu-sso_oid');
33
34
35 ALTER TABLE lp_account ENABLE TRIGGER ALL;
36@@ -4834,6 +4838,7 @@
37 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
38 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
39 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
40+INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:23:55.060903');
41 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
42 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
43 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
44@@ -4941,6 +4946,7 @@
45 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);
46 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);
47 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);
48+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 Single Sign On', 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);
49
50
51 ALTER TABLE lp_person ENABLE TRIGGER ALL;
52@@ -5164,6 +5170,7 @@
53 INSERT INTO lp_teamparticipation (id, team, person) VALUES (258, 243653, 243653);
54 INSERT INTO lp_teamparticipation (id, team, person) VALUES (259, 243653, 243621);
55 INSERT INTO lp_teamparticipation (id, team, person) VALUES (260, 243653, 243622);
56+INSERT INTO lp_teamparticipation (id, team, person) VALUES (261, 243654, 243654);
57
58
59 ALTER TABLE lp_teamparticipation ENABLE TRIGGER ALL;
60@@ -5864,6 +5871,7 @@
61 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
62 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
63 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
64+INSERT INTO openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:23:55.060903');
65 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
66 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
67 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
68@@ -6253,6 +6261,7 @@
69 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
70 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
71 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
72+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243654, false, false);
73
74
75 ALTER TABLE personsettings ENABLE TRIGGER ALL;
76@@ -10354,6 +10363,7 @@
77 INSERT INTO teamparticipation (id, team, person) VALUES (258, 243653, 243653);
78 INSERT INTO teamparticipation (id, team, person) VALUES (259, 243653, 243621);
79 INSERT INTO teamparticipation (id, team, person) VALUES (260, 243653, 243622);
80+INSERT INTO teamparticipation (id, team, person) VALUES (261, 243654, 243654);
81
82
83 ALTER TABLE teamparticipation ENABLE TRIGGER ALL;
84
85=== modified file 'database/sampledata/current.sql'
86--- database/sampledata/current.sql 2016-04-05 15:55:16 +0000
87+++ database/sampledata/current.sql 2016-04-26 10:31:34 +0000
88@@ -85,6 +85,7 @@
89 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);
90 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.');
91 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.');
92+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 Single Sign On', NULL);
93
94
95 ALTER TABLE account ENABLE TRIGGER ALL;
96@@ -944,6 +945,7 @@
97 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);
98 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);
99 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);
100+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 Single Sign On', 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);
101
102
103 ALTER TABLE person ENABLE TRIGGER ALL;
104@@ -3609,6 +3611,7 @@
105 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843');
106 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407');
107 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885');
108+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (94, 'ubuntu-sso@example.com', 243654, 4, '2016-03-11 08:24:55.495042');
109
110
111 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
112@@ -4677,6 +4680,7 @@
113 INSERT INTO lp_account (id, openid_identifier) VALUES (2436241, 'cF4PNk3');
114 INSERT INTO lp_account (id, openid_identifier) VALUES (2436242, 'GMX7shE');
115 INSERT INTO lp_account (id, openid_identifier) VALUES (2436243, 'kYFxQYP');
116+INSERT INTO lp_account (id, openid_identifier) VALUES (2436244, 'ubuntu-sso_oid');
117
118
119 ALTER TABLE lp_account ENABLE TRIGGER ALL;
120@@ -4749,6 +4753,7 @@
121 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
122 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
123 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
124+INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:24:55.495042');
125 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
126 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
127 INSERT INTO lp_openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
128@@ -4856,6 +4861,7 @@
129 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);
130 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);
131 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);
132+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 Single Sign On', 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);
133
134
135 ALTER TABLE lp_person ENABLE TRIGGER ALL;
136@@ -5079,6 +5085,7 @@
137 INSERT INTO lp_teamparticipation (id, team, person) VALUES (258, 243653, 243653);
138 INSERT INTO lp_teamparticipation (id, team, person) VALUES (259, 243653, 243621);
139 INSERT INTO lp_teamparticipation (id, team, person) VALUES (260, 243653, 243622);
140+INSERT INTO lp_teamparticipation (id, team, person) VALUES (261, 243654, 243654);
141
142
143 ALTER TABLE lp_teamparticipation ENABLE TRIGGER ALL;
144@@ -5779,6 +5786,7 @@
145 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('stub_oid', 221, '2005-06-06 08:59:51.59276');
146 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('team-membership-janitor_oid', 671, '2006-10-04 16:20:51.19954');
147 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('tsukimi_oid', 501, '2005-06-06 08:59:51.569518');
148+INSERT INTO openididentifier (identifier, account, date_created) VALUES ('ubuntu-sso_oid', 2436244, '2016-03-11 08:24:55.495042');
149 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('valyag_oid', 441, '2005-06-06 08:59:51.562857');
150 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('yEzBPbd', 2436151, '2007-12-18 16:31:34.790641');
151 INSERT INTO openididentifier (identifier, account, date_created) VALUES ('zRtPxw8', 243637, '2010-07-12 09:48:27.198885');
152@@ -6168,6 +6176,7 @@
153 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
154 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
155 INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
156+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243654, false, false);
157
158
159 ALTER TABLE personsettings ENABLE TRIGGER ALL;
160@@ -10269,6 +10278,7 @@
161 INSERT INTO teamparticipation (id, team, person) VALUES (258, 243653, 243653);
162 INSERT INTO teamparticipation (id, team, person) VALUES (259, 243653, 243621);
163 INSERT INTO teamparticipation (id, team, person) VALUES (260, 243653, 243622);
164+INSERT INTO teamparticipation (id, team, person) VALUES (261, 243654, 243654);
165
166
167 ALTER TABLE teamparticipation ENABLE TRIGGER ALL;
168
169=== modified file 'lib/lp/app/interfaces/launchpad.py'
170--- lib/lp/app/interfaces/launchpad.py 2016-02-05 06:41:16 +0000
171+++ lib/lp/app/interfaces/launchpad.py 2016-04-26 10:31:34 +0000
172@@ -65,6 +65,7 @@
173 ubuntu_archive_mirror = Attribute("The main archive mirror for Ubuntu.")
174 ubuntu_bugzilla = Attribute("The Ubuntu Bugzilla.")
175 ubuntu_cdimage_mirror = Attribute("The main cdimage mirror for Ubuntu.")
176+ ubuntu_sso = Attribute("The Ubuntu One login service.")
177 ubuntu_techboard = Attribute("The Ubuntu technical board.")
178 vcs_imports = Attribute("The 'vcs-imports' team.")
179
180
181=== modified file 'lib/lp/app/utilities/celebrities.py'
182--- lib/lp/app/utilities/celebrities.py 2015-11-26 15:46:38 +0000
183+++ lib/lp/app/utilities/celebrities.py 2016-04-26 10:31:34 +0000
184@@ -153,6 +153,7 @@
185 sourceforge_tracker = CelebrityDescriptor(IBugTrackerSet, 'sf')
186 ubuntu = CelebrityDescriptor(IDistributionSet, 'ubuntu')
187 ubuntu_bugzilla = CelebrityDescriptor(IBugTrackerSet, 'ubuntu-bugzilla')
188+ ubuntu_sso = PersonCelebrityDescriptor('ubuntu-sso')
189 ubuntu_techboard = PersonCelebrityDescriptor('techboard')
190 vcs_imports = PersonCelebrityDescriptor('vcs-imports')
191
192
193=== modified file 'lib/lp/registry/doc/person.txt'
194--- lib/lp/registry/doc/person.txt 2016-01-26 15:47:37 +0000
195+++ lib/lp/registry/doc/person.txt 2016-04-26 10:31:34 +0000
196@@ -763,6 +763,7 @@
197 Ubuntu Doc Team (doc): [u'doc@lists.ubuntu.com']
198 Ubuntu Gnome Team (name18): []
199 Ubuntu Security Team (ubuntu-security): []
200+ Ubuntu Single Sign On (ubuntu-sso): [u'ubuntu-sso@example.com']
201 Ubuntu Team (ubuntu-team): [u'support@ubuntu.com']
202 Ubuntu Technical Board (techboard): []
203 Ubuntu Translators (ubuntu-translators): []
204
205=== modified file 'lib/lp/registry/interfaces/role.py'
206--- lib/lp/registry/interfaces/role.py 2015-11-26 15:46:38 +0000
207+++ lib/lp/registry/interfaces/role.py 2016-04-26 10:31:34 +0000
208@@ -112,6 +112,9 @@
209 in_rosetta_experts = Bool(
210 title=_("True if this person is a rosetta expert."),
211 required=True, readonly=True)
212+ in_ubuntu_sso = Bool(
213+ title=_("True if this person is Ubuntu Single Sign On."),
214+ required=True, readonly=True)
215 in_ubuntu_techboard = Bool(
216 title=_("True if this person is on the Ubuntu tech board."),
217 required=True, readonly=True)