Contents

Sequel.migration do
  up do
  DB << <<EOS
UPDATE dependencies
SET license_id =
(SELECT la.id
FROM
  license_aliases la,
  license_aliases la_orig
WHERE
  la.name = la_orig.name AND
  la_orig.id = license_id
LIMIT 1)
EOS

  DB << <<CLEANUP
DELETE
FROM license_aliases
WHERE
id NOT IN (SELECT license_id FROM dependencies)
CLEANUP
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
license_finder-0.9.4-java	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.4	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.3-java	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.3	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.2-java	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.2	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.1-java	db/migrate/201307251107_reassociate_license.rb
license_finder-0.9.1	db/migrate/201307251107_reassociate_license.rb