Contents

class Simple::SQL::Connection::Scope
  EXACT_COUNT_THRESHOLD = 10_000

  # Returns the exact count of matching records
  def count
    sql = order_by(nil).to_sql(pagination: false)

    @connection.ask("SELECT COUNT(*) FROM (#{sql}) _total_count", *args)
  end

  # Returns the fast count of matching records
  #
  # For counts larger than EXACT_COUNT_THRESHOLD this returns an estimate
  def count_estimate
    estimate = estimated_count
    return estimate if estimate > EXACT_COUNT_THRESHOLD

    sql = order_by(nil).to_sql(pagination: false)
    @connection.ask("SELECT COUNT(*) FROM (#{sql}) _total_count", *args)
  end

  # returns the query plan as a Hash.
  def explain
    sql = to_sql(pagination: false)
    explanation = @connection.ask("EXPLAIN (FORMAT JSON) #{sql}", *args).first || {}
    explanation["Plan"]
  end

  private

  def estimated_count
    order_by(nil).explain.fetch("Plan Rows", -1)
  end
end

Version data entries

29 entries across 29 versions & 1 rubygems

Version	Path
simple-sql-0.5.37	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.36	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.35	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.34	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.33	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.32	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.31	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.30	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.29	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.28	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.27	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.26	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.25	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.24	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.23	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.22	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.21	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.20	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.19	lib/simple/sql/connection/scope/count.rb
simple-sql-0.5.18	lib/simple/sql/connection/scope/count.rb