Skip to content

Instantly share code, notes, and snippets.

@antlypls
Created February 10, 2011 22:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save antlypls/821483 to your computer and use it in GitHub Desktop.
Save antlypls/821483 to your computer and use it in GitHub Desktop.
def prepare_sql params
ActiveRecord::Base.send 'sanitize_sql_array', params
end
ActiveRecord::Base.connection.execute(prepare_sql ["update users set total_visits = total_visits + ? where id = ?", visits_increment, user_id])
ActiveRecord::Base.connection.execute('update users set total_visits = total_visits + 10 where id = 5')
ActiveRecord::Base.connection.execute("update users set total_visits = total_visits + #{visits_increment} where id = #{user_id}")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment