Skip to content

Instantly share code, notes, and snippets.

@rob-murray

rob-murray/rails_sql_migration.rb

Last active November 5, 2015 11:55
Show Gist options
  • Save rob-murray/14b6d68c18dec9aa51ca to your computer and use it in GitHub Desktop.
Save rob-murray/14b6d68c18dec9aa51ca to your computer and use it in GitHub Desktop.
Download ZIP
Rails, execute sql to update something in sql
Raw
rails_sql_migration.rb
say_with_time "Doing an update" do
execute %q{UPDATE somethings SET a_col = 'foo' WHERE other_col IN ('bar', 'foobar')}
end
# or
execute <<-SQL
CREATE UNIQUE INDEX foobars_name_lower_idx ON foobars (LOWER(name));
SQL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment