Mercurial > hg > ZopePubmanConnector
comparison scripts/cleanPub.py @ 16:3e154b154b6f
timeouts
| author | dwinter |
|---|---|
| date | Fri, 14 Jun 2013 12:27:01 +0200 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| 15:ca3084877394 | 16:3e154b154b6f |
|---|---|
| 1 ''' | |
| 2 Created on 14.06.2013 | |
| 3 | |
| 4 @author: dwinter | |
| 5 ''' | |
| 6 | |
| 7 | |
| 8 import web | |
| 9 | |
| 10 db = web.database(dbn='postgres', db='personalwww', user='dwinter',host="tuxserve03") | |
| 11 | |
| 12 | |
| 13 tab = db.select("pubmanbiblio_old") | |
| 14 | |
| 15 data =set() | |
| 16 | |
| 17 for res in tab: | |
| 18 if res.priority is not None: | |
| 19 data.add((res.key_main,res.escidocid,res.priority)) | |
| 20 | |
| 21 | |
| 22 for d in data: | |
| 23 db.insert("pubmanbiblio",key_main=d[0],escidocid=d[1],priority=d[2]) | |
| 24 | |
| 25 db.close() |