changeset 281:a1edd65c8ab7

updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
author Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
date Thu, 21 May 2015 09:27:59 +0200
parents 7626731d1abe
children 37b89e8a8828
files MPIWGStaff.py
diffstat 1 files changed, 21 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/MPIWGStaff.py	Wed Mar 18 12:09:40 2015 +0100
+++ b/MPIWGStaff.py	Thu May 21 09:27:59 2015 +0200
@@ -305,7 +305,18 @@
         
         return ret+"</body></html>"
 
+    
+    def updateConeIds(self,REQUEST):
+        """holt alle coneids von allen member, die methode getconeid traegt diese dann auch all in die key tabelle ein, falls sie ich fehlen"""
 
+        mems= self.getMemberList()
+        cids=[]
+        for mem in mems:
+            cids.append(mem.getConeId())
+
+        return cids
+            
+    
     def getConeIDsFromDB(self,REQUEST):
         """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck"""
         
@@ -403,14 +414,19 @@
         return str(id)
     
     getId = getUsername
-    
     def getConeId(self):
         """return cone ID"""
-        results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key]) 
-        for res in results:
+        results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key])
+         for res in results:
             return res.coneid
-        return None
-    
+         
+        newConeId="http://pubman.mpiwg-berlin.mpg.de/cone/persons/resource/%s"%self.content.key
+         
+        results = self.folder.executeZSQL("INSERT  INTO keys (coneid,key_main) values(%s,%s)",[newConeId,self.content.key])
+         
+        return newConeId
+
+ 
     def getPublishedImageUrl(self, width=None, height=None, showAlways=False):
         """returns the URL to the image if it is published"""
         if self.content.image_p == 'yes' or showAlways: