Method: Myq::Core#count

Defined in:
lib/myq/core.rb

#count(table, keys) ⇒ Object



67
68
69
70
71
# File 'lib/myq/core.rb', line 67

def count(table, keys)
  select_query = keys.empty? ? '' : "#{keys.join(',')},"
  group_by_query = keys.empty? ? '' : "group by #{keys.join(',')}"
  query(%Q{select #{select_query} count(*) as count from #{table} #{group_by_query} order by count desc})
end