Sha256: b238e1c0b95f2d9783a3f0ecf7ca43186a17e8df6b3886623cefa510654b37de

Contents?: true

Size: 794 Bytes

Versions: 11

Compression:

Stored size: 794 Bytes

Contents

Sequel.migration do
  # Updates the database with the changes specified in the block.
  up do
    entries = Zen.database[:section_entries].all

    drop_column(:section_entries, :slug)
    add_column(:section_entries , :slug, String)
    add_index(:section_entries  , :slug)

    entries.each do |entry|
      Zen.database[:section_entries] \
        .filter(:id => entry[:id]).update(:slug => entry[:slug])
    end
  end
  
  # Reverts the changes made in the up() block.
  down do
    entries = Zen.database[:section_entries].all

    drop_column(:section_entries, :slug)
    add_column(:section_entries, :slug, String, :unique => true)

    entries.each do |entry|
      Zen.database[:section_entries] \
        .filter(:id => entry[:id]).update(:slug => entry[:slug])
    end    
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version Path
zen-0.4.3 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.4.2 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.4.1 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.4 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.3 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.3b1 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.3b lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.2.8 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.2.7 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.2.6.1 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb
zen-0.2.6 lib/zen/package/sections/migrations/1306772479_remove_unique_slug.rb