diff MPIWGStaff.py @ 48:f59bdd5f4890

Merge with 5c6ad316e1ceef48e323907ab81dd50e7ef743b2
author dwinter
date Mon, 29 Apr 2013 16:02:24 +0200
parents 225179dfd892 fd8e78bbc5ed
children e718d9a72f19
line wrap: on
line diff
--- a/MPIWGStaff.py	Mon Apr 29 16:01:24 2013 +0200
+++ b/MPIWGStaff.py	Mon Apr 29 16:02:24 2013 +0200
@@ -1093,13 +1093,20 @@
                 member = MPIWGStaffMember(self, dbresult=content)
         
         elif key is not None:
-            content = folder.executeZSQL("select * from personal_www where key = %s", [key])
+            # TODO: sometimes key is lowercased (e.g. responsibleScientistsList), we should fix the data
+            content = self.executeZSQL("select * from personal_www where lower(key) = %s", [key.lower()])
             if len(content) > 0:
                 member = MPIWGStaffMember(self, dbresult=content)             
          
         return member
     
 
+    def isActiveMember(self, key):
+        """returns if member key is active"""
+        res = self.executeZSQL("select * from personal_www where lower(key) = %s and publish_the_data = 'yes'", [key.lower()])
+        return len(res) > 0
+
+
     def sortPriority(self,list):
         def sort(x,y):
             try:
@@ -1578,7 +1585,7 @@
         REQUEST.response.redirect(self.REQUEST['HTTP_REFERER'])
  
    
-    def invalidate_chache(self):
+    def invalidate_cache(self):
         #TODO: How to invalidate the varnish cache from the member object
         pass;