--- a/managePurls/manageIndexMetaPURLs.py	Fri May 24 16:53:09 2013 +0200
+++ b/managePurls/manageIndexMetaPURLs.py	Wed Jun 05 17:37:09 2013 +0200
@@ -225,8 +225,35 @@
                 return ERROR,None
 
 
-
-
+    def getExistingRandom(self,number):
+        """gibt zufaellig existierende purls zurueck"""
+        
+        qst = "select count(*) from purls"
+        max = self.purlDB.query(qst)[0].count
+        
+        random.seed()
+        
+        ret=set()
+        
+        while len(ret)<number:
+            zuf = random.randrange(max-1)
+            
+            qst="select purl from purls OFFSET %s LIMIT 1"%zuf
+            purl=self.purlDB.query(qst)[0].purl
+            ret.add(purl)
+            
+        return [x for x in ret]
+        
+    def getLastEntries(self,number):
+        
+        qst ="select purl from purls order by created_at limit %s"%number
+        purls=self.purlDB.query(qst)
+        ret=[]
+        for purl in purls:
+            ret.append(purl.purl)
+            
+        return ret
+        
 if __name__ == '__main__':
     
     im = IndexMetaPURLManager()