id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
8909,needs updates for 0.13dev,jayen,bobbysmith007,this is a patch my friend sent me:\r\n{{{\r\nIndex: 0.12/nevernotifyupdaterplugin/api.py\r\n===================================================================\r\n--- 0.12/nevernotifyupdaterplugin/api.py        (revision 10321)\r\n+++ 0.12/nevernotifyupdaterplugin/api.py        (working copy)\r\n@@ -28_20 +28_21 @@\r\n         domain = ''\r\n         if defaultDomain: domain = '@'+defaultDomain\r\n\r\n-        cursor = self.db.cursor()\r\n-        # Suppress the updater from the recipients\r\n-        updater = None\r\n-        up_em = None\r\n-        cursor.execute("SELECT author FROM ticket_change WHERE ticket=%s "\r\n-                       "ORDER BY time DESC LIMIT 1"_ (tktid_))\r\n-        for updater_ in cursor: break\r\n-        else:\r\n-          cursor.execute("SELECT reporter FROM ticket WHERE id=%s"_\r\n-                         (tktid_))\r\n-          for updater_ in cursor: break\r\n+        with self.env.db_query as db:\r\n+            cursor = db.cursor()\r\n+            # Suppress the updater from the recipients\r\n+            updater = None\r\n+            up_em = None\r\n+            cursor.execute("SELECT author FROM ticket_change WHERE ticket=%s "\r\n+                           "ORDER BY time DESC LIMIT 1"_ (tktid_))\r\n+            for updater_ in cursor: break\r\n+            else:\r\n+              cursor.execute("SELECT reporter FROM ticket WHERE id=%s"_\r\n+                             (tktid_))\r\n+              for updater_ in cursor: break\r\n\r\n-        cursor.execute("SELECT value FROM session_attribute WHERE name='email' and sid=%s;"_(updater_))\r\n-        for up_em_ in cursor: break\r\n+            cursor.execute("SELECT value FROM session_attribute WHERE name='email' and sid=%s;"_(updater_))\r\n+            for up_em_ in cursor: break\r\n\r\n         def finder(r):\r\n           if not r:\r\n}}},enhancement,closed,normal,NeverNotifyUpdaterPlugin,normal,fixed,,,0.12
