diff options
author | Rafael França <rafaelmfranca@gmail.com> | 2018-11-28 18:07:24 -0500 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-11-28 18:07:24 -0500 |
commit | 89595aff8ee6d7dd05f84570a84aa9b4232a5207 (patch) | |
tree | 4bc21f6f301b4d26e282e7d8d262ffa267beae72 /activerecord/lib/active_record/querying.rb | |
parent | 17abc668bb3b7a7b3febe10315654da8aa8102a1 (diff) | |
parent | 96f6a59d8ef819f6fbacd745638142555a08ecf2 (diff) | |
download | rails-89595aff8ee6d7dd05f84570a84aa9b4232a5207.tar.gz rails-89595aff8ee6d7dd05f84570a84aa9b4232a5207.tar.bz2 rails-89595aff8ee6d7dd05f84570a84aa9b4232a5207.zip |
Merge pull request #34562 from ruralocity/active-record-query-docs-improvement
Improve ActiveRecord::Querying documentation [ci skip]
Diffstat (limited to 'activerecord/lib/active_record/querying.rb')
-rw-r--r-- | activerecord/lib/active_record/querying.rb | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/activerecord/lib/active_record/querying.rb b/activerecord/lib/active_record/querying.rb index 0c55284f4c..8c1b2e2be1 100644 --- a/activerecord/lib/active_record/querying.rb +++ b/activerecord/lib/active_record/querying.rb @@ -16,17 +16,17 @@ module ActiveRecord delegate :pluck, :pick, :ids, to: :all # Executes a custom SQL query against your database and returns all the results. The results will - # be returned as an array with columns requested encapsulated as attributes of the model you call - # this method from. If you call <tt>Product.find_by_sql</tt> then the results will be returned in + # be returned as an array, with the requested columns encapsulated as attributes of the model you call + # this method from. For example, if you call <tt>Product.find_by_sql</tt>, then the results will be returned in # a +Product+ object with the attributes you specified in the SQL query. # - # If you call a complicated SQL query which spans multiple tables the columns specified by the + # If you call a complicated SQL query which spans multiple tables, the columns specified by the # SELECT will be attributes of the model, whether or not they are columns of the corresponding # table. # - # The +sql+ parameter is a full SQL query as a string. It will be called as is, there will be - # no database agnostic conversions performed. This should be a last resort because using, for example, - # MySQL specific terms will lock you to using that particular database engine or require you to + # The +sql+ parameter is a full SQL query as a string. It will be called as is; there will be + # no database agnostic conversions performed. This should be a last resort because using + # database-specific terms will lock you into using that particular database engine, or require you to # change your call if you switch engines. # # # A simple SQL query spanning multiple tables @@ -61,7 +61,9 @@ module ActiveRecord # Returns the result of an SQL statement that should only include a COUNT(*) in the SELECT part. # The use of this method should be restricted to complicated SQL queries that can't be executed - # using the ActiveRecord::Calculations class methods. Look into those before using this. + # using the ActiveRecord::Calculations class methods. Look into those before using this method, + # as it could lock you into a specific database engine or require a code change to switch + # database engines. # # Product.count_by_sql "SELECT COUNT(*) FROM sales s, customers c WHERE s.customer_id = c.id" # # => 12 |