import time

from netforce.model import get_model
from netforce import migration
from netforce.access import set_active_user, set_active_company
from netforce.database import get_connection

class Migration(migration.Migration):
    _name="clinic.rename.dbl.hdcase.number"
    _version="2.12.2"
    
    def migrate(self):
        db=get_connection()
        res=db.query("""
            select c, number from (select count(number) as c,number from clinic_hd_case group by number order by number) as r1 where c > 1;
        """)
        for r in res:
            number=r['number']
            if number!='/':
                count=1
                for hdcase in get_model('clinic.hd.case').search_browse([['number','=',number]]):
                    hdcase.write({
                        'number': number+"."+str(count),
                    })
                    count+=1
                print(r)

Migration.register()