def migrate(cr, version):
# Rename lngth into packaging_length
if column_exists(cr, "product_packaging", "packaging_length"):
cr.execute("UPDATE product_packaging SET packaging_length = lngth")
elif column_exists(cr, "product_packaging", "lngth"):
rename_column(cr, "product_packaging", "lngth", "packaging_length")
def update_db_column(self, model, column):
""" Create/update the column corresponding to ``self``.
For creation of geo column
:param model: an instance of the field's model
:param column: the column's configuration (dict)
if it exists, or ``None``
"""
# the column does not exist, create it
if not column:
create_geo_column(model._cr, model._table, self.name,
self.geo_type, self.srid, self.dim, self.string)
return
if column['udt_name'] == self.column_type[0]:
return
self.update_geo_db_column(model)
if column['udt_name'] in self.column_cast_from:
sql.convert_column(model._cr, model._table, self.name,
self.column_type[1])
else:
newname = (self.name + '_moved{}').format
i = 0
while sql.column_exists(model._cr, model._table, newname(i)):
i += 1
if column['is_nullable'] == 'NO':
sql.drop_not_null(model._cr, model._table, self.name)
sql.rename_column(model._cr, model._table, self.name, newname(i))
sql.create_column(model._cr, model._table, self.name,
self.column_type[1], self.string)
def migrate(cr, version):
# Rename estimated_pack_weight into estimated_pack_weight_kg
if column_exists(cr, "stock_quant_package", "estimated_pack_weight"):
rename_column(
cr,
"stock_quant_package",
"estimated_pack_weight",
"estimated_pack_weight_kg",
)
def migrate(cr, version):
# Rename lnght into packaging_length
if column_exists(cr, "product_packaging", "lnght"):
rename_column(cr, "product_packaging", "lnght", "packaging_length")
# Convert old hard-coded uom values (mm)
# into new default uom values (m)
cr.execute(
"""
UPDATE product_packaging
SET
packaging_length = packaging_length/1000,
height = height/1000,
width = width/1000,
"""
)
def migrate(cr, version):
sql.rename_column(cr, "res_partner", "auto_archive", "auto_archive_spread")
def migrate(cr, version):
if column_exists(cr, "res_partner", "state"):
if column_exists(cr, "res_partner", "old_state"):
cr.execute("ALTER TABLE res_partner DROP COLUMN old_state")
rename_column(cr, "res_partner", "state", "old_state")
def migrate(cr, version):
if column_exists(cr, "delay_export", "user_id"):
rename_column(cr, "delay_export", "user_id", "__temp_user_id")
def migrate(cr, version):
if column_exists(cr, "res_partner", "shopinvader_enabled"):
rename_column(cr, "res_partner", "shopinvader_enabled",
"is_shopinvader_active")
def migrate(cr, version):
if column_exists(cr, "res_partner", "commerce_enabled"):
rename_column(cr, "res_partner", "commerce_enabled",
"is_commerce_active")
def rename_amt_to_invoice(cr):
if (not sql.column_exists(cr, 'sale_order_line', 'risk_amount') and
sql.column_exists(cr, 'sale_order_line', 'amt_to_invoice')):
sql.rename_column(
cr, 'sale_order_line', 'amt_to_invoice', 'risk_amount')
