Simple Rails ActiveRecord stars count query? -

-

this simple question. how retrieve 'rateable_id's sum of stars count 'dimension': foundation in descending order? chain of queries use?

in table rates:

- !ruby/object:rate   attributes:     id: 11     rater_id: 1     rateable_id: 3     rateable_type: bboy     stars: 5.0     dimension: foundation     created_at: 2014-02-25 09:33:23.000000000 z     updated_at: 2014-02-25 09:33:23.000000000 z - !ruby/object:rate   attributes:     id: 12     rater_id: 1     rateable_id: 3     rateable_type: bboy     stars: 5.0     dimension: originality     created_at: 2014-02-25 09:33:24.000000000 z     updated_at: 2014-02-25 09:33:24.000000000 z - !ruby/object:rate   attributes:     id: 13     rater_id: 1     rateable_id: 3     rateable_type: bboy     stars: 5.0     dimension: dynamics     created_at: 2014-02-25 09:33:25.000000000 z     updated_at: 2014-02-25 09:33:25.000000000 z - !ruby/object:rate   attributes:     id: 14     rater_id: 1     rateable_id: 3     rateable_type: bboy     stars: 5.0     dimension: execution     created_at: 2014-02-25 09:33:26.000000000 z     updated_at: 2014-02-25 09:33:26.000000000 z - !ruby/object:rate   attributes:     id: 15     rater_id: 1     rateable_id: 3     rateable_type: bboy     stars: 5.0     dimension: battle     created_at: 2014-02-25 09:33:27.000000000 z     updated_at: 2014-02-25 09:33:27.000000000 z - !ruby/object:rate   attributes:     id: 16     rater_id: 1     rateable_id: 5     rateable_type: bboy     stars: 5.0     dimension: foundation     created_at: 2014-02-25 09:36:30.000000000 z     updated_at: 2014-02-25 09:36:30.000000000 z - !ruby/object:rate   attributes:     id: 17     rater_id: 1     rateable_id: 5     rateable_type: bboy     stars: 5.0     dimension: originality     created_at: 2014-02-25 09:36:31.000000000 z     updated_at: 2014-02-25 09:36:31.000000000 z - !ruby/object:rate   attributes:     id: 18     rater_id: 1     rateable_id: 5     rateable_type: bboy     stars: 5.0     dimension: dynamics     created_at: 2014-02-25 09:36:31.000000000 z     updated_at: 2014-02-25 09:36:31.000000000 z - !ruby/object:rate   attributes:     id: 19     rater_id: 1     rateable_id: 5     rateable_type: bboy     stars: 5.0     dimension: battle     created_at: 2014-02-25 09:36:32.000000000 z     updated_at: 2014-02-25 09:36:32.000000000 z - !ruby/object:rate   attributes:     id: 25     rater_id: 8     rateable_id: 3     rateable_type: bboy     stars: 1.0     dimension: foundation     created_at: 2014-03-04 14:06:46.000000000 z     updated_at: 2014-03-04 14:06:46.000000000 z - !ruby/object:rate   attributes:     id: 26     rater_id: 8     rateable_id: 3     rateable_type: bboy     stars: 1.0     dimension: originality     created_at: 2014-03-04 14:06:49.000000000 z     updated_at: 2014-03-04 14:06:49.000000000 z - !ruby/object:rate   attributes:     id: 27     rater_id: 8     rateable_id: 3     rateable_type: bboy     stars: 1.0     dimension: dynamics     created_at: 2014-03-04 14:06:51.000000000 z     updated_at: 2014-03-04 14:06:51.000000000 z - !ruby/object:rate   attributes:     id: 28     rater_id: 8     rateable_id: 3     rateable_type: bboy     stars: 1.0     dimension: execution     created_at: 2014-03-04 14:06:53.000000000 z     updated_at: 2014-03-04 14:06:53.000000000 z - !ruby/object:rate   attributes:     id: 29     rater_id: 8     rateable_id: 3     rateable_type: bboy     stars: 1.0     dimension: battle     created_at: 2014-03-04 14:06:54.000000000 z     updated_at: 2014-03-04 14:06:54.000000000 z

thank you!i appreciate help!

well, if n-th time i've seen this. way ask it, try this:

rate.where(dimension: "foundation").sum(:stars, group: :rateable_id, order: "sum_stars desc").map{|a,b| {"rateable_id"=>a, "sum_stars"=>b}}

Comments

Post a Comment

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

-
i have implement video collection website users of specific isp. site hosted on public web-server movies hosted on local isp server. user of isp + general visitors can see available movies; isp's users able play them. player on site point url of local machine ( http://192.x.x.x/movies/mymovie.mov ) private class (192.x.x.x) accessible isp user. question: possible phpmotion script? or need custom work. if possible, can please suggest available mods? phpmotion require modifications able handle this. uploading, conversion, thumbnail generation, , playback pretty static in phpmotion. really though, rather modding entire upload , conversion process, if created quick custom form add entries phpmotion database (maybe include thumbnail upload), tweaked playback paths, should go on phpmotion side of things. assume had videos in format player handle (such flv or mp4).
Read more

javascript - Using Windows Media Player as video fallback for video tag -

-
getting video play cross platform using example video.js bit of fuss. in days when video should embedded use embed windows media player, work out of box on windows. since it's today old ie on windows doesn't support video tag experimented using windows media player fallback, , work well. what wonder here is, why haven't else solution? have missed something? code small, there's no flash files, cross domain issues or need of server working. works. so before develop further , add custom control , subtitles support wonder say. the code looks this: <video id="myvideo" style="width:640px; height: 360px;" autoplay data-wimpsource="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.mp4"> <source src="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.mp4" type="video/mp4" /> <source src="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.webm" type="video/webm" />
Read more

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get
Read more