module Sequel::Plugins::ValidationHelpers::InstanceMethods

  1. lib/sequel/plugins/validation_helpers.rb

Public Instance methods

validates_exact_length(exact, atts, opts=OPTS)

Check that the attribute values are the given exact length.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
 99 def validates_exact_length(exact, atts, opts=OPTS)
100   validatable_attributes_for_type(:exact_length, atts, opts){|a,v,m| validation_error_message(m, exact) if v.nil? || v.length != exact}
101 end
validates_format(with, atts, opts=OPTS)

Check the string representation of the attribute value(s) against the regular expression with.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
104 def validates_format(with, atts, opts=OPTS)
105   validatable_attributes_for_type(:format, atts, opts){|a,v,m| validation_error_message(m, with) unless v.to_s =~ with}
106 end
validates_includes(set, atts, opts=OPTS)

Check attribute value(s) is included in the given set.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
109 def validates_includes(set, atts, opts=OPTS)
110   validatable_attributes_for_type(:includes, atts, opts){|a,v,m| validation_error_message(m, set) unless set.public_send(set.respond_to?(:cover?) ? :cover? : :include?, v)}
111 end
validates_integer(atts, opts=OPTS)

Check attribute value(s) string representation is a valid integer.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
114 def validates_integer(atts, opts=OPTS)
115   validatable_attributes_for_type(:integer, atts, opts) do |a,v,m|
116     begin
117       Kernel.Integer(v.to_s)
118       nil
119     rescue
120       validation_error_message(m)
121     end
122   end
123 end
validates_length_range(range, atts, opts=OPTS)

Check that the attribute values length is in the specified range.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
126 def validates_length_range(range, atts, opts=OPTS)
127   validatable_attributes_for_type(:length_range, atts, opts){|a,v,m| validation_error_message(m, range) if v.nil? || !range.cover?(v.length)}
128 end
validates_max_length(max, atts, opts=OPTS)

Check that the attribute values are not longer than the given max length.

Accepts a :nil_message option that is the error message to use when the value is nil instead of being too long.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
134 def validates_max_length(max, atts, opts=OPTS)
135   validatable_attributes_for_type(:max_length, atts, opts) do |a,v,m|
136     if v.nil?
137       validation_error_message(opts[:nil_message] || default_validation_helpers_options(:max_length)[:nil_message])
138     elsif v.length > max
139       validation_error_message(m, max)
140     end
141   end
142 end
validates_min_length(min, atts, opts=OPTS)

Check that the attribute values are not shorter than the given min length.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
145 def validates_min_length(min, atts, opts=OPTS)
146   validatable_attributes_for_type(:min_length, atts, opts){|a,v,m| validation_error_message(m, min) if v.nil? || v.length < min}
147 end
validates_no_null_byte(atts, opts=OPTS)

Check attribute value(s) does not contain a null (“0”, ASCII NUL) byte.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
155 def validates_no_null_byte(atts, opts=OPTS)
156   validatable_attributes_for_type(:no_null_byte, atts, opts){|a,v,m| validation_error_message(m) if String === v && v.include?("\0")}
157 end
validates_not_null(atts, opts=OPTS)

Check attribute value(s) are not NULL/nil.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
150 def validates_not_null(atts, opts=OPTS)
151   validatable_attributes_for_type(:not_null, atts, opts){|a,v,m| validation_error_message(m) if v.nil?}
152 end
validates_numeric(atts, opts=OPTS)

Check attribute value(s) string representation is a valid float.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
160 def validates_numeric(atts, opts=OPTS)
161   validatable_attributes_for_type(:numeric, atts, opts) do |a,v,m|
162     begin
163       Kernel.Float(v.to_s)
164       nil
165     rescue
166       validation_error_message(m)
167     end
168   end
169 end
validates_operator(operator, rhs, atts, opts=OPTS)

Check attribute value(s) against a specified value and operation, e.g. validates_operator(:>, 3, :value) validates that value > 3.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
173 def validates_operator(operator, rhs, atts, opts=OPTS)
174   validatable_attributes_for_type(:operator, atts, opts){|a,v,m| validation_error_message(m, operator, rhs) if v.nil? || !v.public_send(operator, rhs)}
175 end
validates_presence(atts, opts=OPTS)

Check attribute value(s) is not considered blank by the database, but allow false values.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
200 def validates_presence(atts, opts=OPTS)
201   validatable_attributes_for_type(:presence, atts, opts){|a,v,m| validation_error_message(m) if model.db.send(:blank_object?, v) && v != false}
202 end
validates_schema_types(atts=keys, opts=OPTS)

Validates for all of the model columns (or just the given columns) that the column value is an instance of the expected class based on the column’s schema type.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
180 def validates_schema_types(atts=keys, opts=OPTS)
181   Array(atts).each do |k|
182     if type = schema_type_class(k)
183       validates_type(type, k, {:allow_nil=>true}.merge!(opts))
184     end
185   end
186 end
validates_type(klass, atts, opts=OPTS)

Check if value is an instance of a class. If klass is an array, the value must be an instance of one of the classes in the array.

[show source]
    # File lib/sequel/plugins/validation_helpers.rb
190 def validates_type(klass, atts, opts=OPTS)
191   klass = klass.to_s.constantize if klass.is_a?(String) || klass.is_a?(Symbol)
192   validatable_attributes_for_type(:type, atts, opts) do |a,v,m|
193     if klass.is_a?(Array) ? !klass.any?{|kls| v.is_a?(kls)} : !v.is_a?(klass)
194       validation_error_message(m, klass)
195     end
196   end
197 end

Checks that there are no duplicate values in the database for the given attributes. Pass an array of fields instead of multiple fields to specify that the combination of fields must be unique, instead of that each field should have a unique value.

This means that the code:

validates_unique([:column1, :column2])

validates the grouping of column1 and column2 while

validates_unique(:column1, :column2)

validates them separately.

You can pass a block, which is yielded the dataset in which the columns must be unique. So if you are doing a soft delete of records, in which the name must be unique, but only for active records:

validates_unique(:name){|ds| ds.where(:active)}

You should also add a unique index in the database, as this suffers from a fairly obvious race condition.

This validation does not respect the :allow_* options that the other validations accept, since it can deal with a grouping of multiple attributes.

Possible Options:


The base dataset to use for the unique query, defaults to the model’s dataset.


The message to use (default: ‘is already taken’)


Only check the uniqueness if the object is new or one of the columns has been modified, true by default.


A callable object where call takes three arguments, a dataset, the current object, and an array of columns, and should return a modified dataset that is filtered to include only rows with the same values as the current object for each column in the array.

If you want to do a case insensitive uniqueness validation on a database that is case sensitive by default, you can use:

validates_unique :column, where:(lambda do |ds, obj, cols|
  ds.where( do |c|
    v = obj.public_send(c)
    v = v.downcase if v
    [Sequel.function(:lower, c), v]
[show source]
    # File lib/sequel/plugins/validation_helpers.rb
248 def validates_unique(*atts)
249   opts = default_validation_helpers_options(:unique)
250   if atts.last.is_a?(Hash)
251     opts = opts.merge(atts.pop)
252   end
253   message = validation_error_message(opts[:message])
254   from_values = opts[:from] == :values
255   where = opts[:where]
256   atts.each do |a|
257     arr = Array(a)
258     next if arr.any?{|x| errors.on(x)}
259     cc = changed_columns
260     next if opts.fetch(:only_if_modified, true) && !new? && !arr.any?{|x| cc.include?(x)}
261     ds = opts[:dataset] || model.dataset
262     ds = if where
263, self, arr)
264     else
265       vals ={|x| from_values ? values[x] : get_column_value(x)}
266       next if vals.any?(&:nil?)
267       ds.where(
268     end
269     ds = yield(ds) if defined?(yield)
270     unless new?
271       h = ds.joined_dataset? ? qualified_pk_hash : pk_hash
272       ds = ds.exclude(h)
273     end
274     errors.add(a, message) unless ds.count == 0
275   end
276 end