Sha256: b341706914c5694eb863f12a7d13e461b54d287bf32f6e68c8a1e7c12e2c17f7
Contents?: true
Size: 1.97 KB
Versions: 4
Compression:
Stored size: 1.97 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) feature.rank.to_sql.should == %Q{(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) feature.conditions.to_sql.should == %Q{((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
4 entries across 4 versions & 1 rubygems