Contents

class CreateShowStatsView < ActiveRecord::Migration
  def change
    execute "CREATE OR REPLACE VIEW show_stats_view as select " + 
              "shows.id, shows.id as show_id, shows.event_id as event_id, shows.organization_id as organization_id, shows.datetime, shows.state as state, count(tickets.id) as capacity, venues.time_zone as time_zone,  " + 
              "SUM(CASE WHEN tickets.state='sold' then 1 else 0 end) as sold, " + 
              "SUM(CASE WHEN tickets.state='comped' then 1 else 0 end) as comped, " + 
              "SUM(CASE WHEN tickets.state='on_sale' then 1 else 0 end) as on_sale, " + 
              "SUM(CASE WHEN tickets.state='off_sale' then 1 else 0 end) as off_sale, " + 
              "SUM(CASE WHEN tickets.state='on_sale' or tickets.state='off_sale' then 1 else 0 end) as 'open' "  + 
              "from shows " + 
              "left join tickets on shows.id = tickets.show_id " + 
              "left join events on shows.event_id = events.id " + 
              "left join venues on events.venue_id = venues.id " +
              "group by shows.id"
  end
end

Version data entries

26 entries across 26 versions & 1 rubygems

Version	Path
artfully_ose-1.3.0.pre4	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.3.0.pre3	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.3.0.pre2	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.3.0.pre1	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.beta.1	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.alpha.2	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.alpha.1	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.27	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.26	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.24	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.23	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.21	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.20	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.19	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.18	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.17	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.16	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.15	db/migrate/20131002191646_create_show_stats_view.rb
artfully_ose-1.2.0.pre.12	db/migrate/20131002191646_create_show_stats_view.rb