postgresql - How Do I Use Joins for Three Tables in Ruby on Rails? -



postgresql - How Do I Use Joins for Three Tables in Ruby on Rails? -

i working on ruby on rails application has logic text searching using pg_search , 2 other fields on model. logic creates 'array' of rows search result. not remember actual name of since technically not array. instance variable of selected rows. want add together search criteria 2 additional models. database postgresql.

here subset of 3 model definitions:

medialibrary: name, media_creator_id, media_type_id (fields beingness used in current search; has many media_topics , has many media_targets)

mediatopic: media_library_id, topic_id (want search topic_id; belongs media_library; topic_id beingness searched coming topic model (id, name))

mediatarget: media_library_id, target_id (want search target_id; belongs media_library; target_id beingness searched coming target model (id, name))

i'm thinking should able if both topic , target beingness searched along other 3 search criteria. need have topic_id , target_id in results can display topic.name , target.name on view.

@media_libraries = medialibrary.text_search(params[:query]).where("media_creator_id = ? , media_type_id = ?", params[:media_creator_id].to_i, params[:media_type_id].to_i).joins(:media_topics.where("media_library_id = ? , topic_id = ?", id_from_media_library_row, params[:topic_id].to_i).joins(:media_targets.where("media_library_id = ? , target_id = ?", id_from_media_library_row, params[:target_id].to_i)

i have searched on postgresql.org , stack overflow have not found joining 3 tables using ruby on rails answered anyone.

you can pass sql bring together statement #joins. i'm not sure it'd in case can like:

@media_libraries = medialibrary.joins(%q( bring together media_targets on media_targets.media_library_id = media_libraries.id bring together media_topics on media_topics.media_library_id = media_libraries.id )).text_search(params[:query]) .where( media_libraries: { media_creator_id: params[:media_creator_id], media_type_id: params[:media_type_id] }, media_topics: { id: params[:topic_id] }, )

ruby-on-rails postgresql join pg-search

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more