method

count

v3.0.0 - Show latest stable - 0 notes - Class: ActiveRecord::Associations::AssociationCollection

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1 (0)
2.3.8 (0)
3.0.0 (0)
3.0.9 (-1)
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?

count(column_name = nil, options = {}) public

Count all records using SQL. If the :counter_sql option is set for the association, it will be used for the query. If no :counter_sql was supplied, but :finder_sql was set, the descendant’s construct_sql method will have set :counter_sql automatically. Otherwise, construct options and pass them with scope to the target class’s count.

Show source

# File activerecord/lib/active_record/associations/association_collection.rb, line 185
      def count(column_name = nil, options = {})
        column_name, options = nil, column_name if column_name.is_a?(Hash)

        if @reflection.options[:counter_sql] && !options.blank?
          raise ArgumentError, "If finder_sql/counter_sql is used then options cannot be passed"
        elsif @reflection.options[:counter_sql]
          @reflection.klass.count_by_sql(@counter_sql)
        else

          if @reflection.options[:uniq]
            # This is needed because 'SELECT count(DISTINCT *)..' is not valid SQL.
            column_name = "#{@reflection.quoted_table_name}.#{@reflection.klass.primary_key}" unless column_name
            options.merge!(:distinct => true)
          end

          value = @reflection.klass.send(:with_scope, construct_scope) { @reflection.klass.count(column_name, options) }

          limit  = @reflection.options[:limit]
          offset = @reflection.options[:offset]

          if limit || offset
            [ [value - offset.to_i, 0].max, limit.to_i ].min
          else
            value
          end
        end
      end

count

Related methods