Sha256: 9c52a895c45a8b5f0ffc6ca6959fcb71b853df80ed7ca285325829c510d5cb31
Contents?: true
Size: 1.99 KB
Versions: 7
Compression:
Stored size: 1.99 KB
Contents
require "spec_helper"
describe PgSearch::Features::DMetaphone do
describe "#rank" do
with_model :Model do
table do |t|
t.string :name
t.text :content
end
end
it "returns an expression similar to a TSearch, but wraps the arguments in pg_search_dmetaphone()" do
query = "query"
columns = [
PgSearch::Configuration::Column.new(:name, nil, Model),
PgSearch::Configuration::Column.new(:content, nil, Model),
]
options = {}
config = double(:config, :ignore => [])
normalizer = PgSearch::Normalizer.new(config)
feature = described_class.new(query, options, columns, Model, normalizer)
expect(feature.rank.to_sql).to eq(
%{(ts_rank((to_tsvector('simple', pg_search_dmetaphone(coalesce(#{Model.quoted_table_name}."name"::text, ''))) || to_tsvector('simple', pg_search_dmetaphone(coalesce(#{Model.quoted_table_name}."content"::text, '')))), (to_tsquery('simple', ''' ' || pg_search_dmetaphone('query') || ' ''')), 0))}
)
end
end
describe "#conditions" do
with_model :Model do
table do |t|
t.string :name
t.text :content
end
end
it "returns an expression similar to a TSearch, but wraps the arguments in pg_search_dmetaphone()" do
query = "query"
columns = [
PgSearch::Configuration::Column.new(:name, nil, Model),
PgSearch::Configuration::Column.new(:content, nil, Model),
]
options = {}
config = double(:config, :ignore => [])
normalizer = PgSearch::Normalizer.new(config)
feature = described_class.new(query, options, columns, Model, normalizer)
expect(feature.conditions.to_sql).to eq(
%{((to_tsvector('simple', pg_search_dmetaphone(coalesce(#{Model.quoted_table_name}."name"::text, ''))) || to_tsvector('simple', pg_search_dmetaphone(coalesce(#{Model.quoted_table_name}."content"::text, '')))) @@ (to_tsquery('simple', ''' ' || pg_search_dmetaphone('query') || ' ''')))}
)
end
end
end
Version data entries
7 entries across 7 versions & 1 rubygems