From 41b0d6bc69e3b0f751290b442e2f171a0ae8090d Mon Sep 17 00:00:00 2001
From: Harald Eilertsen <haraldei@anduin.net>
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