I think You want to test all values with ILIKE function. This is how it’s done in Postgres: select * from table where value ilike any (array[‘%foo%’, ‘%bar%’, ‘%baz%’]); Try to convert to Rails/Ruby syntax like this: myarray_with_percetage_signs = [“name1″,”name2”].map {|val| “%#{val}%” } Product.where(“name ILIKE ANY ( array[?] )”, myarray_with_percetage_signs)
It’s oddly difficult to do this elegantly in Rails. This is the cleanest way I’ve found: post.association(:comments).add_to_target(comment)
Just use a proc, like so: validates :currency_code, :presence => true, :inclusion => { :in => proc { Currency.all_codes } } validates :country_code, :presence => true, :inclusion => { :in => proc { Country.all_codes } } It’s worth noting for anyone else who may stumble across this that the proc also has the record accessible … Read more
For me it was resolved in this way: Select advisory locks: SELECT pid, locktype, mode FROM pg_locks WHERE locktype=”advisory”; SELECT pg_terminate_backend(<PID>);
I believe what you are asking for can be achieved with ActiveSupport::Callbacks. Have a look at set_callback and skip_callback. In order to “force callbacks to get called even if you made no changes to the record”, you need to register the callback to some event e.g. save, validate etc.. set_callback :save, :before, :my_before_save_callback To skip … Read more
For single-item associations: book.reload_author For other associations: author.books.reload http://guides.rubyonrails.org/association_basics.html#controlling-caching In older versions of rails, before Rails 5, you could pass true to an association method as the first parameter to make it reload: author.books(true).
has_one :requester, :class_name => “User”, :foreign_key => “requester_id” This line (from the code that you posted) indicates that the requester is a User, and the table users should contain a column requester_id that is the foreign key toward friend_requests records. The rails error message states that the column requester_id does not exists (you have to … Read more
Try this: scope :engine_parts, lambda { joins(:part_category).merge(PartCategory.engine) } Basically, the result of joins(:part_category) is the join of two models, so you can’t call .engine on it directly, you need to compose scopes in this manner. See Here for more
Keep in mind that the name you give to your strong parameters (employees, employee_ids, etc.) is largely irrelevant because it depends on the name you choose to submit. Strong parameters work no “magic” based upon naming conventions. The reason https://gist.github.com/leemcalilly/a71981da605187d46d96 is throwing an “Unpermitted parameter” error on ’employee_ids’ is because it is expecting an array … Read more
User.column_names Like a lot of things in Rails, it just works 🙂