Contents

# -*- encoding : utf-8 -*-


class Card::Query
  require_dependency 'card/query/spec'
  require_dependency 'card/query/card_spec'
  require_dependency 'card/query/value_spec'  
  require_dependency 'card/query/ref_spec'
  
  include ActiveRecord::QuotingAndMatching


  MODIFIERS = {};  %w{ conj return sort sort_as group dir limit offset }.each{|key| MODIFIERS[key.to_sym] = nil }

  OPERATORS = %w{ != = =~ < > in ~ }.inject({}) {|h,v| h[v]=nil; h }.merge({
    :eq    => '=',   :gt => '>',    :lt      => '<',
    :match => '~',   :ne => '!=',   'not in' => nil
  }.stringify_keys)

  def initialize query
    @card_spec = CardSpec.build query
  end
  
  def query
    @card_spec.query
  end
  
  def sql
    @sql ||= @card_spec.to_sql
  end

  def run
    rows = ActiveRecord::Base.connection.select_all( sql )
    retrn = query[:return].present? ? query[:return].to_s : 'card'
    case retrn 
    when 'card'
      rows.map do |row|
        card=
          if query[:prepend] || query[:append]
            cardname = [query[:prepend], row['name'], query[:append]].compact.join('+')
            Card.fetch cardname, :new=>{}
          else
            Card[ row['name'] ]
          end
        card.nil? ? Card.find_by_name_and_trash(row['name'],false).repair_key : card
      end
    when 'count'
      rows.first['count'].to_i
    when 'raw'
      rows
    else
      rows.map { |row| row[retrn] }
    end
  end



  class SqlCond < String
    def to_sql(*args) self end
  end


  class SqlStatement
    attr_accessor :fields, :relevance_fields, :tables, :joins, :conditions, :group, :order, :limit, :offset

    def initialize
      @fields, @relevance_fields, @joins, @conditions = [],[],[],[]
      @tables, @group, @order, @limit, @offset = "","","","",""
    end

    def to_s
      "(
select #{fields.reject(&:blank?).join(', ')} from #{tables} #{joins.join(' ')}
where #{conditions.reject(&:blank?).join(' and ')} #{group} #{order} #{limit} #{offset}
)"
    end
  end


end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
wagn-1.12.13	lib/card/query.rb
wagn-1.12.12	lib/card/query.rb
wagn-1.12.11	lib/card/query.rb
wagn-1.12.10	lib/card/query.rb
wagn-1.12.9	lib/card/query.rb
wagn-1.12.8	lib/card/query.rb
wagn-1.12.7	lib/card/query.rb