Contents

class AddAppstatsResultsLatestFlag < ActiveRecord::Migration
  def self.up
    add_column :appstats_results, :is_latest, :boolean
    add_index :appstats_results, :is_latest
    
    Appstats.connection.update('update appstats_results set is_latest = false')
    all = Appstats.connection.select_all("select concat(id,' ',max(updated_at)) as id_and_date from appstats_results group by query")
    return if all.empty?
    ids = all.each.collect { |e| e["id_and_date"].split[0] }.compact
    Appstats.connection.update("update appstats_results set is_latest = '1' where id in (#{ids.join(',')})")
  end

  def self.down
    remove_index :appstats_results, :is_latest
    remove_column :appstats_results, :is_latest
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
appstats-0.22.5	db/migrations/20110318203339_add_appstats_results_latest_flag.rb
appstats-0.22.4	db/migrations/20110318203339_add_appstats_results_latest_flag.rb
appstats-0.22.3	db/migrations/20110318203339_add_appstats_results_latest_flag.rb