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_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