PostgreSQL Array column + has_many association

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

PostgreSQL Array column + has_many association

Carlos Ferreira da Silva
I'm trying to use an array column to crete an association between 2 models. I remember that in the past this was working, but I think something has changed and now it's not working anymore. Here is the deal:

Ruby 2.4.3p205 (2017-12-14 revision 61247) [x86_64-linux]
Rails 5.1.5

app/models/user.rb
# Having the columns id, name, email
class User < ApplicationRecord
end

app/models/group.rb
# Having the columns id, name, user_ids[]
class Group < ApplicationRecord
  has_many
:users, primary_key: :user_ids, foreign_key: :id
end

And the oddest thing about this is that the following works fine:
Group.first.users

It gives me the list of the users with the ids filled on that field, but the following doesn't work:
Group.first.users.load

It gives me an empty list. And, since the load method doesn't work, I cannot do any operation like #each or #to_a.
I already did some dig up, and found the source of the problem here:
https://github.com/rails/rails/blob/v5.1.5/activerecord/lib/active_record/associations/association_scope.rb#L79

The first command don't replace the original value by a Replaceable, the second does. Maybe we just need a ReplaceableArray or something like that, or I'm missing something here.

Can anyone help me with that?

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/e738c301-61d2-490a-928b-ad8ff511b9de%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.