From 41b0d6bc69e3b0f751290b442e2f171a0ae8090d Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 7 Jan 2018 17:12:47 +0100 Subject: Split GalleryLink header into date, venue and bands. --- .../2_replace_title_with_date_bands_venue.rb | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb (limited to 'vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb') 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..d53125d --- /dev/null +++ b/vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb @@ -0,0 +1,31 @@ +class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration + def up + add_column :refinery_gallery_links, :date, :date, null: false, default: '0000-00-00', 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}) @ ([^.]+).$/ + g.date = Date.strptime(m[2], '%d/%m/%y') + g.bands = m[1] + g.venue = m[3] + + 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 -- cgit v1.2.3 From 66eb0bdf9eb080ab3d8becd7cebe7081ca2a06b4 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 7 Jan 2018 17:22:20 +0100 Subject: Fix default date for GalleryLinks migration. --- .../gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb') 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 index d53125d..01bb932 100644 --- 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 @@ -1,6 +1,6 @@ class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration def up - add_column :refinery_gallery_links, :date, :date, null: false, default: '0000-00-00', index: true + 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 @@ -23,7 +23,7 @@ class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration 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 -- cgit v1.2.3 From 00e2586a42931567d2ac18350d41dd882e7fcd92 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 7 Jan 2018 18:55:03 +0100 Subject: Handle non-matching GalleryLink entries inmigration. --- .../db/migrate/2_replace_title_with_date_bands_venue.rb | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) (limited to 'vendor/extensions/gallery_links/db/migrate/2_replace_title_with_date_bands_venue.rb') 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 index 01bb932..87492b6 100644 --- 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 @@ -6,9 +6,15 @@ class ReplaceTitleWithDateBandsVenue < ActiveRecord::Migration Refinery::GalleryLinks::GalleryLink.all.each do |g| m = g.title.match /^(.+) (\d{2}\/\d{2}\/\d{2}) @ ([^.]+).$/ - g.date = Date.strptime(m[2], '%d/%m/%y') - g.bands = m[1] - g.venue = m[3] + 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 -- cgit v1.2.3