diff options
author | Jeremy Kemper <jeremy@bitsweat.net> | 2007-09-16 03:32:47 +0000 |
---|---|---|
committer | Jeremy Kemper <jeremy@bitsweat.net> | 2007-09-16 03:32:47 +0000 |
commit | 30fb7b8c8bfc72ed3097352539544c07cbb38d0d (patch) | |
tree | 10b9d6b1d6ec2c792b8a503bf297a6a4e196ae68 /activerecord/lib/active_record/connection_adapters/abstract | |
parent | 78da29a84f886386c73768fa60609a0090a3a250 (diff) | |
download | rails-30fb7b8c8bfc72ed3097352539544c07cbb38d0d.tar.gz rails-30fb7b8c8bfc72ed3097352539544c07cbb38d0d.tar.bz2 rails-30fb7b8c8bfc72ed3097352539544c07cbb38d0d.zip |
connection.select_rows 'sql' returns an array (rows) of arrays (field values). Closes #2329.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7497 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/lib/active_record/connection_adapters/abstract')
-rw-r--r-- | activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb b/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb index 75dafe61da..effb36faf1 100644 --- a/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb +++ b/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb @@ -23,10 +23,14 @@ module ActiveRecord # Returns an array of the values of the first column in a select: # select_values("SELECT id FROM companies LIMIT 3") => [1,2,3] def select_values(sql, name = nil) - result = select_all(sql, name) - result.map{ |v| v.values.first } + result = select_rows(sql, name) + result.map { |v| v[0] } end + # Returns an array of arrays containing the field values. + # Order is the same as that returned by #columns. + def select_rows(sql, name = nil) end + # Executes the SQL statement in the context of this connection. def execute(sql, name = nil) raise NotImplementedError, "execute is an abstract method" |