Skip to content
GitLab
    • Explore Projects Groups Snippets
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • T torque-postgresql
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 6
    • Issues 6
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Carlos
  • torque-postgresql
  • Wiki
  • Has Many
Last edited by Carlos 5 years ago
Page history

Has Many

Finally my database won't have those pointless join tables. This is one of my most-wanted features.

Has many connected through an array. PostgreSQL allows us to use arrays, Rails also allows us to use arrays, but why we have never been able to use them on associations. Well, honestly it was a bit hard to develop this feature, but the magic that it can do worth it.

The idea is simple, one table stores all the ids and the other one says that has many records on that table because its records ids exist in the column of the array. Like: Tag has many Videos connected through an array. PostgreSQL Docs

How it works

Migration

A bit different than the usual has_many, the class that invokes it, doesn't hold the foreign key. Actually, the foreign table that stores the foreign keys.

create_table "tag" do |t|
  t.string "name"
end

# For this version 1.0.0, the references with array: true is not enabled
create_table "video" do |t|
  t.bigint "tag_ids", array: true
  t.string "title"
end

Model

Now go to your model and simply activate the feature very similar to the old way, which just the extra array: true option.

# models/tag.rb
class Tag < ApplicationRecord
  has_many :videos, array: true
end

All the original features from the has_many association are available, preloading inclusive. You can check the methods on the Associations Docs from Rails.

One important notice is that polymorphic is not allowed for array-like associations, because the tuples can be guaranteed every time.

There's no extra or additional provided method, only some for metaprogramming if necessary.

Clone repository
  • Wiki
  • Configuring

Core Extensions

  • Range

Data types

  • Enum
  • Enum Set
  • Interval
  • Date/Time Range
  • Box
  • Circle
  • Line
  • Segment

Querying

  • Arel
  • Has Many
  • Belongs to Many
  • Dynamic Attributes
  • Distinct On
  • Auxiliary Statements
  • Inherited Tables

Menu

Explore Projects Groups Snippets