method
construct_counter_sql_with_included_associations
v1.1.6 -
Show latest stable
-
0 notes -
Class: ActiveRecord::Associations::ClassMethods
- 1.0.0
- 1.1.6 (0)
- 1.2.6
- 2.0.3
- 2.1.0
- 2.2.1
- 2.3.8
- 3.0.0
- 3.0.9
- 3.1.0
- 3.2.1
- 3.2.8
- 3.2.13
- 4.0.2
- 4.1.8
- 4.2.1
- 4.2.7
- 4.2.9
- 5.0.0.1
- 5.1.7
- 5.2.3
- 6.0.0
- 6.1.3.1
- 6.1.7.7
- 7.0.0
- 7.1.3.2
- 7.1.3.4
- What's this?
construct_counter_sql_with_included_associations(options, join_dependency)
private
Hide source
# File activerecord/lib/active_record/associations.rb, line 1121 def construct_counter_sql_with_included_associations(options, join_dependency) scope = scope(:find) sql = "SELECT COUNT(DISTINCT #{table_name}.#{primary_key})" # A (slower) workaround if we're using a backend, like sqlite, that doesn't support COUNT DISTINCT. if !Base.connection.supports_count_distinct? sql = "SELECT COUNT(*) FROM (SELECT DISTINCT #{table_name}.#{primary_key}" end sql << " FROM #{table_name} " sql << join_dependency.join_associations.collect{|join| join.association_join }.join add_joins!(sql, options, scope) add_conditions!(sql, options[:conditions], scope) add_limited_ids_condition!(sql, options, join_dependency) if !using_limitable_reflections?(join_dependency.reflections) && ((scope && scope[:limit]) || options[:limit]) add_limit!(sql, options, scope) if using_limitable_reflections?(join_dependency.reflections) if !Base.connection.supports_count_distinct? sql << ")" end return sanitize_sql(sql) end