Noissue - Got rid of E129, E704, E712, E731 and F821 errors

sitescripts/reports/utils.py

 # coding: utf-8
 
 # This file is part of the Adblock Plus web scripts,
 # Copyright (C) 2006-2016 Eyeo GmbH
 #
 # Adblock Plus is free software: you can redistribute it and/or modify
 # it under the terms of the GNU General Public License version 3 as
 # published by the Free Software Foundation.
 #
 # Adblock Plus is distributed in the hope that it will be useful,
@@ skipping 92 matching lines @@
                  UPDATE type = %(type)s, site = %(site)s, comment = %(comment)s, status = %(status)s,
                  hasscreenshot = %(hasscreenshot)s, knownissues = %(knownissues)s, dump = %(dump)s''',
                  {'guid': guid, 'type': reportData.get('type', None), 'ctime': reportData['time'], 'site': reportData.get('siteName', None),
                   'comment': reportData.get('comment', None), 'status': reportData.get('status', None), 'contact': contact,
                   'hasscreenshot': reportData.get('hasscreenshot', 0), 'knownissues': knownIssues, 'dump': dumpstr})
     if len(reportData['subscriptions']) > 0:
         for sn in reportData['subscriptions']:
             executeQuery(cursor, 'SELECT id FROM #PFX#subscriptions WHERE url = %s', sn['id'])
             id = cursor.fetchone()
             if id != None:
-                filterMatch = lambda f: any(u == sn['id'] for u in f.get('subscriptions', []))
+                def filterMatch(f):
+                    return any(u == sn['id'] for u in f.get('subscriptions', []))
                 hasMatches = any(filterMatch(f) for f in reportData.get('filters', []))
                 executeQuery(cursor, 'INSERT IGNORE INTO #PFX#sublists (report, list, hasmatches) VALUES (%s, %s, %s)', (guid, id[0], hasMatches))
 
     get_db().commit()
 
     reportData['guid'] = guid
     if contact:
         # TODO: The mail anonymization should happen in the template, not here
         origEmail = reportData['email']
         email = reportData['email']
@@ skipping 149 matching lines @@
     if os.name == 'nt':
         return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, use_unicode=True, charset='utf8', named_pipe=True)
     else:
         return MySQLdb.connect(user=dbuser, passwd=dbpasswd, db=database, use_unicode=True, charset='utf8')
 
 
 def executeQuery(cursor, query, args=None):
     tablePrefix = get_config().get('reports', 'dbprefix')
     query = re.sub(r'#PFX#', tablePrefix, query)
     cursor.execute(query, args)