Migrate res.partner images (odoo shell)

gistfile1.txt

partners = env['res.partner'].search([])
for p in partners:
    if not p.image:
        env.cr.execute("SELECT image FROM res_partner WHERE id = " + str(p.id) + ";")
        d = env.cr.fetchall()
        p.image = str(d[0][0])

env.cr.commit()

# verify data is migrated then
env.cr.execute('ALTER TABLE res_partner DROP COLUMN IF EXISTS image;')
env.cr.execute('ALTER TABLE res_partner DROP COLUMN IF EXISTS image_medium;')
env.cr.execute('ALTER TABLE res_partner DROP COLUMN IF EXISTS image_small;')
env.cr.commit()