Sha256: 33ef7c29aeab3d3b7ccf85d5d4da03d312936d9e460481cd598f802bd79fd2b8
Contents?: true
Size: 1.33 KB
Versions: 7
Compression:
Stored size: 1.33 KB
Contents
# frozen_string_literal: true
require 'singleton'
module Metka
class BaseQuery
include Singleton
def call(model, column_name, tag_list)
tags = tag_list.to_a
if tags.one?
value = Arel::Nodes::SqlLiteral.new(
ActiveRecord::Base.sanitize_sql_for_conditions(['?', tags.first])
)
column_cast = Arel::Nodes::NamedFunction.new(
'ANY',
[model.arel_table[column_name]]
)
Arel::Nodes::Equality.new(value, column_cast)
else
value = Arel::Nodes::SqlLiteral.new(
ActiveRecord::Base.sanitize_sql_for_conditions(['ARRAY[?]::varchar[]', tags])
)
Arel::Nodes::InfixOperation.new(infix_operator, model.arel_table[column_name], value)
end
# column_cast = Arel::Nodes::NamedFunction.new(
# 'CAST',
# [model.arel_table[column_name].as('text[]')]
# )
# value = Arel::Nodes::SqlLiteral.new(
# ActiveRecord::Base.sanitize_sql_for_conditions(['ARRAY[?]::varchar[]', tag_list.to_a])
# )
# value_cast = Arel::Nodes::NamedFunction.new(
# 'CAST',
# [value.as('text[]')]
# )
# # Arel::Nodes::InfixOperation.new(infix_operator, column_cast, value_cast)
# Arel::Nodes::InfixOperation.new(infix_operator, model.arel_table[column_name], value)
end
end
end
Version data entries
7 entries across 7 versions & 1 rubygems