commit e903d5988c2329f2dfe1bad6edd4a8ace7084dee
author James E. Blair <jeblair@openstack.org> Fri Jan 11 14:31:26 2013 -0800
committer Jenkins <jenkins@review.openstack.org> Sat Jan 12 00:57:59 2013 +0000
tree df0672d55bf594e6a7d1bd9a7d9320b403e5322b
parent 4d25a7c666f411aaa6f0402371c1235ef2ad8ab6

Be more selective about openids in bug script.

Look for login.launchpad.net openids for the openid->username
mapping.  Some users have other openids that won't work.

Change-Id: I6201d33e553120548e9d910830dfe23072b65b63
Reviewed-on: https://review.openstack.org/19502
Reviewed-by: Clark Boylan <clark.boylan@gmail.com>
Reviewed-by: Jeremy Stanley <fungi@yuggoth.org>
Approved: Clark Boylan <clark.boylan@gmail.com>
Tested-by: Jenkins

jeepyb/cmd/update_bug.py

diff --git a/jeepyb/cmd/update_bug.py b/jeepyb/cmd/update_bug.py
index a480862..e86be8d 100644
--- a/jeepyb/cmd/update_bug.py
+++ b/jeepyb/cmd/update_bug.py
@@ -83,7 +83,7 @@
                 SELECT t.account_id FROM account_external_ids t
                 WHERE t.email_address = %s )
             original ON t.account_id = original.account_id
-            AND t.external_id LIKE 'https://%%'"""
+            AND t.external_id LIKE 'https://login.launchpad.net%%'"""
 
     cursor = jeepyb.gerritdb.connect().cursor()
     cursor.execute(query, searchkey)