activerecord-mysql-sql-cache

An ActiveRecord extension for enabling SQL_CACHE and SQL_NO_CACHE in MySQL queries

Dependencies

Supported versions:

Ruby 1.9+
ActiveRecord 4.0+ (Arel 4.0+)

Installation

Add this line to your application's Gemfile:

gem 'activerecord-mysql-sql-cache'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-mysql-sql-cache

Usage

Methods that #sql_cache and #sql_no_cache are added into ActiveRecord::Relation.

class Product < ActiveRecord::Base
end

Product.where(id: 1).to_sql
# => SELECT `products`.`*` FROM `products` WHERE `id` = 1;

Product.where(id: 1).sql_cache.to_sql
# => SELECT SQL_CACHE `products`.`*` FROM `products` WHERE `id` = 1;

Product.where(id: 1).sql_no_cache.to_sql
# => SELECT SQL_NO_CACHE `products`.`*` FROM `products` WHERE `id` = 1;

#sql_cache accepts a boolean argument:

# default: true
Product.where(id: 1).sql_cache(true).to_sql
# => SELECT SQL_CACHE `products`.`*` FROM `products` WHERE `id` = 1;

Product.where(id: 1).sql_cache(false).to_sql
# => SELECT SQL_NO_CACHE `products`.`*` FROM `products` WHERE `id` = 1;

Product.where(id: 1).sql_cache(nil).to_sql
# => SELECT `products`.`*` FROM `products` WHERE `id` = 1;

License

Arproxy is released under the MIT license:

www.opensource.org/licenses/MIT