# HG changeset patch
# User Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
# Date 1432193279 -7200
# Node ID a1edd65c8ab723eef5157c1ed333c7ee575289dc
# Parent  7626731d1abe51b94f1cee28bad21dc56c11beaa
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein

diff -r 7626731d1abe -r a1edd65c8ab7 MPIWGStaff.py
--- 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: