I have a list of names and I need to get their unique ID's with ruby shell.
Example:
User.find_by(name: "James").id
Output:
=> 265
So I need to do something like:
User.find_by(name: "James").id && User.find_by(name: "Robert").id && User.find_by(name: "William").id
In order to get this output:
=> 265
=> 726
=> 24
What's the && for Ruby shell commands??
&& is a logical/boolean "AND". The fact that these work in your example is due to how Ruby deals with truthy/falsy values – you can read the details here: https://www.rubyguides.com/2019/02/ruby-booleans/.
To hopefully answer your questions: I would go with an SQL inclusion operation somewhat like this:
relation = User.where(name: ["James", "Robert", "William"])
# If you really just are looking for the IDs, you can use this the following.
# Note that the order of the IDs isn't the same as the input parameters,
# so if you receive back 1, 5, 10, that doesn't mean that James = 1,
# Robert = 5 and William = 10. If you need a certain order, you need to
# add an `order` clause.
puts relation.ids
# If you want to do more with the result than just have its IDs, you can
# iterate over it like so:
relation.each do |user|
puts "#{user.name}: #{user.id}"
end
]) also since the OP is looking for the ids there is literally a method called idsIf you really want that result:
=> 265
=> 726
=> 24
You can try something like that:
> ids = User.where(name:['James','Robert', 'William']).order(:name).ids
> puts ids
265
726
24
find_by will always return a single result if present.
You need to use where.
Try the below code:
User.where("name like ? or name like ? or name like ?","%James%", "%Robert%", "%William").pluck(:id)
James, Robert and William are directly interpolated and therefore presumed to be constants (which don't exist). Moreover, it's strongly discouraged to directly interpolate values in SQL because it can lead to SQL injection vulnerabilities.
User.where(name: ['James'. 'Robert', 'William']).ids. ids%PATH%environment variable has been modified to include the installation directory of Ruby.