# app/models/event.rb class Event < ActiveRecord :: Base has_many :user_reviews, dependent: :destroy has_many :media_reviews, dependent: :destroy def self. In my original implementation, I used a class method to gather these statistics: When building the site, I found that I was frequently displaying the average user and media review score for events. Every show (I called them “events”) has many user reviews and many media (or critic) reviews. The Project and the ProblemĪs my capstone project for Metis, I created Bdw圜ritic ( source on GitHub), a review aggregator for Broadway shows, similar to Metacritic. In this post, we’ll take a look at using a Postgres view with Rails to encapsulate data in a repeated aggregate query.
For example, a view could be defined to allow easier querying of a complex join or to filter a relation to include only a subset of data. Views can be used for a number of reasons, most of them related to abstraction. You can query a view just like any other database table, but the fields and values in a view are defined based on the query used to create the view. Most relational databases support the concept of a view, a pre-defined relation that’s essentially a stored query.
#Postgres app rails series#
This post is part of a series sharing my experience and some of the things I’ve learned.
I’m a recent graduate of Metis, a 12-week Ruby on Rails course taught by some great folks from thoughtbot.
0 kommentar(er)
