
from openupgradelib import openupgrade

@openupgrade.migrate()
def migrate(env, version):
    cr = env.cr
    cr.execute(
        '''INSERT INTO res_city(id, name, country_id, state_id, ibge_code) 
        SELECT nextval('res_city_id_seq'), name, (SELECT id FROM res_country 
        WHERE code='BR'), state_id, ibge_code FROM l10n_br_base_city 
        WHERE ibge_code NOT IN (SELECT ibge_code FROM res_city);
        ''')
    cr.execute(
        '''INSERT INTO state_tax_numbers(id, inscr_est, partner_id, state_id)
        SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id, 
        state_id FROM other_inscricoes_estaduais;
        ''')
    cr.execute(
        '''UPDATE res_partner rp SET city_id=(
        SELECT id FROM res_city WHERE ibge_code=(
        SELECT ibge_code FROM l10n_br_base_city WHERE id=rp.l10n_br_city_id))
        ''')


from openupgradelib import openupgrade

_model_renames = [
    ('l10n_br_base.city', 'res.city'),
]

_table_renames = [
    ('l10n_br_base_city', 'res_city'),
]


@openupgrade.migrate()
def migrate(env, version):
    cr = env.cr
    openupgrade.rename_models(cr, _model_renames)
    openupgrade.rename_tables(cr, _table_renames)
    cr.execute(
        '''INSERT INTO state_tax_numbers(id, inscr_est, partner_id, state_id)
        SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id,
        state_id FROM other_inscricoes_estaduais;
        ''')
    cr.execute(
        '''UPDATE res_partner rp SET city_id=(
        SELECT id FROM res_city WHERE ibge_code=(
        SELECT ibge_code FROM l10n_br_base_city WHERE id=rp.l10n_br_city_id))
        ''')

Rename table _model_renames and _table_renames
[ADD] Rename table _model_renames and _table_renames

Signed-off-by: Luis Felipe Mileo <c9a5b4d335634d99740001a1172b3e56e4fc5aa8@kmee.com.br>

  
  from openupgradelib import openupgrade
+ 
+ _model_renames = [
+     ('l10n_br_base.city', 'res.city'),
+ ]
+ 
+ _table_renames = [
+     ('l10n_br_base_city', 'res_city'),
+ ]
+ 
  
  @openupgrade.migrate()
  def migrate(env, version):
      cr = env.cr
+     openupgrade.rename_models(cr, _model_renames)
+     openupgrade.rename_tables(cr, _table_renames)
-     cr.execute(
-         '''INSERT INTO res_city(id, name, country_id, state_id, ibge_code) 
-         SELECT nextval('res_city_id_seq'), name, (SELECT id FROM res_country 
-         WHERE code='BR'), state_id, ibge_code FROM l10n_br_base_city 
-         WHERE ibge_code NOT IN (SELECT ibge_code FROM res_city);
-         ''')
      cr.execute(
          '''INSERT INTO state_tax_numbers(id, inscr_est, partner_id, state_id)
-         SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id, 
+         SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id,
          state_id FROM other_inscricoes_estaduais;
          ''')
      cr.execute(
          '''UPDATE res_partner rp SET city_id=(
          SELECT id FROM res_city WHERE ibge_code=(
          SELECT ibge_code FROM l10n_br_base_city WHERE id=rp.l10n_br_city_id))
          ''')
  
Rename table _model_renames and _table_renames
## Code Before:

from openupgradelib import openupgrade

@openupgrade.migrate()
def migrate(env, version):
    cr = env.cr
    cr.execute(
        '''INSERT INTO res_city(id, name, country_id, state_id, ibge_code) 
        SELECT nextval('res_city_id_seq'), name, (SELECT id FROM res_country 
        WHERE code='BR'), state_id, ibge_code FROM l10n_br_base_city 
        WHERE ibge_code NOT IN (SELECT ibge_code FROM res_city);
        ''')
    cr.execute(
        '''INSERT INTO state_tax_numbers(id, inscr_est, partner_id, state_id)
        SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id, 
        state_id FROM other_inscricoes_estaduais;
        ''')
    cr.execute(
        '''UPDATE res_partner rp SET city_id=(
        SELECT id FROM res_city WHERE ibge_code=(
        SELECT ibge_code FROM l10n_br_base_city WHERE id=rp.l10n_br_city_id))
        ''')

## Instruction:
Rename table _model_renames and _table_renames
## Code After:

from openupgradelib import openupgrade

_model_renames = [
    ('l10n_br_base.city', 'res.city'),
]

_table_renames = [
    ('l10n_br_base_city', 'res_city'),
]


@openupgrade.migrate()
def migrate(env, version):
    cr = env.cr
    openupgrade.rename_models(cr, _model_renames)
    openupgrade.rename_tables(cr, _table_renames)
    cr.execute(
        '''INSERT INTO state_tax_numbers(id, inscr_est, partner_id, state_id)
        SELECT nextval('state_tax_numbers_id_seq'), inscr_est, partner_id,
        state_id FROM other_inscricoes_estaduais;
        ''')
    cr.execute(
        '''UPDATE res_partner rp SET city_id=(
        SELECT id FROM res_city WHERE ibge_code=(
        SELECT ibge_code FROM l10n_br_base_city WHERE id=rp.l10n_br_city_id))
        ''')
