← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/trusted.sql

[r=bac][bug=835024] New error_description property on
        InitializeDistroSeriesJob.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/trusted.sql
1854
1854
        AFFECTED_USER = 4
1855
1855
        SUBSCRIBER = 2
1856
1856
 
1857
 
 
1858
1857
    def get_max_heat_for_bug(bug_id):
1859
1858
        results = plpy.execute("""
1860
1859
            SELECT MAX(
1861
 
                GREATEST(Product.max_bug_heat, Distribution.max_bug_heat))
 
1860
                GREATEST(Product.max_bug_heat,
 
1861
                         DistributionSourcePackage.max_bug_heat))
1862
1862
                    AS max_heat
1863
1863
            FROM BugTask
1864
1864
            LEFT OUTER JOIN ProductSeries ON
1871
1871
            LEFT OUTER JOIN Distribution ON (
1872
1872
                BugTask.distribution = Distribution.id
1873
1873
                OR DistroSeries.distribution = Distribution.id)
 
1874
            LEFT OUTER JOIN DistributionSourcePackage ON (
 
1875
                BugTask.sourcepackagename =
 
1876
                    DistributionSourcePackage.sourcepackagename)
1874
1877
            WHERE
1875
1878
                BugTask.bug = %s""" % bug_id)
1876
1879