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'

  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
#    puts "~~~~~~~~~~~~~~\nCARD SPEC =\n#{@card_spec.rawspec}\n\n-----\n\nSQL=\n#{sql}"
    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, :tables, :joins, :conditions, :group, :order, :limit, :offset

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

    def to_s
      select = fields.reject(&:blank?) * ', '
      where = conditions.reject(&:blank?) * ' and '
      ['(SELECT', select, 'FROM', tables, joins, 'WHERE', where, group, order, limit, offset, ')'].compact * ' '
    end
  end


end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
wagn-1.14.4	lib/card/query.rb
wagn-1.14.3	lib/card/query.rb
wagn-1.14.2	lib/card/query.rb