Sha256: 3fc69a6ec5e4a65260c599ba4a8001a1a9770c70b73b08a997551e90a2b09984

Contents?: true

Size: 885 Bytes

Versions: 17

Compression:

Stored size: 885 Bytes

Contents

class AddAntecedentsToTickets < ActiveRecord::Migration
  def up
    add_column :tickets, :antecedents, :string, array: true

    Ticket.reset_column_information

    Ticket.unscoped.find_each do |ticket|
      goldmine_numbers = ticket.goldmine || ""

      antecedents = []
      antecedents.concat goldmine_numbers.split(/[, ]/).map(&:strip).reject(&:blank?).map { |number| "Goldmine:#{number}" }
      antecedents.concat ticket.description.to_s.scan(/^Goldmine: (\d+)/).flatten.map { |number| "Goldmine:#{number}" }
      antecedents.concat ticket.description.to_s.scan(/^Errbit: ([0-9a-fA-F]+)/).flatten.map { |number| "Errbit:#{number}" }

      next if antecedents.empty?

      puts "#{ticket.id}: #{antecedents.join(", ")}"
      ticket.antecedents = antecedents
      ticket.save!(validate: false)
    end
  end

  def down
    remove_column :tickets, :antecedents
  end
end

Version data entries

17 entries across 17 versions & 1 rubygems

Version Path
houston-core-0.8.0.pre db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.7.0 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.7.0.beta4 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.7.0.beta3 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.7.0.beta2 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.7.0.beta db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.6.3 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.6.2 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.6.1 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.6.0 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.6 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.5 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.4 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.3 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.2 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.1 db/migrate/20130504135741_add_antecedents_to_tickets.rb
houston-core-0.5.0 db/migrate/20130504135741_add_antecedents_to_tickets.rb