'''
Created on 14.06.2013

@author: dwinter
'''


import web

db = web.database(dbn='postgres', db='personalwww', user='dwinter',host="tuxserve03")


tab = db.select("pubmanbiblio_old")

data =set()

for res in tab:
    if res.priority is not None:
        data.add((res.key_main,res.escidocid,res.priority))
        
        
for d in data:
    db.insert("pubmanbiblio",key_main=d[0],escidocid=d[1],priority=d[2])
    
db.close()