Mercurial > hg > MPIWGWeb
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: