Launchpad itself

~ines-almeida/launchpad:webhook-patterns/add-db-patch

Git
lp:~ines-almeida/launchpad
webhook-patterns/add-db-patch

Last commit made on 2023-07-17

Get this branch:: git clone -b webhook-patterns/add-db-patch https://git.launchpad.net/~ines-almeida/launchpad

Only Ines Almeida can upload to this branch. If you are Ines Almeida please log in for upload directions.

Branch merges

Merged into launchpad:db-devel

William Grant: Approve (db) on 2023-07-17

Colin Watson (community): Approve (db) on 2023-07-17

Branch information

Name:: webhook-patterns/add-db-patch

Repository:: lp:~ines-almeida/launchpad

Recent commits

95d647b... by Ines Almeida on 2023-07-07

db: Add 'git_ref_pattern' column to webhoks and 'git_refs' column to CIBuilds table

	docs:0 (build)
	lint:0 (build)
	mypy:0 (build)

7f55a2b... by Patch Queue Manager <email address hidden> on 2023-07-13

Automatic merge from stable up to 4675d89dc461

4675d89... by Colin Watson on 2023-07-12

Fix regression from converting POFile to Storm

Merged from https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/446641

0e2847f... by Colin Watson on 2023-07-12

Fix regression from converting POFile to Storm

The PO export views pass IDs to `POExportRequestSet.addRequest`
(probably for performance), so it needs to preserve the ability to
accept either database model objects or IDs.

This exposed one test that was passing a `POTemplate` in the `pofiles`
argument, apparently by accident.

0e0766e... by Colin Watson on 2023-07-12

Export ISSHKey.getFullKeyText

Merged from https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/446623

1a520e5... by Colin Watson on 2023-07-11

Export ISSHKey.getFullKeyText

There are currently several cron jobs on loganberry that export email
and SSH key data for the members of several teams, using
`scripts/list-team-members`; this information is used as part of various
integrations such as lists.ubuntu.com posting privileges, the ability
for Ubuntu members to upload files to people.ubuntu.com using SFTP, and
so on. However, doing this with ad-hoc cron jobs on a Launchpad machine
isn't ideal; it would be better if it were possible to get this
information over the API, and then IS would only need a
suitably-privileged bot account.

As far as I can see, the only API gap here is that we can only extract
the raw key text for an SSH key, and not the "full" key text that's
decorated with the key type and comment in a format suitable for adding
to an OpenSSH `authorized_keys` file. That transformation isn't quite
trivial, so export a method that does it on the webservice.

912cf06... by Colin Watson on 2023-07-12