Contents

require 'thredded/search_parser'

module Thredded
  class TableSqlBuilder
    attr_accessor :binds

    def initialize(query, messageboard)
      @terms = SearchParser.new(query).parse

      @select = 'SELECT t.id'
      @from = 'FROM topics t'
      @where = ['t.messageboard_id = ?']
      @binds = [messageboard.id]

      @search_categories = []
      @search_users = []
      @search_text = []
    end

    def sql
      build_by_user
      build_in_category
      build_text_search

      [@select,
       @from,
       'WHERE', @where.join(' AND '),
      ].join(' ')
    end

    private

    def is_quoted(term)
      term.count('"') == 2
    end

    def categories
      if @search_categories.any?
        @search_categories
      else
        if @terms['in']
          @terms['in'].each do |category_name|
            category = Category
            .where('lower(name) = ?', category_name.downcase).first
            if category
              @search_categories << category.id
            end
          end
        end

        @search_categories
      end
    end

    def users
      if @search_users.any?
        @search_users
      else

        if @terms['by']
          @terms['by'].each do |username|
            user = User.where('lower(name) = ?', username.downcase).first

            if user
              @search_users << user.id
            end
          end
        end

        @search_users
      end
    end

    def text
      @terms['text']
    end

    def build_by_user
      raise 'SubclassResponsibility'
    end

    def build_in_category
      raise 'SubclassResponsibility'
    end

    def build_text_search
      raise 'SubclassResponsibility'
    end

    def add_from(table)
        if @from.exclude? table
          @from = "#{@from}, #{table}"
        end
    end

    def add_where(where, binds=nil)
      if @where.exclude? where
        @where << where
        if (binds.present?)
          @binds.push(binds)
        end
      end
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
thredded-0.0.1	lib/thredded/table_sql_builder.rb