one-2-many relationship in schema

[Michał Łowicki]

Hi!

I've such models:

Model A has foreign key to model B. Model B has field 'b'. Model B can have translations stored in model BTrans so there is one-2-many relationship between B and BTrans.

I now want to search for A's entries by translations. So when user enter something e.g. in polish I want to return appropriate entries from model A.

It's better to have fields in schema like:

b_pl

b_en_gb

b_ru

and so on or maybe one text field which contains all the translations? Or maybe some other solution? Thanks in advance!

--
BR,
Michał Łowicki

[Matt Billenstein]

What about keeping a separate index for each translation? How big is your
data?

m

> MichaAA* AA*owicki
>
> --
> You received this message because you are subscribed to the Google Groups
> "Whoosh" group.
> To post to this group, send email to who...@googlegroups.com.
> To unsubscribe from this group, send email to
> whoosh+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/whoosh?hl=en.

--
Matt Billenstein
ma...@vazor.com
http://www.vazor.com/

[Matt Chaput]

(There is a branch in the repo with "hierarchical documents" that could help here, but it isn't released yet.)

I haven't had to write a system like this, but I would say:

* If your users only need to be able to search in one language at a time, make A documents with separate fields b_pl, b_en_gb, etc., and switch the default language of the query parser to the language the user is searching in.

(You would also be able to compose mixed-language queries like "b_esl:grande b_en_gb:colour")

* If your users usually need to search in any language or mixed languages, index all translations in a single field.

Hope this helps,

Matt