Hi,
I am implementing the "sphinx" search using "Thinking Sphinx" search.
I have done everything configured.
I have added the index fields in my model like this
"
define_index do
indexes :name,:sortable => true
indexes description
has created_at, updated_at
end
"
My sphinx configuration file is as
"
source post_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = development
sql_sock = /var/lib/mysql/mysql.sock
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `posts`.`id` * 1 + 0 AS `id` ,
`posts`.`name` AS `name`, `posts`.`description` AS `description`,
`posts`.`id` AS `sphinx_internal_id`, 1921285768 AS `class_crc`, 0 AS
`sphinx_deleted`, IFNULL(`posts`.`name`, '') AS `name_sort`,
UNIX_TIMESTAMP(`posts`.`created_at`) AS `created_at`,
UNIX_TIMESTAMP(`posts`.`updated_at`) AS `updated_at` FROM `posts`
WHERE `posts`.`id` >= $start AND `posts`.`id` <= $end AND deleted = 0
GROUP BY `posts`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `posts`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_timestamp = created_at
sql_attr_timestamp = updated_at
sql_attr_str2ordinal = name_sort
sql_query_info = SELECT * FROM `posts` WHERE `id` = (($id - 0) / 1)
}"
The searching works well but I am seeing in the log that it is firing a
queri like " SELECT * FROM `posts` WHERE `id` = (1,2)"
Is my configuration right?
Also, if I am doing indexing like " indexes description, :as=>
:post_desc" and if I try to access it like this:-
"search=ThinkingSphinx.search "test"
puts search.post_desc
"
Giving me an error that "post_desc" is undefined.
Hi,
I am tried like this:-
Still no success
s=Post.search "pune"
=> [#<Post id: 3, name: "Neovasolution", description: "This is pune
company", created_at: "2010-07-14 12:17:16", updated_at: "2010-07-14
12:17:16", delta: false>]
>> s.post_desc
NoMethodError: undefined method `desc' for
#<ThinkingSphinx::Search:0xb6f1bde4>
from
/usr/local/ruby/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/thinking_sphinx/search.rb:116:in
`method_missing'
from (irb):2
The reason for the message in the logs is that Thinking Sphinx/Sphinx
only knows the ids of your search results, and needs to load the
actual objects to return - hence why it talks to the database as well.
As for post_desc - this isn't available as a method anywhere (on the
search collection or search results) - the alias you've given that
column is only for Sphinx, not Ruby. So you can use it when searching:
Post.search :conditions => {:post_desc => 'foo'}
But if you want the value of post_desc, you will need to access it as
description:
post = Post.search('foo').first
post ? post.description : 'No Post'
Hope this clarifies things. If you have any more questions, feel free
to ask on the Thinking Sphinx Google Group (I only spotted your posts
here via some noisy twitter bots):
http://groups.google.com/group/thinking-sphinx