diff options
author | Harald Eilertsen <haraldei@anduin.net> | 2018-01-13 16:47:29 +0100 |
---|---|---|
committer | Harald Eilertsen <haraldei@anduin.net> | 2018-01-13 16:47:29 +0100 |
commit | 6c5aaabe8bb0ae1b8025953f6a9c462846bbb873 (patch) | |
tree | 93f68b2d3307b8f64187444a769a92cebf135caa /vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb | |
parent | 97130af8dd3f761bbc4cc085def3cd39b80b876e (diff) | |
parent | 00e2586a42931567d2ac18350d41dd882e7fcd92 (diff) | |
download | hmnoweb-6c5aaabe8bb0ae1b8025953f6a9c462846bbb873.tar.gz hmnoweb-6c5aaabe8bb0ae1b8025953f6a9c462846bbb873.tar.bz2 hmnoweb-6c5aaabe8bb0ae1b8025953f6a9c462846bbb873.zip |
Merge branch 'gallery-links'
Diffstat (limited to 'vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb')
-rw-r--r-- | vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb b/vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb new file mode 100644 index 0000000..87492b6 --- /dev/null +++ b/vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb @@ -0,0 +1,37 @@ +class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration + def up + add_column :refinery_gallery_links, :date, :date, null: false, default: '2000-01-01', index: true + add_column :refinery_gallery_links, :bands, :string, null: false, default: 'Unknown bands', index: true + add_column :refinery_gallery_links, :venue, :string, index: true + + Refinery::GalleryLinks::GalleryLink.all.each do |g| + m = g.title.match /^(.+) (\d{2}\/\d{2}\/\d{2}) @ ([^.]+).$/ + if m + g.date = Date.strptime(m[2], '%d/%m/%y') + g.bands = m[1] + g.venue = m[3] + else + g.date = Date.today + g.bands = g.title + g.venue = nil + end + + g.save! + end + + remove_column :refinery_gallery_links, :title + end + + def down + add_column :refineru_gallery_links, title, index: true + + Refinery::GalleryLinks::GalleryLink.all.each do |g| + g.title = "#{g.bands} #{g.strftime('%d/%m/%y')} @ #{g.venue}." + g.save! + end + + remove_column :refinery_gallery_links, :venue + remove_column :refinery_gallery_links, :bands + remove_column :refinery_gallery_links, :date + end +end |