Get An Array Of Values From The Database
We generally get data from our database through ActiveRecord models:
> Product.where(available: true).pluck(:sku)
[ "efg-1234", "pqr-3455", ... ]
If we need to do a more specialized query, we might reach for execute
:
> ActiveRecord::Base.connection.execute(<<-SQL)
select split_part(sku, '-', 1) product_type
from products
where available = true;
SQL
[{ "product_type" => "efg" }, { "product_type" => "pqr" }, ... ]
The results are bundled up in a predictable, but verbose array of hashes.
We could trim the result down to just the values using either select_values
or select_rows
:
> ActiveRecord::Base.connection.select_values(<<-SQL)
select split_part(sku, '-', 1) product_type
from products
where available = true;
SQL
[ "efg", "pqr", ... ]
If the SQL statement is to return more than one row in the result, then you'll want select_rows
instead of select_values
.
Last updated
Was this helpful?