You are an expert in writing code in many different languages. Your goal is to perform code completion for the following code, keeping in mind the rest of the code and the file meta data.
    Metadata details:
    filename: 20210209135343_add_new_variant_types.rb
    path of file: ./repos/ekylibre/db/migrate
    
    the code of the file until where you have to start completion: class AddNewVariantTypes < ActiveRecord::Migration[5.0]
  PLANT_CHILDREN = %w[plant acer acer_buergerianum acer_ginnala acer_pseudoplatanus acer_saccharinum acer_saccharum acer_spicatum acer_tataricum actinidia actinidia_chinensis actinidia_deliciosa actinidiaceae adoxa adoxaceae ajuga ajuga_reptans allium allium_ampeloprasum allium_cepa allium_cepa_aggregatum allium_cepa_b010282 allium_cepa_b010283 allium_cepa_b010284 allium_cepa_valenciana allium_oleraceum allium_porrum allium_porrum_belton allium_porrum_duraton allium_porrum_kenton allium_porrum_krypton allium_po
    
  def change
    execute <<~SQL
      UPDATE product_nature_variants
        SET type = 'Variants::Equipments::MotorizedEquipmentEquipment'
      WHERE variety IN ('motorized_vehicle', 'car', 'handling_equipment', 'heavy_equipment', 'self_propelled_equipment', 'tractor', 'truck');

      UPDATE product_nature_variants
        SET type = 'Variants::Equipments::TrailedEquipmentEquipment'
      WHERE variety = 'trailed_equipment';

      UPDATE product_nature_variants
        SET type = 'Variants::Equipments::ToolEquipment'
      WHERE variety = 'portable_equipment';

      UPDATE product_nature_variants AS pnv
        SET type = 'Variants::Articles::FarmProductArticle'
      FROM product_nature_categories AS pnc
      WHERE pnv.category_id = pnc.id
        AND pnv.type = 'Variants::ArticleVariant'
        AND pnc.saleable = 't'
        AND derivative_of IN ('#{(PLANT_CHILDREN + ANIMAL_CHILDREN).join("', '")}')
    SQL
  end