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.
Can anyone tell me wwhat is happening?
Thanks,
Mike
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
try search = C.search ''test'' C == Class that implements thinking sphinx finally: search.each do |s| s.post_desc end 2010/8/2 Mike Disuza <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>> 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. > > Can anyone tell me wwhat is happening? > > Thanks, > Mike > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- att: Luciano Sousa http://www.lucianosousa.net *Ruby on Rails Developer *Linux User #456387 *Contato: (21) 7639-5049 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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 Thanks, Mike -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
this is a valid return: *=> [#<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>]** * for access after try: *s.each do |sa|* * sa.post_desc* *end* 2010/8/2 Mike Disuza <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>> 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 > > Thanks, > Mike > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- att: Luciano Sousa http://www.lucianosousa.net *Ruby on Rails Developer *Linux User #456387 *Contato: (21) 7639-5049 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi Mike
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
Cheers
--
Pat
On Aug 2, 11:51 pm, Mike Disuza
<li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>
wrote:> 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.
>
> Can anyone tell me wwhat is happening?
>
> Thanks,
> Mike
> --
> Posted viahttp://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.