Contents

module HasMachineTags
  module TagConsole #:nodoc:
    def self.included(base)
      base.class_eval %[
        named_scope :namespace_counts, :select=>'*, namespace as counter, count(namespace) as count', :group=>"namespace HAVING count(namespace)>=1"
        named_scope :predicate_counts, :select=>'*, predicate as counter, count(predicate) as count', :group=>"predicate HAVING count(predicate)>=1"
        named_scope :value_counts, :select=>'*, value as counter, count(value) as count', :group=>"value HAVING count(value)>=1"
        named_scope :distinct_namespaces, :select=>"distinct namespace"
        named_scope :distinct_predicates, :select=>"distinct predicate"
        named_scope :distinct_values, :select=>"distinct value"
      ]
      base.extend ClassMethods
    end
    
    module ClassMethods
      #:stopdoc:
      def namespaces; distinct_namespaces.map(&:namespace).compact; end
      def predicates; distinct_predicates.map(&:predicate).compact; end
      def values; distinct_values.map(&:value).compact; end
      #:startdoc:
  
      # To be used with the *counts methods.
      # For example:
      #   stat(:namespace_counts) 
      # This prints out pairs of a namespaces and their counts in the tags table.
      def stat(type)
        shortcuts = {:n=>:namespace_counts, :p=>:predicate_counts, :v=>:value_counts }
        send(shortcuts[type] || type).map {|e| [e.counter, e.count] }
      end
    end
  end
end

Version data entries

2 entries across 2 versions & 2 rubygems

Version	Path
cldwalker-has_machine_tags-0.1.5	lib/has_machine_tags/tag_console.rb
has_machine_tags-0.1.6	lib/has_machine_tags/tag_console.rb