← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to lib/lp/registry/model/person.py

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-08-17 12:41:43 UTC
  • mfrom: (13646.7.2 denorm-bspph-qualified)
  • Revision ID: launchpad@pqm.canonical.com-20110817124143-fztvdqtmnk7hkt9t
[testfix][r=jtv][bug=826516][no-qa][incr] Fix two queries to use
 SourcePackageRelease.sourcepackagename explicitly.

Show diffs side-by-side

added added

removed removed

Lines of Context:
lib/lp/registry/model/person.py
2617
2617
        query_clauses = " AND ".join(clauses)
2618
2618
        query = """
2619
2619
            SourcePackageRelease.id IN (
2620
 
                SELECT DISTINCT ON (upload_distroseries, sourcepackagename,
 
2620
                SELECT DISTINCT ON (upload_distroseries,
 
2621
                                    sourcepackagerelease.sourcepackagename,
2621
2622
                                    upload_archive)
2622
2623
                    sourcepackagerelease.id
2623
2624
                FROM sourcepackagerelease, archive,
2624
 
                    sourcepackagepublishinghistory sspph
 
2625
                    sourcepackagepublishinghistory as spph
2625
2626
                WHERE
2626
 
                    sspph.sourcepackagerelease = sourcepackagerelease.id AND
2627
 
                    sspph.archive = archive.id AND
 
2627
                    spph.sourcepackagerelease = sourcepackagerelease.id AND
 
2628
                    spph.archive = archive.id AND
2628
2629
                    %(more_query_clauses)s
2629
 
                ORDER BY upload_distroseries, sourcepackagename,
 
2630
                ORDER BY upload_distroseries,
 
2631
                    sourcepackagerelease.sourcepackagename,
2630
2632
                    upload_archive, dateuploaded DESC
2631
2633
              )
2632
2634
              """ % dict(more_query_clauses=query_clauses)