Automatically strip all string fields of an ActiveRecord

Updated . Posted . Visible to the public. Deprecated.

Use the strip_attributes gem instead.

If your application has forms to edit string fields, you probably want to strip the entered values (remove whitespace from beginning and end). The reason is that your users will copy + paste values from unholy places (websites, Microsoft Office) and end up having trailing whitespace in most of their records.

Because browsers ignore whitespace, no one will usually notice this until you get the weirdest bug reports (e.g. two seemingly equal records are not, or multiple records for "unique" values).

Use the attached trait in your model to have it automatically strip all :string fields before validation:

class Organisation < ActiveRecord::Base
  validates_presence_of :name, :city, :phone, :website, ....
  does 'strip_string_fields'
end

Attributes of other types (including :text) are not stripped.

Stripping whitespace from existing records

If you have existing data that needs to be cleaned, do it in a migration, using MySQL's TRIM function:

class StripWhitespaceFromOrganisation < ActiveRecord::Migration
  def change
    update 'UPDATE organisations SET name = TRIM(name), city = TRIM(city), ...'
  end
end
Henning Koch
Last edit
Keywords
columns, trip
License
Source code in this card is licensed under the MIT License.
Posted by Henning Koch to makandra dev (2012-10-18 15:21)