read tables from SQL code

[Bulhac Mihai]

hi,
i have a SQL code like this one:

SELECT Select_List
FROM Table_List
[WITH (BUFFERING = lExpr)]
[WHERE Conditions]
[GROUP BY Column_List]
[UNION Clause]
[HAVING Conditions]
[ORDER BY Column_List]
[INTO Clause | TO Clause ]
[Additional_Display_Options]

can i read/save with ruby the columns involved in that SQL select?

 

[Sharon Rosner]

can i read/save with ruby the columns involved in that SQL select?

If you use Sequel you can retrieve the columns for arbitrary SQL like
this:

require 'sequel/mysql' # assuming you're using MySQL
DB = Sequel('mysql://localhost/mydb')
DB['select * from items'].columns #=> [:id, :name, ...]

But if you're already using Sequel why not construct your queries
using Ruby instead of SQL, e.g.:

dataset = DB.query do
from :items
where {:name =~ /^abc/ && rice < 100}
order_by :name
end
p dataset.columns
dataset.each {|r| p r}

You can find more information about Sequel here:

http://code.google.com/p/ruby-sequel

And you can also get help on Sequel-talk:

http://groups.google.com/group/sequel-talk

best
Sharon

 

[John Joyce]

Ruby DBI will let you do exact SQL, like DBI in other languages.

ActiveRecord can do some of that select statement, but some of it no.
ActiveRecord does have the ability to execute direct SQL statements
though.