Changeset 570

Timestamp:

10/13/08 22:38:18 (5 years ago)

Author:

cbalan

Message:

Dashboardreports: - added rollback on error in order to prevent other queries to fail.

File:

• trunk/plugins/dashboardreportsplugin/dashboardreports/api.py (modified) (1 diff)

trunk/plugins/dashboardreportsplugin/dashboardreports/api.py

@@ -347 +347 @@
         db = formatter.db
         cursor = db.cursor()
-        cursor.execute(sql)
-        sql_return = cursor.fetchall()
-        cursor.close()
-        
+        sql_return = []
+        try:
+            cursor.execute(sql)
+            sql_return = [row for row in cursor if row != ""]
+            cursor.close()
+        except:
+            db.rollback()
+            raise
         # return with striped null values
-        return [row for row in sql_return if row != ""]
+        return sql_return
     
     def get_severities(self, formatter, group_by, table="ticket"):