Mercurial > hg > MPIWGWeb

comparison MPIWGStaff.py @ 281:a1edd65c8ab7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 3f9ba7a8cb27
children 37b89e8a8828
comparison
equal deleted inserted replaced
280:7626731d1abe 281:a1edd65c8ab7
303 303
304 ret+="<p>Added: %s</p>"%key 304 ret+="<p>Added: %s</p>"%key
305 305
306 return ret+"</body></html>" 306 return ret+"</body></html>"
307 307
308 308
309 def updateConeIds(self,REQUEST):
310 """holt alle coneids von allen member, die methode getconeid traegt diese dann auch all in die key tabelle ein, falls sie ich fehlen"""
311
312 mems= self.getMemberList()
313 cids=[]
314 for mem in mems:
315 cids.append(mem.getConeId())
316
317 return cids
318
319
309 def getConeIDsFromDB(self,REQUEST): 320 def getConeIDsFromDB(self,REQUEST):
310 """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck""" 321 """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck"""
311 322
312 qs = "select personal_www.last_name, personal_www.first_name, keys.coneid from personal_www inner join keys on personal_www.key = keys.key_main;" 323 qs = "select personal_www.last_name, personal_www.first_name, keys.coneid from personal_www inner join keys on personal_www.key = keys.key_main;"
313 coneIds = self.executeZSQL(qs) 324 coneIds = self.executeZSQL(qs)
401 """returns the username""" 412 """returns the username"""
402 id = re.sub('@mpiwg-berlin\.mpg\.de', '', self.content.e_mail) 413 id = re.sub('@mpiwg-berlin\.mpg\.de', '', self.content.e_mail)
403 return str(id) 414 return str(id)
404 415
405 getId = getUsername 416 getId = getUsername
406
407 def getConeId(self): 417 def getConeId(self):
408 """return cone ID""" 418 """return cone ID"""
409 results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key]) 419 results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key])
410 for res in results: 420 for res in results:
411 return res.coneid 421 return res.coneid
412 return None 422
413 423 newConeId="http://pubman.mpiwg-berlin.mpg.de/cone/persons/resource/%s"%self.content.key
424
425 results = self.folder.executeZSQL("INSERT INTO keys (coneid,key_main) values(%s,%s)",[newConeId,self.content.key])
426
427 return newConeId
428
429
414 def getPublishedImageUrl(self, width=None, height=None, showAlways=False): 430 def getPublishedImageUrl(self, width=None, height=None, showAlways=False):
415 """returns the URL to the image if it is published""" 431 """returns the URL to the image if it is published"""
416 if self.content.image_p == 'yes' or showAlways: 432 if self.content.image_p == 'yes' or showAlways:
417 url = 'http://digilib.mpiwg-berlin.mpg.de/digitallibrary/Scaler?fn=permanent/mpiwg/staff/%s'%self.getUsername() 433 url = 'http://digilib.mpiwg-berlin.mpg.de/digitallibrary/Scaler?fn=permanent/mpiwg/staff/%s'%self.getUsername()
418 if width is not None: 434 if width is not None: