Contents

# frozen_string_literal: true

class AddNotNullConstraintsForTimestampColumns < ActiveRecord::Migration[4.2]
  def up
    set_timestamp_constraints null: false unless $FFCRM_NEW_DATABASE
  end

  def down
    set_timestamp_constraints {} unless $FFCRM_NEW_DATABASE
  end

  private

  def set_timestamp_constraints(constraints)
    ActiveRecord::Base.connection.tables.each do |table|
      # If table has both timestamp columns, set not null constraints on both columns.
      next unless %i[created_at updated_at].all? { |column| column_exists?(table, column) }

      %i[created_at updated_at].each do |column|
        change_column table, column, :datetime, constraints
      end
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
fat_free_crm-0.22.1	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.22.0	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.21.0	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.20.1	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.20.0	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.19.2	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb
fat_free_crm-0.19.0	db/migrate/20120510025219_add_not_null_constraints_for_timestamp_columns.rb