module Sequel::ConstraintValidations

Constants

DEFAULT_CONSTRAINT_VALIDATIONS_TABLE

The default table name used for the validation metadata.

OPERATORS
REVERSE_OPERATOR_MAP

Attributes

constraint_validations_table[RW]

The name of the table storing the validation metadata. If modifying this from the default, this should be changed directly after loading the extension into the database

Public Class Methods

extended(db) click to toggle source

Set the default validation metadata table name if it has not already been set.

# File lib/sequel/extensions/constraint_validations.rb, line 146
def self.extended(db)
  db.constraint_validations_table ||= DEFAULT_CONSTRAINT_VALIDATIONS_TABLE
end

Public Instance Methods

alter_table_generator(&block) click to toggle source

Modify the default alter_table generator to include the constraint validation methods.

# File lib/sequel/extensions/constraint_validations.rb, line 307
def alter_table_generator(&block)
  super do
    extend AlterTableGeneratorMethods
    @validations = []
    instance_eval(&block) if block
  end
end
create_constraint_validations_table() click to toggle source

Create the table storing the validation metadata for all of the constraints created by this extension.

# File lib/sequel/extensions/constraint_validations.rb, line 245
def create_constraint_validations_table
  create_table(constraint_validations_table) do
    String :table, :null=>false
    String :constraint_name
    String :validation_type, :null=>false
    String :column, :null=>false
    String :argument
    String :message
    TrueClass :allow_nil
  end
end
create_table_generator(&block) click to toggle source

Modify the default create_table generator to include the constraint validation methods.

# File lib/sequel/extensions/constraint_validations.rb, line 259
def create_table_generator(&block)
  super do
    extend CreateTableGeneratorMethods
    @validations = []
    instance_eval(&block) if block
  end
end
drop_constraint_validations_for(opts=OPTS) click to toggle source

Delete validation metadata for specific constraints. At least one of the following options should be specified:

:table

The table containing the constraint

:column

The column affected by the constraint

:constraint

The name of the related constraint

The main reason for this method is when dropping tables or columns. If you have previously defined a constraint validation on the table or column, you should delete the related metadata when dropping the table or column. For a table, this isn’t a big issue, as it will just result in some wasted space, but for columns, if you don’t drop the related metadata, it could make it impossible to save rows, since a validation for a nonexistent column will be created.

# File lib/sequel/extensions/constraint_validations.rb, line 288
def drop_constraint_validations_for(opts=OPTS)
  ds = from(constraint_validations_table)
  if table = opts[:table]
    ds = ds.where(:table=>constraint_validations_literal_table(table))
  end
  if column = opts[:column]
    ds = ds.where(:column=>column.to_s)
  end
  if constraint = opts[:constraint]
    ds = ds.where(:constraint_name=>constraint.to_s)
  end
  unless table || column || constraint
    raise Error, "must specify :table, :column, or :constraint when dropping constraint validations"
  end
  ds.delete
end
drop_constraint_validations_table() click to toggle source

Drop the constraint validations table.

# File lib/sequel/extensions/constraint_validations.rb, line 268
def drop_constraint_validations_table
  drop_table(constraint_validations_table)
end