Contents

class RemoveTrailingSlashesInTaxonPermalinks < ActiveRecord::Migration
  def up
    taxons = select_all "SELECT * FROM taxons"
    taxons.each do |taxon|
      if taxon['permalink'] && taxon['permalink'][-1..-1] == '/'
        execute "UPDATE taxons SET permalink = '#{taxon['permalink'][0...-1]}' WHERE id = #{taxon['id']}"
      end
    end
  end

  def down
    taxons = select_all "SELECT * FROM taxons"
    taxons.each do |taxon|
      if taxon['permalink'] && taxon['permalink'][-1..-1] != '/'
        execute "UPDATE taxons SET permalink = '#{taxon['permalink'] + '/'}' WHERE id = #{taxon['id']}"
      end
    end
  end
end

Version data entries

35 entries across 35 versions & 3 rubygems

Version	Path
spree_core-1.2.5	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.6	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.5	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.4	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.0.7	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.3	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.2	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.4	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.0	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.0.rc2	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.2.0.rc1	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.3	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.0.6	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_pag_seguro-1.0.7	spec/dummy/db/migrate/20120301154131_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.2	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.2.rc1	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb
spree_pag_seguro-1.0.6	spec/dummy/db/migrate/20120301154131_remove_trailing_slashes_in_taxon_permalinks.rb
spree_pag_seguro-1.0.5	spec/dummy/db/migrate/20120301154131_remove_trailing_slashes_in_taxon_permalinks.rb
spree_pag_seguro-1.0.4	spec/dummy/db/migrate/20120301154131_remove_trailing_slashes_in_taxon_permalinks.rb
spree_core-1.1.1	db/migrate/20110314192118_remove_trailing_slashes_in_taxon_permalinks.rb