module Rein::Constraint::Null

This module contains methods for defining null constraints.

Public Instance Methods

add_null_constraint(*args) click to toggle source
# File lib/rein/constraint/null.rb, line 9
def add_null_constraint(*args)
  reversible do |dir|
    dir.up { _add_null_constraint(*args) }
    dir.down { _remove_null_constraint(*args) }
  end
end
remove_null_constraint(*args) click to toggle source
# File lib/rein/constraint/null.rb, line 16
def remove_null_constraint(*args)
  reversible do |dir|
    dir.up { _remove_null_constraint(*args) }
    dir.down { _add_null_constraint(*args) }
  end
end

Private Instance Methods

_add_null_constraint(table, attribute, options = {}) click to toggle source
# File lib/rein/constraint/null.rb, line 25
def _add_null_constraint(table, attribute, options = {})
  name = Util.constraint_name(table, attribute, 'null', options)
  table = Util.wrap_identifier(table)
  attribute = Util.wrap_identifier(attribute)
  conditions = Util.conditions_with_if("#{attribute} IS NOT NULL", options)
  sql = "ALTER TABLE #{table} ADD CONSTRAINT #{name} CHECK (#{conditions})"
  execute(Util.add_not_valid_suffix_if_required(sql, options))
end
_remove_null_constraint(table, attribute, options = {}) click to toggle source
# File lib/rein/constraint/null.rb, line 34
def _remove_null_constraint(table, attribute, options = {})
  name = Util.constraint_name(table, attribute, 'null', options)
  table = Util.wrap_identifier(table)
  execute("ALTER TABLE #{table} DROP CONSTRAINT #{name}")
end