From 189407cc44275016a0b00798a3dac704f870f8c0 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 17 Dec 2017 12:37:40 +0100 Subject: Install GalleryLinks extension into main app. --- ...y_links_gallery_links.refinery_gallery_links.rb | 31 ++++++++++++++++++++++ db/schema.rb | 13 ++++++++- db/seeds.rb | 3 +++ 3 files changed, 46 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb (limited to 'db') diff --git a/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb b/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb new file mode 100644 index 0000000..03a5865 --- /dev/null +++ b/db/migrate/20171217104241_create_gallery_links_gallery_links.refinery_gallery_links.rb @@ -0,0 +1,31 @@ +# This migration comes from refinery_gallery_links (originally 1) +class CreateGalleryLinksGalleryLinks < ActiveRecord::Migration + + def up + create_table :refinery_gallery_links do |t| + t.string :title + t.string :url + t.string :photographer + t.text :description + t.integer :image_id + t.integer :position + + t.timestamps + end + + end + + def down + if defined?(::Refinery::UserPlugin) + ::Refinery::UserPlugin.destroy_all({:name => "refinerycms-gallery_links"}) + end + + if defined?(::Refinery::Page) + ::Refinery::Page.delete_all({:link_url => "/gallery_links/gallery_links"}) + end + + drop_table :refinery_gallery_links + + end + +end diff --git a/db/schema.rb b/db/schema.rb index 4d3fe93..512de33 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20151210191646) do +ActiveRecord::Schema.define(:version => 20171217104241) do create_table "refinery_banners", :force => true do |t| t.string "name" @@ -115,6 +115,17 @@ ActiveRecord::Schema.define(:version => 20151210191646) do add_index "refinery_blog_posts", ["id"], :name => "index_refinery_blog_posts_on_id" add_index "refinery_blog_posts", ["slug"], :name => "index_refinery_blog_posts_on_slug" + create_table "refinery_gallery_links", :force => true do |t| + t.string "title" + t.string "url" + t.string "photographer" + t.text "description" + t.integer "image_id" + t.integer "position" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + create_table "refinery_image_page_translations", :force => true do |t| t.integer "refinery_image_page_id" t.string "locale" diff --git a/db/seeds.rb b/db/seeds.rb index 7391f95..f351030 100644 --- a/db/seeds.rb +++ b/db/seeds.rb @@ -19,3 +19,6 @@ Refinery::Inquiries::Engine.load_seed Refinery::Search::Engine.load_seed Refinery::Banners::Engine.load_seed + +# Added by Refinery CMS GalleryLinks extension +Refinery::GalleryLinks::Engine.load_seed -- cgit v1.2.3 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. --- ...with_date_bands_venue.refinery_gallery_links.rb | 32 ++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb (limited to 'db') diff --git a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb new file mode 100644 index 0000000..8e2fcbd --- /dev/null +++ b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb @@ -0,0 +1,32 @@ +# This migration comes from refinery_gallery_links (originally 2) +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: 'Unkown 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. --- ...2351_replace_title_with_date_bands_venue.refinery_gallery_links.rb | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb index 8e2fcbd..86e9dd8 100644 --- a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb +++ b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb @@ -1,7 +1,7 @@ # This migration comes from refinery_gallery_links (originally 2) 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: 'Unkown bands', index: true add_column :refinery_gallery_links, :venue, :string, index: true @@ -24,7 +24,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. --- ...ace_title_with_date_bands_venue.refinery_gallery_links.rb | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb index 86e9dd8..2f79338 100644 --- a/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb +++ b/db/migrate/20180107152351_replace_title_with_date_bands_venue.refinery_gallery_links.rb @@ -7,9 +7,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