Sha256: 596a5f5d4a730464f9b3d24c9a615539bde6efe379894db527dab679e9196125

Contents?: true

Size: 979 Bytes

Versions: 13

Compression:

Stored size: 979 Bytes

Contents

class ZafuFixSept09 < ActiveRecord::Migration
  def self.up
    # Update zafu from zena 0.13 to 0.14 (2009-09-24 changes)
    select_all("SELECT `id`, `text` FROM #{TemplateVersion.table_name}", "#{TemplateVersion.table_name} Load").each do |record|
      old_zafu = record['text']
      new_zafu = old_zafu.gsub(%r{<r:uses_calendar\s*/>}, '<r:uses_datebox/>')
      execute "UPDATE #{TemplateVersion.table_name} SET text = #{quote(new_zafu)} WHERE id = #{record['id']}" if new_zafu != old_zafu
    end
  end

  def self.down
    # Update zafu from zena 0.13 to 0.14 (2009-09-24 changes)
    select_all("SELECT `id`, `text` FROM #{TemplateVersion.table_name}", "#{TemplateVersion.table_name} Load").each do |record|
      old_zafu = record['text']
      new_zafu = old_zafu.gsub(%r{<r:uses_datebox\s*/>}, '<r:uses_calendar/>')
      execute "UPDATE #{TemplateVersion.table_name} SET text = #{quote(new_zafu)} WHERE id = #{record['id']}" if new_zafu != old_zafu
    end
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version Path
zena-0.16.9 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.8 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.7 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.6 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.5 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.4 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.3 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.2 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.1 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.16.0 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.15.2 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.15.1 db/migrate/20090924141459_zafu_fix_sept09.rb
zena-0.15.0 db/migrate/20090924141459_zafu_fix_sept09.rb