Contents

Sequel.migration do
  up do
    alter_table(:dependencies) do
      add_column :license_name, String
    end

    LicenseFinder::DB << <<-SQL
      UPDATE dependencies
      SET license_name =
      (SELECT name
      FROM
        license_aliases
      WHERE
        license_id = license_aliases.id)
    SQL

    alter_table(:dependencies) do
      drop_column :license_id
    end

    drop_table(:license_aliases)
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
license_finder-1.2	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.2-java	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.1.1-java	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.1.1	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.1.0	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.0.1	db/migrate/201403191645_remove_license_aliases.rb
license_finder-1.0.0.1	db/migrate/201403191645_remove_license_aliases.rb