btw~ (=ﾟωﾟ)ﾉ
indexer
{
}
searchd
{
listen = 127.0.0.1:9312:mysql41
log = /home/frank/Dropbox/projects/testing/log/development.searchd.log
query_log =
/home/frank/Dropbox/projects/testing/log/development.searchd.query.log
pid_file = /home/frank/Dropbox/projects/testing/log/development.sphinx.pid
workers = threads
binlog_path = /home/frank/Dropbox/projects/testing/log
}
index conversation_tenant1_core
{
type = rt
path =
/home/frank/Dropbox/projects/testing/db/sphinx/development/conversation_tenant1_core
docinfo = extern
charset_type = utf-8
charset_table = 0..9, U+27,etc
min_prefix_len = 1
enable_star = 1
ngram_len = 1
ngram_chars = U+3400, etc
rt_field = sphinx_internal_class_name
rt_field = post_content
rt_field = topic_name
rt_field = title
rt_attr_uint = sphinx_deleted
rt_attr_uint = network_id
rt_attr_uint = user_id
rt_attr_uint = current_user_id
rt_attr_uint = group_id
rt_attr_bigint = sphinx_internal_id
rt_attr_timestamp = created_at
rt_attr_timestamp = updated_at
rt_attr_string = sphinx_internal_class
}
Frank H於 2015年5月13日星期三 UTC+8下午6時41分51秒寫道：
>
> *sure~ (btw there was a date format i had no choice to map it into a
> string xD)*
>
> *lots of gratitude~ ◑ω◐*
>
>
> current_tenant = Apartment::Tenant.current
>
>
> *# Each Tenant instance is tied to a tenant in this example.*
>
> Tenant.find_each *do* |tenant|
>
> *# Switch to the appropriate Apartment tenant.*
>
> Apartment::Tenant.switch! tenant.db
>
>
> *#ThinkingSphinx::Index.define :topic, :with => :active_record, :delta
> => true do*
>
> ThinkingSphinx::Index.define(
>
> *:topic*,
>
> *# with: :active_record,*
>
> *# delta: true,*
>
> *name*: "topic_*#{*tenant.db*}*",
>
> *offset_as*: "topic_*#{*tenant.db*}*".to_sym,
>
> *with*: *:real_time* )*do*
>
>
> *# fields*
>
> indexes name *#, **sortable**: true*
>
>
> *# attributes*
>
> has network_id, *:type* => *:integer*
>
> has created_at, updated_at, *:type* => *:timestamp*
>
>
> *# For real-time indices, let's make sure we're using the appropriate
> tenant.*
>
> scope { Apartment::Tenant.switch! tenant.db; Topic }
>
> *end*
>
> *end* *if* Tenant.table_exists?
>
>
> *# Switching back to the original tenant - this is useful in the
> development*
>
> *# environment, as indices (and thus, this file) can be reloaded, and we
> don't*
>
> *# want to always leave our app on our last tenant.*
>
> Apartment::Tenant.switch! current_tenant
>
> Pat Allan於 2015年5月13日星期三 UTC+8下午6時33分46秒寫道：
>>
>> Can you share your current index definition?
>>
>> —
>> Pat
>>
>> On 13 May 2015, at 8:30 pm, Frank H <[email protected]> wrote:
>>
>> *btw i've changed the strings into correct type~ (**integer and
>> timestamp**) **(=^ェ^=)*
>>
>> Frank H於 2015年5月13日星期三 UTC+8下午6時29分05秒寫道：
>>>
>>> *dear Pat&All~ btw*
>>>
>>> *i'm almost there but here comes another error~*
>>>
>>> *TypeError: can't convert ThinkingSphinx::ActiveRecord::Column to
>>> String *
>>>
>>> *(ThinkingSphinx::ActiveRecord::Column#to_str gives
>>> ThinkingSphinx::ActiveRecord::Column) *
>>>
>>> *(line 5)*
>>>
>>>
>>> and attachment is where my error came from~ pls help~ very
>>> appreciate~~ (*≧∇≦*)
>>>
>>> Pat Allan於 2015年5月12日星期二 UTC+8下午4時26分14秒寫道：
>>>>
>>>> Have you got callbacks in the models you’re indexing, to ensure the
>>>> data is being saved to Sphinx?
>>>>
>>>> And have you run `rake ts:regenerate` to get all the indices set up and
>>>> existing records indexed?
>>>>
>>>> —
>>>> Pat
>>>>
>>>> On 12 May 2015, at 6:01 pm, Frank H <[email protected]> wrote:
>>>>
>>>> excuse me~
>>>> i figured out select from index name is formal~
>>>> it's Sphinx Query not MySQL query ｘＤ
>>>> but now here comes another issue~
>>>> i found that i'm indexing nothing~ always 0 result~~
>>>>
>>>> Frank H於 2015年5月11日星期一 UTC+8下午7時49分44秒寫道：
>>>>>
>>>>> dear Pat&All how can i define a index whose name is different from
>>>>> it's table name by real_time~ appreciate~ ◑ω◐
>>>>> i've worked hard to approach this:
>>>>>
>>>>> http://www.rubydoc.info/github/pat/thinking-sphinx/ThinkingSphinx/Index#define-class_method
>>>>> i'm using the apartment to do the multitenancy~ my code is as
>>>>> following~ sorry for disturbing~ have a good one~ d(-_^)
>>>>>
>>>>> current_tenant = Apartment::Tenant.current
>>>>>
>>>>> *# Each Tenant instance is tied to a tenant in this example.*
>>>>>
>>>>> Tenant.find_each *do* |tenant|
>>>>>
>>>>> *# Switch to the appropriate Apartment tenant.*
>>>>>
>>>>> Apartment::Tenant.switch tenant.db
>>>>>
>>>>>
>>>>> ThinkingSphinx::Index.define(
>>>>>
>>>>> *:topic*,
>>>>>
>>>>> *# with: :active_record,*
>>>>>
>>>>> *# delta: true,*
>>>>>
>>>>> *name*: "topic_*#{*tenant.db*}*",
>>>>>
>>>>> *table_name: "topic",(wanted) *
>>>>>
>>>>> *offset_as*: "topic_*#{*tenant.db*}*".to_sym,
>>>>>
>>>>> *with*: *:real_time* )*do*
>>>>>
>>>>>
>>>>> *# fields*
>>>>>
>>>>> indexes name, *sortable*: *true*
>>>>>
>>>>>
>>>>> *# attributes*
>>>>>
>>>>> has network_id,created_at, updated_at, *:type* => *:string*
>>>>>
>>>>>
>>>>> *# For real-time indices, let's make sure we're using the
>>>>> appropriate tenant.*
>>>>>
>>>>> scope { Apartment::Tenant.switch tenant.db; Topic }
>>>>>
>>>>> *end*
>>>>>
>>>>> *end* *if* Tenant.table_exists?
>>>>>
>>>>>
>>>>> *# Switching back to the original tenant - this is useful in the
>>>>> development*
>>>>>
>>>>> *# environment, as indices (and thus, this file) can be reloaded, and
>>>>> we don't*
>>>>>
>>>>> *# want to always leave our app on our last tenant.*
>>>>>
>>>>> Apartment::Tenant.switch current_tenant
>>>>>
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Thinking Sphinx" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>>
>>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Thinking Sphinx" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
