There are two tables in my project: posts and post_categories. Each post in the posts table has a post_category_id relating to post_categories.id as fk, and each entry in post_categories has a parent_id - self-referencing post_categories.id. On the website, the post…
I know there are a few other similar questions out there, but I cannot seem to make this query work. I have a Rails 7 app with Recipe and Ingredient models joined through a Portions table (see models below). Given…
I have this table called Group. class Group < ApplicationRecord belongs_to :admin, class_name: "User", foreign_key: :admin_id has_many :memberships, dependent: :destroy has_many :users, through: :memberships has_many :tasks, dependent: :destroy has_many :tags, dependent: :destroy has_many :invitations, dependent: :destroy end I am creating…
I have a post ActiveRecord model that has_many comments, but I forgot to add :dependent => :destroy upon declaring it. Now I have several posts with comments and I cannot delete them as I get this error: PG::ForeignKeyViolation: ERROR: update…
I have two models User and Subscription as follows class User < ApplicationRecord has_many :subscriptions end class Subscription < ApplicationRecord belongs_to :user # attributes # name string # premium boolean # ... end Users will be having many subscription. How…
I'm using PostgreSQL with Rails in API mode and I have a row called expired with data type Date and I want to make a trigger that identifies if the expired date is equal to the current date and change…
I have students associated to schools, and want to find all schools that have five or fewer (including zero) students that have has_mohawk = false. Here's an Activerecord query: School.joins(:students) .group(:id) .having("count(students.id) < 5") .where(students: {has_mohawk: true}) This works for…
I have 2 models: class Item < ApplicationRecord has_many :tags, dependent: :destroy end class Tag < ApplicationRecord belongs_to :item end My current query will return Items that have ANY of the tags in a list, I need it to only…
I'm working on a application in which there is table named companies and a company can have multiple users and users can have multiple books and magazines belonging to company. Currently the associations is as follows: Company.rb has_many :users has_many…
I am getting an ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool exception for background jobs in Sidekiq CONFIG I have a PUMA web process and a SIDEKIQ process running on Heroku (2 hobby dynos) [A Rails app with…