# HG changeset patch
# User dwinter
# Date 1351697712 -3600
# Node ID fef9ad4020eec6b855281236db5d592bc65657b0
# Parent  08a476cdcfea01ef2b8fc218fe787ebfc6c07ee9
sql change

diff -r 08a476cdcfea -r fef9ad4020ee manageIndexMetaPURLs.py
--- a/manageIndexMetaPURLs.py	Wed Oct 31 14:57:53 2012 +0100
+++ b/manageIndexMetaPURLs.py	Wed Oct 31 16:35:12 2012 +0100
@@ -30,7 +30,7 @@
     # server_url base_url of server
   
     def __init__(self):
-        self.purlDB = web.database(dbn="postgres", db="purlDB",user="purlUSER",password="XXXX")
+        self.purlDB = web.database(dbn="postgres", db="purlDB",user="purlUSER",password="p*lWa55eR",host="localhost")
       
     
     
@@ -51,7 +51,8 @@
             
     
     def getPurl(self,path):  
-        urls = self.purlDB.select('"purls"',where="path='%s'"%path)
+        #urls = self.purlDB.select('"purls"',where="path=%s"%web.sqlquote(path.replace("'"))
+        urls = self.purlDB.query("select * from purls where path=$path",vars={'path':path})
         if urls is None or len(urls)==0:
             return None
         else:
@@ -156,4 +157,4 @@
     
     im = IndexMetaPURLManager()
     print im.register("/tmp3/index.meta", True, "", "dwinter")
-    pass
\ No newline at end of file
+    pass