Sha256: 0a022bf1000907e785c1697117633435c7a22f2e63e037a75a70d9dacbca6a71
Contents?: true
Size: 1017 Bytes
Versions: 23
Compression:
Stored size: 1017 Bytes
Contents
class AddDaysTextToHDScheduleDefinitions < ActiveRecord::Migration[5.1]
def change
add_column :hd_schedule_definitions, :days_text, :text
add_column :hd_schedule_definitions, :sort_order, :integer, null: false, default: 0
reversible do |direction|
direction.up do
sql = <<-SQL
update hd_schedule_definitions set days_text = 'Mon Wed Fri' where days::text = '{1,3,5}';
update hd_schedule_definitions set days_text = 'Tue Thu Sat' where days::text = '{2,4,6}';
SQL
connection.execute(sql)
end
end
add_column :hd_diurnal_period_codes, :sort_order, :integer, default: 0, null: false
reversible do |direction|
direction.up {
connection.execute(<<-SQL)
update hd_diurnal_period_codes set sort_order = 1 where code = 'am';
update hd_diurnal_period_codes set sort_order = 2 where code = 'pm';
update hd_diurnal_period_codes set sort_order = 3 where code = 'eve';
SQL
}
end
end
end
Version data entries
23 entries across 23 versions & 1 rubygems