import psycopg2
db = psycopg2.connect("host= 127.0.0.1 user=openerp password=openerp 
dbname=test")
cr=db.cursor()
cr.execute('select name,certificate from ir_module_module where not certificate 
is null order by name ')
for (name,certificate) in cr.fetchall():
        print name,certificate
        if not certificate[:2]== '00':
                cr.execute("update ir_module_module set 
certificate='00"+str(certificate)+"' where name ='"+name+"'")
                db.commit()

for me after apply this code  it's ok

------------------------
Eric Vernichon
http://www.vernichon.fr




-------------------- m2f --------------------

--
http://www.openobject.com/forum/viewtopic.php?p=29948#29948

-------------------- m2f --------------------


_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users

Reply via email to