Sha256: 062566e8612049f0068e7f5069fef9867804fc107042dd0348361e24be48b9ac
Contents?: true
Size: 1.07 KB
Versions: 98
Compression:
Stored size: 1.07 KB
Contents
class AddDaysTextToHDScheduleDefinitions < ActiveRecord::Migration[5.1]
def change
within_renalware_schema do
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
end
Version data entries
98 entries across 98 versions & 1 rubygems