# HG changeset patch
# User dwinter
# Date 1393312079 -3600
# Node ID 8fca81581883a572db2acf9010a0139831d325bf
# Parent  45ef92d6aa8c86d16b651ba76ae1c57f259ac2b6
getConeIDsFromDB added

diff -r 45ef92d6aa8c -r 8fca81581883 MPIWGStaff.py
--- a/MPIWGStaff.py	Wed Jan 08 14:24:36 2014 +0100
+++ b/MPIWGStaff.py	Tue Feb 25 08:07:59 2014 +0100
@@ -309,6 +309,33 @@
         return ret+"</body></html>"
 
 
+    def getConeIDsFromDB(self,REQUEST):
+        """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck"""
+        
+        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;"
+        coneIds = self.executeZSQL(qs)
+        
+        ret="""<?xml version="1.0" encoding="UTF-8"?>
+<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:dc="http://purl.org/dc/elements/1.1/">
+"""
+        
+        templ="""
+        <rdf:Description rdf:about="%s">
+        <dc:title>%s, %s</dc:title>
+        </rdf:Description>
+        """
+        print coneIds.names()
+        for coneId in coneIds:
+           
+            ret+=templ%(coneId["coneid"],coneId["last_name"],coneId["first_name"])
+            
+        ret+="""
+        </rdf:RDF>
+        """
+        if REQUEST is not None:
+            REQUEST.response.setHeader("Content-type", "text/XML")
+        return ret
+
 def manage_addMPIWGStaffFolderForm(self):
     """form for adding the project"""
     pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self)