Unfortunatelly, yes, I am. среда, 30 октября 2013 г., 17:22:54 UTC+4 пользователь Frederick Cheung написал: > > > > On Wednesday, October 30, 2013 6:19:35 AM UTC, Павел Макаров wrote: >> >> Hello. Would somebody like to answer me on question or give some advice? >> >> In my situation I have to use EAV-model (MySQL database) to deal with >> dynamic attributes (for products: color, weight, height and etc.) >> Model: Product, Option, Value >> >> So, in this case I have relation: product has many options through values. >> It's okay, when I modify and print it. >> >> But what is the best solution for search on them? >> > > Do you have to use Mysql for the search side too? Something like > elasticsearch is good at searching over that sort of dataset. > > Fred > > >> Because I have to have many inner joins with the same table - values >> And each join should have own conditions, for example: >> >>> option_alias1.name = 'color' AND values_alias1.value = '100' >>> AND option_alias2.name = 'weight' AND values_alias2.value < '200' >>> >> >> So, I can't do it by join existing relation many times, because I haven't >> got access to aliases. Should I write raw sql queries or there is more >> convenient way? >> >> Thank you. >> >
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/7c318e17-fae6-45b0-8f8e-09cad307fcf2%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
