Changeset 8332 for mauRepo/MolesManager/trunk/src/MolesManager/molesSessionMiddleware.py

Timestamp:

11/06/12 10:27:19 (9 years ago)

Author:

mnagni

Message:

Defined a better procedure if the DB connection is lost
Defined a very very basic error page

File:

• mauRepo/MolesManager/trunk/src/MolesManager/molesSessionMiddleware.py (modified) (4 diffs)

mauRepo/MolesManager/trunk/src/MolesManager/molesSessionMiddleware.py

@@ -12 +12 @@
 from libs.migration.InfodbEPB import InfodbEPBFactory
 from libs.migration.MigrationEPB import MigrationEPBFactory
+from sqlalchemy.exc import SQLAlchemyError
+from django.core.context_processors import csrf
+from django.shortcuts import render_to_response
 
 
@@ -26 +29 @@
     
     def _doInitialization(self):
+
         infoDB = DbManager(INFO_DB_CONNECTION)
         MolesSessionMiddleware._infodbEPBFactory = InfodbEPBFactory(infoDB)
@@ -41 +45 @@
             interval = MIGRATION_INTERVAL )
         MolesSessionMiddleware._epbInitialized = True      
-        
+            
         self._migration() #see the note on  MolesSessionMiddleware._migration      
     
@@ -67 +71 @@
     
     def process_request(self, request):  
-        if not MolesSessionMiddleware._epbInitialized:
-            self._doInitialization()     
-
-        '''
-            @deprecated: request.moles_session is going to be removed from all GUI-related instances
-        '''
-        request.moles3EPB = MolesSessionMiddleware._moles3EPBFactory.createMoles3EPB()
-
+        try:
+            if not MolesSessionMiddleware._epbInitialized:
+                self._doInitialization()
+                  
+            request.moles3EPB = MolesSessionMiddleware._moles3EPBFactory.createMoles3EPB()                   
+        except SQLAlchemyError as ex:
+            MolesSessionMiddleware._epbInitialized = False
+            return self.process_exception(request, ex)
 
     def process_response(self, request, response):
-        request.moles3EPB.close()
+        if hasattr(request, "moles3EPB"):            
+            request.moles3EPB.close()
+            
         return response
 
-
     def process_exception(self, request, exception):
-        pass
-        """
         try:
-            session = request.moles_session            
-        except AttributeError:
-            return
-        session.rollback()
-        session.close()
-        """        
+            c = {}
+            c['exception'] = exception
+            c.update(csrf(request))
+            return render_to_response('errorTemplate.html', c)
+        except SQLAlchemyError as ex:
+            MolesSessionMiddleware._epbInitialized = False            
+