class Hayfork::DeleteSql

Attributes

bindings[R]
haystack[R]
relation[R]

Public Class Methods

new(haystack, relation, bindings) click to toggle source
# File lib/hayfork/delete_sql.rb, line 5
def initialize(haystack, relation, bindings)
  @haystack = haystack
  @relation = relation
  @bindings = bindings.reject { |binding| binding.key == Hayfork::SEARCH_VECTOR || binding.key == Hayfork::TEXT }
end

Public Instance Methods

to_s()
Alias for: to_sql
to_sql() click to toggle source
# File lib/hayfork/delete_sql.rb, line 11
    def to_sql
      select_statement = relation.select(bindings.map(&:to_s))
      select_statement = select_statement.from("(SELECT OLD.*) \"#{relation.table_name}\"")

      constraints = bindings.map { |binding| "#{haystack.table_name}.#{binding.key}=x.#{binding.key}" }.join(" AND ")

      <<~SQL
        DELETE FROM #{haystack.table_name} USING (#{select_statement.to_sql}) "x" WHERE #{constraints};
      SQL
    end
Also aliased as: to_s